pgsql: Revert "Remove reset of testtablespace from pg_regress on Window

2020-07-10 Thread Michael Paquier
Revert "Remove reset of testtablespace from pg_regress on Windows" This reverts commit 2b2a070, that moved the reset of path "testtablespace" used by the regression tests as a path for tablespaces (via --outputdir) from pg_regress to the MSVC script vcregress.pl, as this broke the behavior added b

Re: pgsql: Remove reset of testtablespace from pg_regress on Windows

2020-07-10 Thread Michael Paquier
On Thu, Jul 09, 2020 at 10:21:57PM -0400, Andrew Dunstan wrote: > I certainly agree we should document more clearly why it's there, to > help forestall anyone else who comes along and thinks it would just be > neater to remove it. so +1. Okay. Done, then. -- Michael signature.asc Description: P

pgsql: Add missing tags in application doc

2020-07-10 Thread Peter Eisentraut
Add missing tags in application doc s Most of them already have this, but some were missing. Author: Author: Dagfinn Ilmari Mannsåker Discussion: https://www.postgresql.org/message-id/flat/87o8pco34z.fsf%40wibble.ilmari.org Branch -- master Details --- https://git.postgresql.org/pg/c

pgsql: Doc: update or remove dead external links.

2020-07-10 Thread Tom Lane
Doc: update or remove dead external links. Re-point comp.ai.genetic FAQ link to a more stable address. Remove stale links to AIX documentation; we don't really need to tell AIX users how to use their systems. Remove stale links to HP documentation about SSL. We've had to update those twice befo

pgsql: Doc: update or remove dead external links.

2020-07-10 Thread Tom Lane
Doc: update or remove dead external links. Re-point comp.ai.genetic FAQ link to a more stable address. Remove stale links to AIX documentation; we don't really need to tell AIX users how to use their systems. Remove stale links to HP documentation about SSL. We've had to update those twice befo

pgsql: Doc: update or remove dead external links.

2020-07-10 Thread Tom Lane
Doc: update or remove dead external links. Re-point comp.ai.genetic FAQ link to a more stable address. Remove stale links to AIX documentation; we don't really need to tell AIX users how to use their systems. Remove stale links to HP documentation about SSL. We've had to update those twice befo

pgsql: Doc: update or remove dead external links.

2020-07-10 Thread Tom Lane
Doc: update or remove dead external links. Re-point comp.ai.genetic FAQ link to a more stable address. Remove stale links to AIX documentation; we don't really need to tell AIX users how to use their systems. Remove stale links to HP documentation about SSL. We've had to update those twice befo

pgsql: Doc: update or remove dead external links.

2020-07-10 Thread Tom Lane
Doc: update or remove dead external links. Re-point comp.ai.genetic FAQ link to a more stable address. Remove stale links to AIX documentation; we don't really need to tell AIX users how to use their systems. Remove stale links to HP documentation about SSL. We've had to update those twice befo

pgsql: Doc: update or remove dead external links.

2020-07-10 Thread Tom Lane
Doc: update or remove dead external links. Re-point comp.ai.genetic FAQ link to a more stable address. Remove stale links to AIX documentation; we don't really need to tell AIX users how to use their systems. Remove stale links to HP documentation about SSL. We've had to update those twice befo

pgsql: Doc: update or remove dead external links.

2020-07-10 Thread Tom Lane
Doc: update or remove dead external links. Re-point comp.ai.genetic FAQ link to a more stable address. Remove stale links to AIX documentation; we don't really need to tell AIX users how to use their systems. Remove stale links to HP documentation about SSL. We've had to update those twice befo

pgsql: Forbid numeric NaN in jsonpath

2020-07-10 Thread Alexander Korotkov
Forbid numeric NaN in jsonpath SQL standard doesn't define numeric Inf or NaN values. It appears even more ridiculous to support then in jsonpath assuming JSON doesn't support these values as well. This commit forbids returning NaN from .double(), which was previously allowed. NaN can't be resu

pgsql: Forbid numeric NaN in jsonpath

2020-07-10 Thread Alexander Korotkov
Forbid numeric NaN in jsonpath SQL standard doesn't define numeric Inf or NaN values. It appears even more ridiculous to support then in jsonpath assuming JSON doesn't support these values as well. This commit forbids returning NaN from .double(), which was previously allowed. NaN can't be resu

pgsql: Forbid numeric NaN in jsonpath

2020-07-10 Thread Alexander Korotkov
Forbid numeric NaN in jsonpath SQL standard doesn't define numeric Inf or NaN values. It appears even more ridiculous to support then in jsonpath assuming JSON doesn't support these values as well. This commit forbids returning NaN from .double(), which was previously allowed. NaN can't be resu

pgsql: Improve error reporting for jsonpath .double() method

2020-07-10 Thread Alexander Korotkov
Improve error reporting for jsonpath .double() method When jsonpath .double() method detects that numeric or string can't be converted to double precision, it throws an error. This commit makes these errors explicitly express the reason of failure. Discussion: https://postgr.es/m/CAPpHfdtqJtiSX

pgsql: Improve error reporting for jsonpath .double() method

2020-07-10 Thread Alexander Korotkov
Improve error reporting for jsonpath .double() method When jsonpath .double() method detects that numeric or string can't be converted to double precision, it throws an error. This commit makes these errors explicitly express the reason of failure. Discussion: https://postgr.es/m/CAPpHfdtqJtiSX

pgsql: Improve error reporting for jsonpath .double() method

2020-07-10 Thread Alexander Korotkov
Improve error reporting for jsonpath .double() method When jsonpath .double() method detects that numeric or string can't be converted to double precision, it throws an error. This commit makes these errors explicitly express the reason of failure. Discussion: https://postgr.es/m/CAPpHfdtqJtiSX

pgsql: Rename field "relkind" to "objtype" for CTAS and ALTER TABLE nod

2020-07-10 Thread Michael Paquier
Rename field "relkind" to "objtype" for CTAS and ALTER TABLE nodes "relkind" normally refers to the char field from pg_class. However, in the parse nodes AlterTableStmt and CreateTableAsStmt, "relkind" was used for a field of type enum ObjectType, that could refer to other object types than those