From: Weiping He <laser@zhengmai.com.cn>
To: Wei Weng <wweng@kencast.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Is this valid?
Date: Tue, 13 Aug 2002 11:58:02 +0800
Message-ID: <3D5883CA.8030803@zhengmai.com.cn> (raw)
References: <1029194489.28129.3.camel@Monet>
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.
regards laser
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: laser@zhengmai.com.cn, wweng@kencast.com
Subject: Re: Is this valid?
In-Reply-To: <3D5883CA.8030803@zhengmai.com.cn>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox