Re: Native Logical Replication Initial Import Qs

2023-06-07 Thread Jeremy Schneider
On 6/7/23 2:12 PM, Don Seiler wrote: > On the logical replication front, the concern is with the initial data > import that happens when the subscription is created (by default). I > know that you can tell the subscription to not copy data and instead use > pg_dump and a replication slot snapshot t

Native Logical Replication Initial Import Qs

2023-06-07 Thread Don Seiler
Good afternoon. I'm looking at having to move a fleet of PG 12 databases from Ubuntu 18.04 to Ubuntu 22.04. This means crossing the dreaded libc collation change, so we're looking to have to migrate via pg_dump/restore or logical replication for the bigger/busier ones. We're also planning to use P

Re: How to manipulate field in New record

2023-06-07 Thread Lorusso Domenico
yes I know, the trigger should be before insert update and delete, and the function decide what manipulate basing on TG_OP Il giorno mer 7 giu 2023 alle ore 15:57 Adrian Klaver < adrian.kla...@aklaver.com> ha scritto: > On 6/7/23 05:12, Lorusso Domenico wrote: > > Hello, > > Looking for a global

Re: How to manipulate field in New record

2023-06-07 Thread Adrian Klaver
On 6/7/23 05:12, Lorusso Domenico wrote: Hello, Looking for a global solution I've write e trigger function that as optional parameter (argv[0]) receive the name of a specific parameter. My need is to get the filed from NEW and OLD record manipulate and set back the field with new value. A

Re: How to manipulate field in New record

2023-06-07 Thread hubert depesz lubaczewski
On Wed, Jun 07, 2023 at 02:12:58PM +0200, Lorusso Domenico wrote: > Hello, > Looking for a global solution I've write e trigger function that as > optional parameter (argv[0]) receive the name of a specific parameter. > > My need is to get the filed from NEW and OLD record manipulate and set back

How to manipulate field in New record

2023-06-07 Thread Lorusso Domenico
Hello, Looking for a global solution I've write e trigger function that as optional parameter (argv[0]) receive the name of a specific parameter. My need is to get the filed from NEW and OLD record manipulate and set back the field with new value. Problem 1: how to get and set this field Problem