Re: Can two-phase commit support LISTEN, UNLISTEN, and NOTIFY?

2023-09-16 Thread Tom Lane
James Stuart writes: > Can you please clarify, is lack of support for "LISTEN, UNLISTEN, and > NOTIFY" with two-phase commits an architecture limitation or is this > lacking implementation? The point of LISTEN and UNLISTEN is to change the listening state of the current session, so it's hard to

Can two-phase commit support LISTEN, UNLISTEN, and NOTIFY?

2023-09-16 Thread James Stuart
Can you please clarify, is lack of support for "LISTEN, UNLISTEN, and NOTIFY" with two-phase commits an architecture limitation or is this lacking implementation?  The NOTIFY happens after the transaction commits and can't undo the transaction, so I can't think of any reason why this could inte

Re: update from 13 to16

2023-09-16 Thread Maciek Sakrejda
On Fri, Sep 15, 2023, 15:02 Adrian Klaver wrote: > On 9/15/23 9:55 AM, Martin Mueller wrote: > > I am thinking of upgrading from version 13 to version 16. > > > > I think I can do this by leaving the data alone and just replacing the > software. My data are extremely simple and consist of severa