On Thu, 2006-11-09 at 00:39 +0000, Bill wrote: > 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 > Yes, use LISTEN and NOTIFY. Probably it's easiest to write the trigger in PL/pgSQL. Regards, Jeff Davis