"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.