Re: How to send automatically a NOTIFY when a COMMIT is done ?

jboes(at)nexcerpt(dot)com (Jeff Boes) writes:
> "elisabeth maniez" <emaniez(at)caramail(dot)com> wrote in message news:<a1q39u$n8d$1(at)news(dot)tht(dot)net>...
>> When a transaction is commited, I would like to execute "automatically" a
>> "NOTIFY ..." call

> I'd asked about this sort of thing a few months ago (do a search on
> "NOTIFY" at groups.google.com). Your best bet is to write a trigger
> in PL/Pgsql that EXECUTEs the NOTIFY. Even there, you won't be able
> to do it at COMMIT time, but only at statement execution time. If you
> want to do it when you commit, you'll have to do it programmatically
> rather than through a trigger.

Since the NOTIFY won't actually be sent to the client until/unless the
transaction commits, I should think a NOTIFY would do fine.

regards, tom lane