Re: Transactional behavior of pg_create_logical_replication_slot

2025-06-17 Thread Mats Kindahl
On Tue, Jun 17, 2025 at 1:22 PM Andres Freund wrote: > Hi, > > On 2025-06-17 10:30:34 +0200, Mats Kindahl wrote: > > Hi PostgreSQL Hackers, > > > > If you try to create a logical replication slot inside a transaction > where > > you have issued writes, it will abort with an error message: > > > >

Re: Transactional behavior of pg_create_logical_replication_slot

2025-06-17 Thread Andres Freund
Hi, On 2025-06-17 10:30:34 +0200, Mats Kindahl wrote: > Hi PostgreSQL Hackers, > > If you try to create a logical replication slot inside a transaction where > you have issued writes, it will abort with an error message: > > mats=# start transaction; > START TRANSACTION > mats=*# select txid_cur

Transactional behavior of pg_create_logical_replication_slot

2025-06-17 Thread Mats Kindahl
Hi PostgreSQL Hackers, If you try to create a logical replication slot inside a transaction where you have issued writes, it will abort with an error message: mats=# start transaction; START TRANSACTION mats=*# select txid_current(); txid_current -- 406252 (1 row) mats=*# inser