Postgres Pro
Downloads
Home   >   mailing lists

Re: Problem with async notifications of table updates - Mailing list pgsql-general

From Tom Lane
Subject Re: Problem with async notifications of table updates
Date
Msg-id 7251.1205807724@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with async notifications of table updates  ("Tyler, Mark" <Mark.Tyler@dsto.defence.gov.au>)
Responses Re: Problem with async notifications of table updates  ("Tyler, Mark" <Mark.Tyler@dsto.defence.gov.au>)
Re: Problem with async notifications of table updates  (Klint Gore <kgore4@une.edu.au>)
List pgsql-general
Tree view 
"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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Adam Rich"
Date:
Subject: Re: 8.3.0 upgrade
Next
From: "Tyler, Mark"
Date:
Subject: Re: Problem with async notifications of table updates