LISTEN & transactions
| От | Jeroen T. Vermeulen |
|---|---|
| Тема | LISTEN & transactions |
| Дата | |
| Msg-id | 20011202164914.A12152@bulletproof обсуждение исходный текст |
| Ответы |
Re: LISTEN & transactions
|
| Список | pgsql-interfaces |
Hi all, I noticed that using libpq, trigger notifications don't arrive inside transactions. Instead their delivery appears to be deferred until after the transaction ends. I haven't found any mention of this in the manual. Is this a design choice, or a "coincidence" resulting from practical implementation considerations, or a mistake on my part, or something else entirely? 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. Jeroen [1] http://members.ams.chello.nl/j.vermeulen31/
В списке pgsql-interfaces по дате отправления: