pgsql: Improve stability of identity.sql regression test.

2020-10-04 Thread Tom Lane
Improve stability of identity.sql regression test. I noticed while trying to run the regression tests under a low geqo_threshold that one query on information_schema.columns had unstable (as in, variable from one run to the next) output order. This is pretty unsurprising given the complexity of th

pgsql: Improve stability of identity.sql regression test.

2020-10-04 Thread Tom Lane
Improve stability of identity.sql regression test. I noticed while trying to run the regression tests under a low geqo_threshold that one query on information_schema.columns had unstable (as in, variable from one run to the next) output order. This is pretty unsurprising given the complexity of th

pgsql: Improve stability of identity.sql regression test.

2020-10-04 Thread Tom Lane
Improve stability of identity.sql regression test. I noticed while trying to run the regression tests under a low geqo_threshold that one query on information_schema.columns had unstable (as in, variable from one run to the next) output order. This is pretty unsurprising given the complexity of th

pgsql: Improve stability of identity.sql regression test.

2020-10-04 Thread Tom Lane
Improve stability of identity.sql regression test. I noticed while trying to run the regression tests under a low geqo_threshold that one query on information_schema.columns had unstable (as in, variable from one run to the next) output order. This is pretty unsurprising given the complexity of th

pgsql: Fix handling of redundant options with COPY for "freeze" and "he

2020-10-04 Thread Michael Paquier
Fix handling of redundant options with COPY for "freeze" and "header" The handling of those options was inconsistent, as the processing used directly the value assigned to the option to check if it was redundant, leading to patterns like this one to succeed (note that false is specified first): CO

pgsql: Improve stability of identity.sql regression test.

2020-10-04 Thread Tom Lane
Improve stability of identity.sql regression test. I noticed while trying to run the regression tests under a low geqo_threshold that one query on information_schema.columns had unstable (as in, variable from one run to the next) output order. This is pretty unsurprising given the complexity of th

pgsql: Make postgres.bki use the same literal-string syntax as postgres

2020-10-04 Thread Tom Lane
Make postgres.bki use the same literal-string syntax as postgresql.conf. The BKI file's string quoting conventions were previously quite weird, perhaps as a result of repurposing a function built to scan single-quoted strings to scan double-quoted ones. Change to use the same rules as we use in G