Re: pgsql: Update time zone data files to tzdata release 2024b.

2024-10-29 Thread Andrew Dunstan
> On Oct 29, 2024, at 5:41 PM, Tom Lane wrote: > > Andrew Dunstan writes: >> Crake doesn't seem to like this for cross version upgrade, and the diff >> looks rather odd: > > Oh, that's annoying. I forgot to mention the side-effects that 2024b > had on PST8PDT and other SysV-derived timezo

Re: pgsql: Update time zone data files to tzdata release 2024b.

2024-10-29 Thread Tom Lane
Andrew Dunstan writes: > Crake doesn't seem to like this for cross version upgrade, and the diff > looks rather odd: Oh, that's annoying. I forgot to mention the side-effects that 2024b had on PST8PDT and other SysV-derived timezones (probably because Paul Eggert avoided mentioning that in his r

Re: pgsql: Update time zone data files to tzdata release 2024b.

2024-10-29 Thread Andrew Dunstan
On Tue, Oct 29, 2024 at 11:50 AM Tom Lane wrote: > Update time zone data files to tzdata release 2024b. > > Historical corrections for Mexico, Mongolia, and Portugal. > Notably, Asia/Choibalsan is now an alias for Asia/Ulaanbaatar > rather than being a separate zone, mainly because the difference

pgsql: Add missing CommandCounterIncrement() in stats import functions.

2024-10-29 Thread Jeff Davis
Add missing CommandCounterIncrement() in stats import functions. Reported-by: Alexander Lakhin Discussion: https://postgr.es/m/98b2fcf0-f701-369e-d63d-6be9739ce...@gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/f22e436bff779fee4e1ce49733ba5791d4634fb1 Mo

pgsql: Unpin buffer before inplace update waits for an XID to end.

2024-10-29 Thread Noah Misch
Unpin buffer before inplace update waits for an XID to end. Commit a07e03fd8fa7daf4d1356f7cb501ffe784ea6257 changed inplace updates to wait for heap_update() commands like GRANT TABLE and GRANT DATABASE. By keeping the pin during that wait, a sequence of autovacuum workers and an uncommitted GRANT

pgsql: Unpin buffer before inplace update waits for an XID to end.

2024-10-29 Thread Noah Misch
Unpin buffer before inplace update waits for an XID to end. Commit a07e03fd8fa7daf4d1356f7cb501ffe784ea6257 changed inplace updates to wait for heap_update() commands like GRANT TABLE and GRANT DATABASE. By keeping the pin during that wait, a sequence of autovacuum workers and an uncommitted GRANT

pgsql: Unpin buffer before inplace update waits for an XID to end.

2024-10-29 Thread Noah Misch
Unpin buffer before inplace update waits for an XID to end. Commit a07e03fd8fa7daf4d1356f7cb501ffe784ea6257 changed inplace updates to wait for heap_update() commands like GRANT TABLE and GRANT DATABASE. By keeping the pin during that wait, a sequence of autovacuum workers and an uncommitted GRANT

pgsql: Unpin buffer before inplace update waits for an XID to end.

2024-10-29 Thread Noah Misch
Unpin buffer before inplace update waits for an XID to end. Commit a07e03fd8fa7daf4d1356f7cb501ffe784ea6257 changed inplace updates to wait for heap_update() commands like GRANT TABLE and GRANT DATABASE. By keeping the pin during that wait, a sequence of autovacuum workers and an uncommitted GRANT

pgsql: Unpin buffer before inplace update waits for an XID to end.

2024-10-29 Thread Noah Misch
Unpin buffer before inplace update waits for an XID to end. Commit a07e03fd8fa7daf4d1356f7cb501ffe784ea6257 changed inplace updates to wait for heap_update() commands like GRANT TABLE and GRANT DATABASE. By keeping the pin during that wait, a sequence of autovacuum workers and an uncommitted GRANT

pgsql: Unpin buffer before inplace update waits for an XID to end.

2024-10-29 Thread Noah Misch
Unpin buffer before inplace update waits for an XID to end. Commit a07e03fd8fa7daf4d1356f7cb501ffe784ea6257 changed inplace updates to wait for heap_update() commands like GRANT TABLE and GRANT DATABASE. By keeping the pin during that wait, a sequence of autovacuum workers and an uncommitted GRANT

pgsql: Unpin buffer before inplace update waits for an XID to end.

2024-10-29 Thread Noah Misch
Unpin buffer before inplace update waits for an XID to end. Commit a07e03fd8fa7daf4d1356f7cb501ffe784ea6257 changed inplace updates to wait for heap_update() commands like GRANT TABLE and GRANT DATABASE. By keeping the pin during that wait, a sequence of autovacuum workers and an uncommitted GRANT

pgsql: Update time zone data files to tzdata release 2024b.

2024-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2024b. Historical corrections for Mexico, Mongolia, and Portugal. Notably, Asia/Choibalsan is now an alias for Asia/Ulaanbaatar rather than being a separate zone, mainly because the differences between those zones were found to be based on untrustworth

pgsql: Update time zone data files to tzdata release 2024b.

2024-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2024b. Historical corrections for Mexico, Mongolia, and Portugal. Notably, Asia/Choibalsan is now an alias for Asia/Ulaanbaatar rather than being a separate zone, mainly because the differences between those zones were found to be based on untrustworth

pgsql: Update time zone data files to tzdata release 2024b.

2024-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2024b. Historical corrections for Mexico, Mongolia, and Portugal. Notably, Asia/Choibalsan is now an alias for Asia/Ulaanbaatar rather than being a separate zone, mainly because the differences between those zones were found to be based on untrustworth

pgsql: Update time zone data files to tzdata release 2024b.

2024-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2024b. Historical corrections for Mexico, Mongolia, and Portugal. Notably, Asia/Choibalsan is now an alias for Asia/Ulaanbaatar rather than being a separate zone, mainly because the differences between those zones were found to be based on untrustworth

pgsql: Update time zone data files to tzdata release 2024b.

2024-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2024b. Historical corrections for Mexico, Mongolia, and Portugal. Notably, Asia/Choibalsan is now an alias for Asia/Ulaanbaatar rather than being a separate zone, mainly because the differences between those zones were found to be based on untrustworth

pgsql: Update time zone data files to tzdata release 2024b.

2024-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2024b. Historical corrections for Mexico, Mongolia, and Portugal. Notably, Asia/Choibalsan is now an alias for Asia/Ulaanbaatar rather than being a separate zone, mainly because the differences between those zones were found to be based on untrustworth

pgsql: Update time zone data files to tzdata release 2024b.

2024-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2024b. Historical corrections for Mexico, Mongolia, and Portugal. Notably, Asia/Choibalsan is now an alias for Asia/Ulaanbaatar rather than being a separate zone, mainly because the differences between those zones were found to be based on untrustworth

pgsql: Reduce variable scope and possibly useless palloc

2024-10-29 Thread David Rowley
Reduce variable scope and possibly useless palloc Move the CreateStmt down to the branch that it's used in, thus preventing the makeNode() call in cases where the CreateStmt isn't used. Author: Ranier Vilela Discussion: https://postgr.es/m/CAEudQAq=06ypwphs+yytbcwv5jlkrz8rm3dwx6jr5uj_d_f...@mai

pgsql: Doc: add detail about EXPLAIN's "Disabled" property

2024-10-29 Thread David Rowley
Doc: add detail about EXPLAIN's "Disabled" property c01743aa4 and later 161320b4b adjusted the EXPLAIN output to show which plan nodes were chosen despite being disabled by the various enable* GUCs. Prior to e22253467, the disabledness of a node was only evident by a large startup cost penalty.

pgsql: Add missing FATAL => 'all' to a use warnings in Perl

2024-10-29 Thread Peter Eisentraut
Add missing FATAL => 'all' to a use warnings in Perl Author: Anton Voloshin Discussion: https://www.postgresql.org/message-id/aa8a55d5-554a-4027-a491-1b0ca7c85...@postgrespro.ru Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/014720c6d9fb1285846f0b7cc1c80bdbe887a7

pgsql: doc: Add better description for rewrite functions in event trigg

2024-10-29 Thread Michael Paquier
doc: Add better description for rewrite functions in event triggers There are two functions that can be used in event triggers to get more details about a rewrite happening on a relation. Both had a limited documentation: - pg_event_trigger_table_rewrite_reason() and pg_event_trigger_table_rewrit