Tom Lane wrote:
> "Tyler, Mark" <Mark.Tyler@dsto.defence.gov.au> writes:
>
>> What I want to do is to guarantee that the row is available for
>> selection prior to sending the message.
>>
>
> You cannot do that with an AFTER trigger, because whatever it does
> necessarily happens before your transaction commits. I suggest
> rethinking your dislike of NOTIFY.
>
What if the trigger is a constraint trigger that is deferred?
http://www.postgresql.org/docs/8.3/interactive/sql-createconstraint.html
klint.
--
Klint Gore
Database Manager
Sheep CRC
A.G.B.U.
University of New England
Armidale NSW 2350
Ph: 02 6773 3789
Fax: 02 6773 3266
EMail: kgore4@une.edu.au