From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | "Alexander Reichstadt *EXTERN*" <info(at)apfeltaste(dot)net>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Question on notifications |
Date: | 2012-04-30 07:53:10 |
Message-ID: | D960CB61B694CF459DCFB4B0128514C207CD330E@exadv11.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alexander Reichstadt wrote:
> 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 "persons_delete" received from server
process with PID 54790.
>
> if there was a delete. 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.
>
> Googling didn't give me examples I was able to use. Please, can
someone help?
Did you look at the example in the documentation?
http://www.postgresql.org/docs/current/static/libpq-example.html#LIBPQ-E
XAMPLE-2
Can you post relevant parts of your code?
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Albe Laurenz | 2012-04-30 08:03:17 | Re: problems after restoring from a pg_basebackup |
Previous Message | Simon Riggs | 2012-04-30 07:13:32 | Re: postgresql standby using pg_archivecleanup don't work |