pgsql: Add UNIQUE null treatment option

2022-02-03 Thread Peter Eisentraut
Add UNIQUE null treatment option The SQL standard has been ambiguous about whether null values in unique constraints should be considered equal or not. Different implementations have different behaviors. In the SQL:202x draft, this has been formalized by making this implementation-defined and ad

pgsql: Authorize new user in pg_basebackup tests

2022-02-03 Thread Andrew Dunstan
Authorize new user in pg_basebackup tests Commit 8e2b6d45a0 added a new unprivileged user for testing pg_basebackup, but omitted to add them to the cluster's authorized logins, breaking Windows tests run without using Unix sockets. Branch -- master Details --- https://git.postgresql.org

Re: pgsql: Further fix for EvalPlanQual with mix of local and foreign parti

2022-02-03 Thread Andres Freund
Hi, On 2022-02-03 06:22:58 +, Etsuro Fujita wrote: > Further fix for EvalPlanQual with mix of local and foreign partitions. My compiler (as well as cfbot) now complains that there is an unused variable, when building without assertions: /home/andres/src/postgresql/src/backend/executor/nodeFo

pgsql: Fix compiler warning in non-assert builds, introduced in f862d57

2022-02-03 Thread Andres Freund
Fix compiler warning in non-assert builds, introduced in f862d57057f. Discussion: https://postgr.es/m/20220203183655.ralgkh54sdcgy...@alap3.anarazel.de Backpatch: 14-, like f862d57057f Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/7c1aead6cbe7dcc6c216715fed7a1fb6

pgsql: Fix compiler warning in non-assert builds, introduced in f862d57

2022-02-03 Thread Andres Freund
Fix compiler warning in non-assert builds, introduced in f862d57057f. Discussion: https://postgr.es/m/20220203183655.ralgkh54sdcgy...@alap3.anarazel.de Backpatch: 14-, like f862d57057f Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/2a3958e4d9b9b1e82adefa11f

Re: pgsql: Further fix for EvalPlanQual with mix of local and foreign parti

2022-02-03 Thread Andres Freund
On 2022-02-03 10:36:55 -0800, Andres Freund wrote: > I'll make it so, unless you want to? Did so now, cfbot being all red was a bit annoying. Wonder if we can failures due to compiler warnings a bit more distinguished from "harder" failures in the UI?

pgsql: Allow archiving via loadable modules.

2022-02-03 Thread Robert Haas
Allow archiving via loadable modules. Running a shell command for each file to be archived has a lot of overhead and may not offer as much error checking as you want, or the exact semantics that you want. So, offer the option to call a loadable module for each file to be archived, rather than runn

pgsql: In basic_archive tests, insist on wal_level='replica'.

2022-02-03 Thread Robert Haas
In basic_archive tests, insist on wal_level='replica'. That's normally the default, but buildfarm member thorntail has other ideas. Nathan Bossart Discussion: http://postgr.es/m/20220203212539.GA1082940@nathanxps13 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0

Re: pgsql: Further fix for EvalPlanQual with mix of local and foreign parti

2022-02-03 Thread Etsuro Fujita
On Fri, Feb 4, 2022 at 3:50 AM Andres Freund wrote: > On 2022-02-03 10:36:55 -0800, Andres Freund wrote: > > I'll make it so, unless you want to? > > Did so now, cfbot being all red was a bit annoying. Thanks for the fix! > Wonder if we can failures > due to compiler warnings a bit more distingu

pgsql: Improve invalidation handling in pgoutput.c.

2022-02-03 Thread Amit Kapila
Improve invalidation handling in pgoutput.c. Fix the following issues in pgoutput.c: * rel_sync_cache_relation_cb does the wrong thing when called for a cache flush (i.e., relid == 0). Instead of invalidating all RelationSyncCache entries as it should, it does nothing. * When rel_sync_cache_rela

pgsql: Track LLVM 14 API changes, up to 2022-01-30.

2022-02-03 Thread Thomas Munro
Track LLVM 14 API changes, up to 2022-01-30. Tested with LLVM 11, LLVM 13 and LLVM's main branch at commit 8d8fce87bbd5. There are still some deprecation warnings that will need to be sorted out, but this may be enough to turn "seawasp" green again. Like commit e6a76002, done on master only for