pgsql: Add 'logical_decoding_mode' GUC.

2022-12-25 Thread Amit Kapila
Add 'logical_decoding_mode' GUC. This enables streaming or serializing changes immediately in logical decoding. This parameter is intended to be used to test logical decoding and replication of large transactions for which otherwise we need to generate the changes till logical_decoding_work_mem

pgsql: Switch query fixing aclitems in ~15 from O(N^2) to O(N) in upgra

2022-12-25 Thread Michael Paquier
Switch query fixing aclitems in ~15 from O(N^2) to O(N) in upgrade_adapt.sql f4f2f2b was doing a sequential scan of pg_class before checking if a relation had attributes dependent on aclitem as data typewhen building the set of ALTER TABLE queries, but it would be costly on a regression database.

pgsql: Convert enum_in() to report errors softly.

2022-12-25 Thread Tom Lane
Convert enum_in() to report errors softly. I missed this in my initial survey, probably because I examined the contents of pg_type in the postgres database, which lacks any enumerated types. Discussion: https://postgr.es/m/caaj_b97kedwudptkgoafypv0oicjou6ew+qywj-ywrgj_ae...@mail.gmail.com

pgsql: Fix thinko in 720e0327bc

2022-12-25 Thread Andrew Dunstan
Fix thinko in 720e0327bc Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/361ec4368b1da252e031e2ee8bce366bce5f72b2 Modified Files -- contrib/isn/isn.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-)