Merlin Moncure <mmoncure@xxxxxxxxx> writes: > On Sat, Feb 20, 2010 at 9:38 PM, Petr Chmelar <chmelarp@xxxxxxxxxxxx> wrote: >> Is there a way how to listen and trigger the notify messages in the >> database (+-)immediately and/or to execute additional (trigger) queries >> in other transactions? > The only way that I know of to send notify 'in-transaction' is via > dblink...you just send 'notify x' as the query which commits and fires > the action. It doesn't make sense to do this if your outer > transaction is very short in duration. It's not clear that it makes sense to do that in a long transaction, either. What are you notifying other sessions *about*? Not your own changes --- they won't be able to see those till you commit. There's a reason why NOTIFY is delayed till commit ... regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
