pgsql: Fix typos and bump catversion.

2022-11-18 Thread Robert Haas
Fix typos and bump catversion. Typos reported by Álvaro Herrera and Erik Rijkers. Catversion bump for 3d14e171e9e2236139e8976f3309a588bcc8683b was inadvertently omitted. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/2fb6154fcd769b2d4ea1226788e0ec2fc3522cb8 Modif

pgsql: Add a SET option to the GRANT command.

2022-11-18 Thread Robert Haas
Add a SET option to the GRANT command. Similar to how the INHERIT option controls whether or not the permissions of the granted role are automatically available to the grantee, the new SET permission controls whether or not the grantee may use the SET ROLE command to assume the privileges of the g

pgsql: Don't read MCV stats needlessly in eqjoinsel().

2022-11-18 Thread Tom Lane
Don't read MCV stats needlessly in eqjoinsel(). eqjoinsel() currently makes use of MCV stats only when we have such stats for both sides of the clause. As coded, though, it would fetch those stats even when they're present for just one side. This can be a bit expensive with high statistics target

pgsql: Make object_address test output easier to update

2022-11-18 Thread Peter Eisentraut
Make object_address test output easier to update The object_address test file turns to psql unaligned output for some tests to avoid huge diffs for changes. But this is useful also to the other large test in that file, so apply it there as well. This also makes verifying the null and whitespace

pgsql: Clean up SQL code indentation in test file

2022-11-18 Thread Peter Eisentraut
Clean up SQL code indentation in test file This makes the code layout more consistent inside the same file. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/d0ca708540064aa4a18b226f75ad44dcdd64b383 Modified Files -- src/test/regress/expected/object_addre

pgsql: Fix version comparison in Version.pm

2022-11-18 Thread Andrew Dunstan
Fix version comparison in Version.pm Version strings with unequal numbers of parts were being compared incorrectly. We cure this by treating a missing part in the shorter version as 0. per complaint from Jehan-Guillaume de Rorthais, but the fix is mine, not his. Discussion: https://postgr.es/m/2

pgsql: Fix version comparison in Version.pm

2022-11-18 Thread Andrew Dunstan
Fix version comparison in Version.pm Version strings with unequal numbers of parts were being compared incorrectly. We cure this by treating a missing part in the shorter version as 0. per complaint from Jehan-Guillaume de Rorthais, but the fix is mine, not his. Discussion: https://postgr.es/m/2

pgsql: Fix version comparison in Version.pm

2022-11-18 Thread Andrew Dunstan
Fix version comparison in Version.pm Version strings with unequal numbers of parts were being compared incorrectly. We cure this by treating a missing part in the shorter version as 0. per complaint from Jehan-Guillaume de Rorthais, but the fix is mine, not his. Discussion: https://postgr.es/m/2

pgsql: Fix typo

2022-11-18 Thread Alvaro Herrera
Fix typo Erik Rijkers Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/83eccb85625fce8f63ee2cd4fc60d72de4008d90 Modified Files -- doc/src/sgml/ref/initdb.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: doc: Small wording improvement

2022-11-18 Thread Peter Eisentraut
doc: Small wording improvement Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/28d233c8e6e599dc4377dda75d97fce55a26fbc3 Modified Files -- doc/src/sgml/libpq.sgml | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)

Re: pgsql: Add glossary entries related to superusers

2022-11-18 Thread Erik Rijkers
Op 18-11-2022 om 12:01 schreef Alvaro Herrera: Add glossary entries related to superusers Extracted from a more ambitious patch. Author: David G. Johnston Discussion: https://postgr.es/m/cakfquwzc4k0xybm0bwbmdozysbqhosekdhluaw4vpi+ozi8...@mail.gmail.com In initdb.sgml, 'boostrap' shou

pgsql: Add glossary entries related to superusers

2022-11-18 Thread Alvaro Herrera
Add glossary entries related to superusers Extracted from a more ambitious patch. Author: David G. Johnston Discussion: https://postgr.es/m/cakfquwzc4k0xybm0bwbmdozysbqhosekdhluaw4vpi+ozi8...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/910cab82