Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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.
Is this because NOTIFY is held for transaction end or because the triggers are held until transaction commit? -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
