Re: pgsql: Allow NOT VALID foreign key constraints on partitioned tables

2025-01-23 Thread Michael Paquier
Hi Alvaro. On Thu, Jan 23, 2025 at 02:59:38PM +, Alvaro Herrera wrote: > Allow NOT VALID foreign key constraints on partitioned tables > > This feature was intentionally omitted when FKs were first implemented > for partitioned tables, and had been requested a few times; the > usefulness is c

pgsql: Return yyparse() result not via global variable

2025-01-23 Thread Peter Eisentraut
Return yyparse() result not via global variable Instead of passing the parse result from yyparse() via a global variable, pass it via a function output argument. This complements earlier work to make the parsers reentrant. Discussion: Discussion: https://www.postgresql.org/message-id/flat/eb6fa

pgsql: initdb: Convert tests to use long options with fat comma style

2025-01-23 Thread Michael Paquier
initdb: Convert tests to use long options with fat comma style This is similar to ce1b0f9da03e, but this time this rule is applied to some of the TAP tests of initdb. Author: Dagfinn Ilmari Mannsåker Discussion: https://postgr.es/m/878qr146ra@wibble.ilmari.org Branch -- master Details -

pgsql: Doc: Fix a typo introduced in 4a0e7314f1.

2025-01-23 Thread Amit Kapila
Doc: Fix a typo introduced in 4a0e7314f1. Author: Erik Rijkers Discussion: https://postgr.es/m/6e625c81-968e-42d0-802d-edfaf9cfa...@xs4all.nl Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/6fc4fc42da07c47a9b8d014ab18d005cf8b3e176 Modified Files -- doc

pgsql: Doc: Fix column name in pg_publication catalog.

2025-01-23 Thread Amit Kapila
Doc: Fix column name in pg_publication catalog. Commit e65dbc9927 incorrectly spelled the column name in the pg_publication catalog. In passing make the order of columns in the doc match the actual catalog. Author: Shinoda, Noriyoshi Reviewed-by: Peter Smith Discussion: https://postgr.es/m/dm4

pgsql: Don't ask for bug reports about pthread_is_threaded_np() != 0.

2025-01-23 Thread Tom Lane
Don't ask for bug reports about pthread_is_threaded_np() != 0. We thought that this condition was unreachable in ExitPostmaster, but actually it's possible if you have both a misconfigured locale setting and some other mistake that causes PostmasterMain to bail out before reaching its own check of

pgsql: Don't ask for bug reports about pthread_is_threaded_np() != 0.

2025-01-23 Thread Tom Lane
Don't ask for bug reports about pthread_is_threaded_np() != 0. We thought that this condition was unreachable in ExitPostmaster, but actually it's possible if you have both a misconfigured locale setting and some other mistake that causes PostmasterMain to bail out before reaching its own check of

pgsql: Don't ask for bug reports about pthread_is_threaded_np() != 0.

2025-01-23 Thread Tom Lane
Don't ask for bug reports about pthread_is_threaded_np() != 0. We thought that this condition was unreachable in ExitPostmaster, but actually it's possible if you have both a misconfigured locale setting and some other mistake that causes PostmasterMain to bail out before reaching its own check of

pgsql: Don't ask for bug reports about pthread_is_threaded_np() != 0.

2025-01-23 Thread Tom Lane
Don't ask for bug reports about pthread_is_threaded_np() != 0. We thought that this condition was unreachable in ExitPostmaster, but actually it's possible if you have both a misconfigured locale setting and some other mistake that causes PostmasterMain to bail out before reaching its own check of

pgsql: Don't ask for bug reports about pthread_is_threaded_np() != 0.

2025-01-23 Thread Tom Lane
Don't ask for bug reports about pthread_is_threaded_np() != 0. We thought that this condition was unreachable in ExitPostmaster, but actually it's possible if you have both a misconfigured locale setting and some other mistake that causes PostmasterMain to bail out before reaching its own check of

pgsql: Don't ask for bug reports about pthread_is_threaded_np() != 0.

2025-01-23 Thread Tom Lane
Don't ask for bug reports about pthread_is_threaded_np() != 0. We thought that this condition was unreachable in ExitPostmaster, but actually it's possible if you have both a misconfigured locale setting and some other mistake that causes PostmasterMain to bail out before reaching its own check of

pgsql: Add support for Unicode case folding.

2025-01-23 Thread Jeff Davis
Add support for Unicode case folding. Expand case mapping tables to include entries for case folding, which are parsed from CaseFolding.txt. Discussion: https://postgr.es/m/a1886ddfcd8f60cb3e905c93009b646b4cfb74c5.camel%40j-davis.com Branch -- master Details --- https://git.postgresql.

pgsql: Ensure that AFTER triggers run as the instigating user.

2025-01-23 Thread Tom Lane
Ensure that AFTER triggers run as the instigating user. With deferred triggers, it is possible that the current role changes between the time when the trigger is queued and the time it is executed (for example, the triggering data modification could have been executed in a SECURITY DEFINER functio

pgsql: Reverse the search order in afterTriggerAddEvent().

2025-01-23 Thread Tom Lane
Reverse the search order in afterTriggerAddEvent(). When scanning existing AfterTriggerSharedData records in search of a match to the event being queued, we were examining the records from oldest to newest. But it makes more sense to do the opposite. The newest record is likely to be from the cu

pgsql: Allow NOT VALID foreign key constraints on partitioned tables

2025-01-23 Thread Álvaro Herrera
Allow NOT VALID foreign key constraints on partitioned tables This feature was intentionally omitted when FKs were first implemented for partitioned tables, and had been requested a few times; the usefulness is clear. Validation can happen for each partition individually, which is useful to conta

pgsql: Fix buildfarm failure introduced by commit e65dbc9927.

2025-01-23 Thread Amit Kapila
Fix buildfarm failure introduced by commit e65dbc9927. The patch had incorrectly specified the default value for publish_generated_columns during the query formation in pg_dump. Author: Vignesh C Discussion: https://postgr.es/m/caa4ek1kfzytd8hpi9td1kab8rnubr9bauvtxa5wyyzdgbea...@mail.gmail.com

pgsql: Add some const decorations (htup.h)

2025-01-23 Thread Peter Eisentraut
Add some const decorations (htup.h) Discussion: https://www.postgresql.org/message-id/flat/5b558da8-99fb-0a99-83dd-f72f05388...@enterprisedb.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b15b8c5cf882e725c4f4f4628ac6f4d054065b4c Modified Files --

pgsql: Convert macros to static inline functions (htup_details.h, itup.

2025-01-23 Thread Peter Eisentraut
Convert macros to static inline functions (htup_details.h, itup.h) Discussion: https://www.postgresql.org/message-id/flat/5b558da8-99fb-0a99-83dd-f72f05388...@enterprisedb.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/34694ec888d6783c3222134305a86e533b43071d

pgsql: Change publication's publish_generated_columns option type to en

2025-01-23 Thread Amit Kapila
Change publication's publish_generated_columns option type to enum. The current boolean publish_generated_columns option only supports a binary choice, which is insufficient for future enhancements where generated columns can be of different types (e.g., stored or virtual). The supported values fo