I hope, U can have a structure that have members as the "user name" and the "Connection object". Whenever a new connection is made, U can create instances of this structure. Based on the user name, you can pass the appropriate instance to the function. Hope this will help you. Is this what you want? Regards, Mani -----Original Message----- From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx]On Behalf Of Michael Fuhr Sent: Friday, September 02, 2005 11:29 AM To: sandhya Cc: Askar Zaidi; postgre Subject: Re: [ADMIN] Reg:Connection Object On Fri, Sep 02, 2005 at 11:19:53AM +0530, sandhya wrote: > In case of multiple users what will happen? > Each must have different connection objects right! That's why global variables are bad. But what's wrong with passing a PGconn * to various functions? If that's a problem in your application then please explain why; it's still not clear what difficulties you're having. Perhaps it would help if you posted a simple but complete example program that shows what you're trying to do. As I mentioned before, this thread is off-topic for pgsql-admin; it would be more appropriate in pgsql-interfaces or pgsql-general. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
