NOTIFY in Background Worker - Mailing list pgsql-hackers

From jacques klein
Subject NOTIFY in Background Worker
Date
Msg-id 1440757854.22331.37.camel@jkn0.kehl.dalim.com
Whole thread Raw
Responses Re: NOTIFY in Background Worker
List pgsql-hackers
Hello,<br /><br /> I added a "NOFITY chan" to the SQL arg of an SPI_execute(), (I did it also with just the NOTIFY
statement),<br/> but the listeners (other workers) don't get the notification until a "NOTIFY chan" is done for example
withpgadmin,<br /><br /> They don't get lost, just not emited after the "not forgotten" call of
CommitTransactionCommand().<br/><br /> Is this normal ( i.e. not supported (yet) ), a bug, or did I overlook some doc.
(orsource code) ?.<br /><br /> For now, I will try to "emit" the NOTIFY via libpq.<br /><br /> Jacques K.<br /><br /> 

pgsql-hackers by date:

Previous
From: Etsuro Fujita
Date:
Subject: Re: Minor code improvements to create_foreignscan_plan/ExecInitForeignScan
Next
From: Stephen Frost
Date:
Subject: Re: AcquireRewriteLocks/acquireLocksOnSubLinks vs. rowsecurity