Re: Again, sorry, caching. - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Again, sorry, caching.
Date
Msg-id 22202.1018804097@sss.pgh.pa.us
Whole thread Raw
In response to Re: Again, sorry, caching.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Again, sorry, caching.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Also, on the NOTIFY/trigger idea, triggers are called on statement end,
> not transaction end, so if an UPDATE query is in a multi-statement
> transaction, another backend looking for the NOTIFY will receive it
> before the transaction commits, meaning it will not see the update. 

No it won't.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: regexp character class locale awareness patch
Next
From: Tom Lane
Date:
Subject: Re: bug with current sources? Re: cost of parse/plan/execute for one sample query