Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5ABDE475531 for ; Mon, 12 Aug 2002 23:51:03 -0400 (EDT) Received: from mail1.acecape.com (mail1.acecape.com [66.114.74.12]) by postgresql.org (Postfix) with ESMTP id CFD50475476 for ; Mon, 12 Aug 2002 23:51:02 -0400 (EDT) Received: from wahaha (p67-47.acedsl.com [66.114.67.47]) by mail1.acecape.com (8.12.2/8.12.2) with ESMTP id g7D3p3gW007405; Mon, 12 Aug 2002 23:51:07 -0400 From: "Wei Weng" To: "'Robert Treat'" Cc: Subject: =?gb2312?B?tPC4tDogW1NRTF0gSXMgdGhpcyB2YWxpZD8=?= Date: Mon, 12 Aug 2002 23:52:05 -0400 Message-ID: <000501c2427c$cac744b0$2f437242@wahaha> MIME-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: quoted-printable X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: <1029197405.2981.2.camel@camel> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/194 X-Sequence-Number: 9040 I am using C++ and libpq.=20 Thanks Wei -----=D3=CA=BC=FE=D4=AD=BC=FE----- =B7=A2=BC=FE=C8=CB: Robert Treat [mailto:xzilla@users.sourceforge.net]=20 =B7=A2=CB=CD=CA=B1=BC=E4: Monday, August 12, 2002 8:10 PM =CA=D5=BC=FE=C8=CB: Wei Weng =B3=AD=CB=CD: pgsql-sql@postgresql.org =D6=F7=CC=E2: Re: [SQL] Is this valid? 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. :) >=20 > 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? >=20 > Thanks >=20 >=20 > --=20 > Wei Weng > Network Software Engineer > KenCast Inc. >=20 >=20 >=20 > ---------------------------(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