Postgres Pro
Downloads
Home   >   mailing lists

Re: COMMIT notification - Mailing list pgsql-general

From Tom Lane
Subject Re: COMMIT notification
Date
Msg-id 4555.1045064180@sss.pgh.pa.us
Whole thread Raw
In response to Re: COMMIT notification  (Viacheslav N Tararin <taras@dekasoft.com.ua>)
List pgsql-general
Tree view 
Viacheslav N Tararin <taras@dekasoft.com.ua> writes:
> NOTIFY work, message will send on statement execution, but transaction
> may be rolledback later.

No, the message is sent at commit.  See the man page for NOTIFY.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: how do I get a log of SQL executed by server?
Next
From: "Andy Kriger"
Date:
Subject: when was a table created?