pgsql: Move SQL-callable code related to multixacts into its own file

2025-08-17 Thread Michael Paquier
Move SQL-callable code related to multixacts into its own file A patch is under discussion to add more SQL capabilities related to multixacts, and this move avoids bloating the file more than necessary. This affects pg_get_multixact_members(). A side effect of this move is the requirement to add

pgsql: meson: Move C99 test earlier

2025-08-17 Thread Peter Eisentraut
meson: Move C99 test earlier Move the test for compiler options for C99 earlier in meson.build, before we make use of the compiler for other tests. That way, if any command-line options are needed, subsequent tests will also use them. This is at the moment a theoretical problem, but it seems bett

pgsql: Refactor init_params() in sequence.c to not use FormData_pg_sequ

2025-08-17 Thread Michael Paquier
Refactor init_params() in sequence.c to not use FormData_pg_sequence_data init_params() sets up "last_value" and "is_called" for a sequence relation holdind its metadata, based on the sequence properties in pg_sequences. "log_cnt" is the third property that can be updated in this routine for Form

pgsql: Remove md5() call from isolation test for CLUSTER and TOAST

2025-08-17 Thread Michael Paquier
Remove md5() call from isolation test for CLUSTER and TOAST This test was failing because MD5 computations are not supported in these environments. This switches the test to rely on sha256() instead, providing the same coverage while avoiding the failure. Oversight in f57e214d1cbb. Per buildfar

Re: pgsql: Add isolation test for TOAST value reuse during CLUSTER

2025-08-17 Thread Michael Paquier
On Sun, Aug 17, 2025 at 06:27:57AM +, Michael Paquier wrote: > Add isolation test for TOAST value reuse during CLUSTER A couple of buildfarm members have been complaining about this test using md5(). Will fix in a bit. -- Michael signature.asc Description: PGP signature

pgsql: Update obsolete comments in ResultRelInfo struct.

2025-08-17 Thread Etsuro Fujita
Update obsolete comments in ResultRelInfo struct. Commit c5b7ba4e6 changed things so that the ri_RootResultRelInfo field of this struct is set for both partitions and inheritance children and used for tuple routing and transition capture (before that commit, it was only set for partitions to route

pgsql: Update obsolete comments in ResultRelInfo struct.

2025-08-17 Thread Etsuro Fujita
Update obsolete comments in ResultRelInfo struct. Commit c5b7ba4e6 changed things so that the ri_RootResultRelInfo field of this struct is set for both partitions and inheritance children and used for tuple routing and transition capture (before that commit, it was only set for partitions to route

pgsql: Update obsolete comments in ResultRelInfo struct.

2025-08-17 Thread Etsuro Fujita
Update obsolete comments in ResultRelInfo struct. Commit c5b7ba4e6 changed things so that the ri_RootResultRelInfo field of this struct is set for both partitions and inheritance children and used for tuple routing and transition capture (before that commit, it was only set for partitions to route

pgsql: Update obsolete comments in ResultRelInfo struct.

2025-08-17 Thread Etsuro Fujita
Update obsolete comments in ResultRelInfo struct. Commit c5b7ba4e6 changed things so that the ri_RootResultRelInfo field of this struct is set for both partitions and inheritance children and used for tuple routing and transition capture (before that commit, it was only set for partitions to route

pgsql: Update obsolete comments in ResultRelInfo struct.

2025-08-17 Thread Etsuro Fujita
Update obsolete comments in ResultRelInfo struct. Commit c5b7ba4e6 changed things so that the ri_RootResultRelInfo field of this struct is set for both partitions and inheritance children and used for tuple routing and transition capture (before that commit, it was only set for partitions to route

pgsql: Update obsolete comments in ResultRelInfo struct.

2025-08-17 Thread Etsuro Fujita
Update obsolete comments in ResultRelInfo struct. Commit c5b7ba4e6 changed things so that the ri_RootResultRelInfo field of this struct is set for both partitions and inheritance children and used for tuple routing and transition capture (before that commit, it was only set for partitions to route