pgsql: Tighten enforcement of variable CONSTANT markings in plpgsql.

2022-04-30 Thread Tom Lane
Tighten enforcement of variable CONSTANT markings in plpgsql. I noticed that plpgsql would allow assignment of a new value to a variable even when that variable is marked CONSTANT, if the variable is used as an output parameter in CALL or is a refcursor variable that OPEN assigns a new value to.

pgsql: pg_walinspect: fix case where flush LSN is in the middle of a re

2022-04-30 Thread Jeff Davis
pg_walinspect: fix case where flush LSN is in the middle of a record. Instability in the test for pg_walinspect revealed that pg_get_wal_records_info_till_end_of_wal(x) would try to decode all the records with a start LSN earlier than the flush LSN, even though that might include a partial record

Re: pgsql: Remove command checks in tests of pg_basebackup and pg_receivewa

2022-04-30 Thread Andrew Dunstan
On 2022-02-14 Mo 23:41, Michael Paquier wrote: > Remove command checks in tests of pg_basebackup and pg_receivewal > > The TAP tests of those commands have been checking if commands of "gzip" > and "lz4" existed by launching them with an extra --version. Based on > the buildfarm, this is not req