Tom Lane wrote:
"Tyler, Mark" <Mark.Tyler@xxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
