Re: Include sequence relation support in logical replication - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Include sequence relation support in logical replication
Date
Msg-id 20200509002649.rdrfaocsuyfw3dck@alap3.anarazel.de
Whole thread Raw
In response to Re: Include sequence relation support in logical replication  (Cary Huang <cary.huang@highgo.ca>)
List pgsql-hackers
Hi,

On 2020-05-08 16:32:38 -0700, Cary Huang wrote:
> I have added more regression test cases to the sequence replication
> patch with emphasis on transactions and rollback per your
> suggestions. I find that when a transaction is aborted with rollback,
> the decoder plugin will not receive the change but the sequence value
> will in fact advance if nextval() or setval() were called.

Right. The sequence advances shouldn't be treated
transactionally. That's already (optionally) done similarly for
messages, so you should be able to copy that code.

Greetings,

Andres Freund



pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: [PATCH] Fix division by zero (explain.c)
Next
From: Alvaro Herrera
Date:
Subject: Re: stat() on Windows might cause error if target file is largerthan 4GB