On Mon, 2002-08-12 at 23:58, Weiping He wrote: > Wei Weng wrote: > > >I am not sure if this is the right mailing list I talk to. Please let me > >know if I had violated any unwritten rules. :) > > > >I have a global variable PGconn* m_pgconn that is the connection handle > >for connecting to the postgresql database. Can I access/use the handle > >from multiple threads? Say I have a thread that does some insertion > >through this handle/database connection(m_pgconn) and also another > >thread that do some insertion *on the same table* through this > >handle(m_pgconn), will that break? > > > >Thanks > > > > > > > > > I don't think it's a good idea to use global variable > in multi-thread environment. > I think use different handle in differents is better. > > libpq is thread safe, but it doesn't necessary mean > that you could free of your own code. > Is it going to be resource draining if I make lots of connections in a very short time?
-- Wei Weng Network Software Engineer KenCast Inc. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
