On Sep 12, 2007, at 11:51 AM, Richard Broersma Jr wrote:
--- Jay Dickon Glanville <dickon.glanville@xxxxxxxxx> wrote:
Is it possible for PostgreSQL to notify me of a successful
transaction commit?
I've haven't used it yet, but will LISTEN and NOTIFY work for you?
http://www.postgresql.org/docs/8.2/static/sql-listen.html
http://www.postgresql.org/docs/8.2/static/sql-notify.html
I don't see how he could wire that up (or, anything) for per-
transaction notifications. I'll also point out that the solution for
his use-case, keeping an up-to-date application level cache of data,
is normally implemented at the application layer, often using
something like memcached. However, if he can narrow his "events"
down to specific tables, then he can use the LISTEN/NOTIFY mechanism
with triggers on those tables to good effect.
Erik Jones
Software Developer | Emma®
erik@xxxxxxxxxx
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
