Re: COMMIT notification

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Viacheslav N Tararin <taras(at)dekasoft(dot)com(dot)ua>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: COMMIT notification
Date: 2003-02-12 15:36:20
Message-ID: 4555.1045064180@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Viacheslav N Tararin <taras(at)dekasoft(dot)com(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andy Kriger 2003-02-12 15:38:44 when was a table created?
Previous Message Bruce Momjian 2003-02-12 14:50:27 Re: how do I get a log of SQL executed by server?