Postgres Pro
Downloads
Home   >   mailing lists

Re: Can PostgreSQL notify a client that a trigger has fired? - Mailing list pgsql-general

From Jorge Godoy
Subject Re: Can PostgreSQL notify a client that a trigger has fired?
Date
Msg-id 87psbx78e7.fsf@gmail.com
Whole thread Raw
In response to Can PostgreSQL notify a client that a trigger has fired?  ("Bill" <postgresql@dbginc.com>)
List pgsql-general
Tree view 
"Bill" <postgresql@dbginc.com> writes:

> Does PostgreSQL have built in mechanism I can use to conditionally
> notify a client application that a trigger has fired? What I want is
> something along the line of the following pseudo code in a trigger.
>
> if <condition> then
>   raise client event

I have the impression that you're missing a lot of sections in the manual...
How about some time to re-read it?

http://www.postgresql.org/docs/8.1/interactive/sql-notify.html


--
Jorge Godoy      <jgodoy@gmail.com>

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Can PostgreSQL notify a client that a trigger has
Next
From: Matthew Peter
Date:
Subject: dblink / plpgsql - definition list cheats for record returning functions?