Re: [GENERAL] berkley sockets

2006-09-15 Thread Tony Caduto
On Wed, Sep 13, 2006 at 08:40:24PM -0400, J S B wrote: Thanks alot Tony. just wondering if the same can be done with C If you are more comfortable with C, I don't see why you couldn't do the same thing as that PLperl function. It's just a matter of creating a socket and sending a string wit

Re: [GENERAL] berkley sockets

2006-09-15 Thread Tony Caduto
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 othe

Re: [GENERAL] berkley sockets

2006-09-15 Thread J S B
What exactly is this LISTEN/NOTIFY?Is it some function in socket programing or some part of postgres?~JasOn 9/15/06, Martijn van Oosterhout wrote:On Wed, Sep 13, 2006 at 08:40:24PM -0400, J S B wrote: > Thanks alot Tony.> just wondering if the same can be done with CNot entirel

Re: [GENERAL] berkley sockets

2006-09-15 Thread Martijn van Oosterhout
On Wed, Sep 13, 2006 at 08:40:24PM -0400, J S B wrote: > Thanks alot Tony. > just wondering if the same can be done with C Not entirely clear what you're doing, but couldn't you do what you want with LISTEN/NOTIFY. That way the daemon connects to the server too and get notified when other clients

Re: [GENERAL] berkley sockets

2006-09-13 Thread J S B
Thanks alot Tony. just wondering if the same can be done with C ~Jas  On 9/13/06, Tony Caduto <[EMAIL PROTECTED]> wrote: J S B wrote:> I don't want to connect to the postgres database.>> The scenario is something like this. >> Postgres database has to initiate some deamon process running is> anothe

Re: [GENERAL] berkley sockets

2006-09-13 Thread Tony Caduto
J S B wrote: I don't want to connect to the postgres database. The scenario is something like this. Postgres database has to initiate some deamon process running is another server. The only way i could think of doing this was openeing a socket connection between postgres database and the d

Re: [GENERAL] berkley sockets

2006-09-13 Thread Chris Mair
On Wed, 2006-09-13 at 01:51 -0400, J S B wrote: > I don't want to connect to the postgres database. > > The scenario is something like this. > > Postgres database has to initiate some deamon process running is > another server. > The only way i could think of doing this was openeing a socket >

Re: [GENERAL] berkley sockets

2006-09-12 Thread J S B
I don't want to connect to the postgres database.   The scenario is something like this.   Postgres database has to initiate some deamon process running is another server. The only way i could think of doing this was openeing a socket connection between postgres database and the deamon process thr

Re: [GENERAL] berkley sockets

2006-09-12 Thread Martijn van Oosterhout
On Tue, Sep 12, 2006 at 07:52:08PM -0400, J S B wrote: > Hi, > Just wondering if anyone has used Berkley sockets ever. > I'm aiming at establishing a socket connection between my Postgres database > server (using the shared objects that i dynamically load) > and a Unix server. > What would be the b