Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id ED2CF475751 for ; Mon, 12 Aug 2002 20:14:24 -0400 (EDT) Received: from briar.mmrd.com (unknown [208.255.226.182]) by postgresql.org (Postfix) with ESMTP id 5E08D475531 for ; Mon, 12 Aug 2002 20:14:24 -0400 (EDT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by briar.mmrd.com (8.11.2/8.11.2) with ESMTP id g7D1D0728243; Mon, 12 Aug 2002 21:13:00 -0400 Received: from [172.25.1.55] ([172.25.1.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id g7D0EQx05408; Mon, 12 Aug 2002 20:14:26 -0400 Subject: Re: Is this valid? From: Robert Treat To: Wei Weng Cc: pgsql-sql@postgresql.org In-Reply-To: <1029194489.28129.3.camel@Monet> References: <1029194489.28129.3.camel@Monet> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 12 Aug 2002 20:10:05 -0400 Message-Id: <1029197405.2981.2.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/190 X-Sequence-Number: 9036 I'm going to ask the crazy question of what language/interface are you using to interact with postgres? Based on my interpretation of your question I'd say that won't break (though one of your queries might fail) but then again I may be totally misreading what you wrote... Robert Treat On Mon, 2002-08-12 at 19:21, 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 > > > -- > Wei Weng > Network Software Engineer > KenCast Inc. > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly