Re: berkley sockets

J S B wrote:
> What exactly is this LISTEN/NOTIFY?
> Is it some function in socket programing or some part of postgres?
>
> ~Jas
>
Listen/Notify is a means of letting a connected postgresql client know a
insert or other event has occurred.
It won't help if you need to send a command/message to some other tcp/ip
daemon.

You set up a rule to use Notify:

create rule InsertDetect as on INSERT to notify_test do notify recinsert

Then on the client side (if the client has libpq listen capability) you
listen for the incoming notification messages and react to them
accordingly.

--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration