"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