Re: [GENERAL] Listen and Notify

2012-05-01 Thread Alexander Reichstadt
The framework I am using is PGSQLKit for Mac OS X for which the source was available and which I downloaded and altered since. Actually it gives you access down to the pqlib calls. The connection being closed was one of the issues. I had added convenience classes with class methods to the frame

Re: [GENERAL] Listen and Notify

2012-05-01 Thread Mark Morgan Lloyd
Merlin Moncure wrote: On Mon, Apr 30, 2012 at 1:47 AM, Alexander Reichstadt wrote: Hi, From the documentation I was able to build a trigger firing upon deletion of a record a function that delivers tablename_operation as a notification one needs to subscribe to. So in terminal I can say LIST

Re: [GENERAL] Listen and Notify

2012-04-30 Thread Merlin Moncure
On Mon, Apr 30, 2012 at 1:47 AM, Alexander Reichstadt wrote: > Hi, > > From the documentation I was able to build a trigger firing upon deletion of > a record a function that delivers tablename_operation as a notification one > needs to subscribe to. So in terminal I can say LISTEN persons_delet

Re: [GENERAL] Listen and Notify

2012-04-30 Thread Tom Lane
Alexander Reichstadt writes: > But what I don't fully understand is how to do this with PQnotifies. > Following the docu I get no notifications even though I subscribe to them > after successfully connecting to the server the same way I do using terminal. Maybe you forgot PQconsumeInput? There

[GENERAL] Listen and Notify

2012-04-30 Thread Alexander Reichstadt
Hi, >From the documentation I was able to build a trigger firing upon deletion of a >record a function that delivers tablename_operation as a notification one >needs to subscribe to. So in terminal I can say LISTEN persons_delete and >instantly will receive Asynchronous notification "p