Laurent Birtz <[EMAIL PROTECTED]> writes: > From the observed sequence of events, it would appear that the event > thread inserts a tuple in the pg_listener table BEFORE the command thread > actually commits the transaction. However, when this transaction commits, > Postgres does not actually find the event thread's tuple in this table.
I'm wondering exactly when you commit the LISTEN? The command thread can't see the pg_listener tuple until it's committed ... regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your Subscription: http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-bugs