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
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
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
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
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
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