2007/9/12, Jay Dickon Glanville <dickon.glanville@xxxxxxxxx>: > Hello all. > > Is it possible for PostgreSQL to notify me of a successful transaction commit? > > Here's an example of what I'm thinking of: > - I write a function (it doesn't matter what language it's in: > PL/pgSQL, PL/Java, etc) > - I register that function as a "post-commit" callback function > - when a client commits a transaction, the function gets called, and > the database passes the function some general information as to the > content of the transaction > > Note how similar this process is to writing triggers. The only > problem I have with triggers is that events get generated per-table. > I'd like to get notifications based on transactions, not table > changes. > > What I'd like to be able to do with this event is to notify any > applications of this change, so they can update their cached view of > the database. > > So, is this possible? Or am I wishing for the sky? ;-) > > Thanks for any help you can provide. > > JDG > > On stored procedure level you can use dbms_alert functionality from orafce library. http://www.pgsql.cz/index.php/Oracle_functionality_%28en%29#DBMS_ALERT Pavel Stehule ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
