RE: Logical Replication of sequences - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: Logical Replication of sequences
Date
Msg-id OS7PR01MB145592F3EF8554DD4786F2FD3F589A@OS7PR01MB14559.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Logical Replication of sequences  (vignesh C <vignesh21@gmail.com>)
List pgsql-hackers
Dear Vignesh,

> > That is not possible. Updated accordingly with slight change to
> > comment. The attached patch has the changes for the same.
> 
> During further testing, I identified an issue where the code could not
> reliably distinguish whether a sequence was dropped on the subscriber
> or on the publisher. A sequence dropped on the subscriber should be
> treated as a successful case, since the only viable action is to skip
> it, whereas a missing sequence on the publisher should be treated as
> an error. This distinction has now been handled correctly and fixed in
> the updated version.

Thanks for updating the patch. I verified the patch and LGTM.

Best regards,
Hayato Kuroda
FUJITSU LIMITED


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Change copyObject() to use typeof_unqual
Next
From: Tatsuro Yamada
Date:
Subject: Re: [PATCH] psql: add \dcs to list all constraints