Re: Is this valid?

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