[GENERAL] a few doubts regarding postgres

2005-02-11 Thread Surabhi Ahuja
 does postgres support notifications.   for eg. through one connection to the server, i begin a transaction and i do inserts there. in another sessions, i want to get notified that inserts are taking place in someother session. please help.   a few other questions   Q1. is there anyway by which

Re: [GENERAL] a few doubts regarding postgres

2005-02-11 Thread Shridhar Daithankar
On Friday 11 Feb 2005 6:01 pm, Surabhi Ahuja wrote: > does postgres support notifications. > > for eg. through one connection to the server, i begin a transaction and i > do inserts there. in another sessions, i want to get notified that inserts > are taking place in someother session. please help

Re: [GENERAL] a few doubts regarding postgres

2005-02-11 Thread Richard Huxton
Surabhi Ahuja wrote: does postgres support notifications. for eg. through one connection to the server, i begin a transaction and i do inserts there. in another sessions, i want to get notified that inserts are taking place in someother session. please help. You might want to look in the manual

Re: [GENERAL] a few doubts regarding postgres

2005-02-11 Thread John DeSoi
On Feb 11, 2005, at 7:47 AM, Shridhar Daithankar wrote: On Friday 11 Feb 2005 6:01 pm, Surabhi Ahuja wrote: does postgres support notifications. for eg. through one connection to the server, i begin a transaction and i do inserts there. in another sessions, i want to get notified that inserts ar

Re: [GENERAL] a few doubts regarding postgres

2005-02-11 Thread Terry Lee Tucker
On Friday 11 February 2005 07:47 am, Shridhar Daithankar saith: > > No. PostgreSQL backend process is single threaded. However each connection > gets a separate backend process. Hence on SMP machines, all available CPUs > can potentially be used for multiple connections. > > Regards, > Shridhar

Re: [GENERAL] a few doubts regarding postgres

2005-02-11 Thread Richard Huxton
Terry Lee Tucker wrote: On Friday 11 February 2005 07:47 am, Shridhar Daithankar saith: No. PostgreSQL backend process is single threaded. However each connection gets a separate backend process. Hence on SMP machines, all available CPUs can potentially be used for multiple connections. Regards, Sh