Re: LISTEN & transactions - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: LISTEN & transactions
Date
Msg-id 23007.1007310567@sss.pgh.pa.us
Whole thread Raw
In response to LISTEN & transactions  ("Jeroen T. Vermeulen" <jtv@xs4all.nl>)
List pgsql-interfaces
"Jeroen T. Vermeulen" <jtv@xs4all.nl> writes:
> I can use the existing behaviour in libpqxx[1] to guarantee that a
> trigger handler is always able to start a transaction on the connection
> the notification came in on.  But that probably wouldn't make much sense 
> (though it would still be possible) unless the current way of doing
> things is here to stay.

Should be okay to depend on the fact that notifies are only delivered
between transactions; see the NOTIFY reference page.
        regards, tom lane


pgsql-interfaces by date:

Previous
From: "Jeroen T. Vermeulen"
Date:
Subject: LISTEN & transactions
Next
From: Andreas Kretzer
Date:
Subject: TCL with large objects on Win