Re: Question on notifications

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

In response to

Responses

Browse pgsql-general by date

  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