Re: Event-driven programming?

2007/9/12, Jay Dickon Glanville <dickon(dot)glanville(at)gmail(dot)com>:
> 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