Re: deferred primary key and logical replication

2020-11-23 Thread Amit Kapila
On Tue, Nov 24, 2020 at 3:04 AM Anastasia Lubennikova wrote: > > On 27.10.2020 13:46, Amit Kapila wrote: > > On Sun, Oct 25, 2020 at 9:39 PM Euler Taveira > > wrote: > >> On Mon, 5 Oct 2020 at 08:34, Amit Kapila wrote: > >>> On Mon, May 11, 2020 at 2:41 AM Euler Taveira > >>> wrote: > Hi,

Re: deferred primary key and logical replication

2020-11-23 Thread Anastasia Lubennikova
On 27.10.2020 13:46, Amit Kapila wrote: On Sun, Oct 25, 2020 at 9:39 PM Euler Taveira wrote: On Mon, 5 Oct 2020 at 08:34, Amit Kapila wrote: On Mon, May 11, 2020 at 2:41 AM Euler Taveira wrote: Hi, While looking at an old wal2json issue, I stumbled on a scenario that a table with a deferre

Re: deferred primary key and logical replication

2020-10-27 Thread Amit Kapila
On Sun, Oct 25, 2020 at 9:39 PM Euler Taveira wrote: > > On Mon, 5 Oct 2020 at 08:34, Amit Kapila wrote: >> >> On Mon, May 11, 2020 at 2:41 AM Euler Taveira >> wrote: >> > >> > Hi, >> > >> > While looking at an old wal2json issue, I stumbled on a scenario that a >> > table >> > with a deferred

Re: deferred primary key and logical replication

2020-10-25 Thread Euler Taveira
On Mon, 5 Oct 2020 at 08:34, Amit Kapila wrote: > On Mon, May 11, 2020 at 2:41 AM Euler Taveira > wrote: > > > > Hi, > > > > While looking at an old wal2json issue, I stumbled on a scenario that a > table > > with a deferred primary key is not updatable in logical replication. > AFAICS it > > ha

Re: deferred primary key and logical replication

2020-10-05 Thread Amit Kapila
On Mon, May 11, 2020 at 2:41 AM Euler Taveira wrote: > > Hi, > > While looking at an old wal2json issue, I stumbled on a scenario that a table > with a deferred primary key is not updatable in logical replication. AFAICS it > has been like that since the beginning of logical decoding and seems to

Re: deferred primary key and logical replication

2020-08-03 Thread Ajin Cherian
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation:not tested Patch applies cleanly. Tested that update/delete of tables with defer

Re: deferred primary key and logical replication

2020-07-27 Thread Euler Taveira
On Fri, 24 Jul 2020 at 05:16, Ajin Cherian wrote: > The patch no longer applies, because of additions in the test source. > Otherwise, I have tested the patch and confirmed that updates and deletes > on tables with deferred primary keys work with logical replication. > > The new status of this pa

Re: deferred primary key and logical replication

2020-07-24 Thread Ajin Cherian
The patch no longer applies, because of additions in the test source. Otherwise, I have tested the patch and confirmed that updates and deletes on tables with deferred primary keys work with logical replication. The new status of this patch is: Waiting on Author

deferred primary key and logical replication

2020-05-10 Thread Euler Taveira
Hi, While looking at an old wal2json issue, I stumbled on a scenario that a table with a deferred primary key is not updatable in logical replication. AFAICS it has been like that since the beginning of logical decoding and seems to be an oversight while designing logical decoding. I don't envisio