Received: from feivel.fam-meskes.de (postfix@p3EE015E1.dip0.t-ipconnect.de [62.224.21.225]) by hub.org (8.9.3/8.9.3) with ESMTP id FAA29507 for ; Tue, 2 May 2000 05:38:02 -0400 (EDT) (envelope-from michael@fam-meskes.de) Received: by feivel.fam-meskes.de (Postfix, from userid 1000) id 1C53A2BCE4; Tue, 2 May 2000 11:24:07 +0200 (CEST) Date: Tue, 2 May 2000 11:24:07 +0200 From: Michael Meskes To: Tom Lane Cc: ganesan , pgsql-interfaces@postgresql.org Subject: Re: NOTICE: BeginTransactionBlock and not in default Message-ID: <20000502112407.B3097@fam-meskes.de> Mail-Followup-To: Tom Lane , ganesan , pgsql-interfaces@postgresql.org References: <390221CE.8421F2B2@technauts.com> <29250.956445314@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.1.9i In-Reply-To: <29250.956445314@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Sat, Apr 22, 2000 at 07:15:14PM -0400 X-Archive-Number: 200005/18 On Sat, Apr 22, 2000 at 07:15:14PM -0400, Tom Lane wrote: > > I could open database connection in the parent process and > > pass it on to all the children. > > Wrong ... you'll have to make each child open its own connection. > There's no provision in the backend for dealing with concurrent > queries coming through the same socket. I'm surprised it didn't > crash even more spectacularly than you describe... That's because the queries didn't make it to the backend at all. libecpg does not know which connection to send the query to and thus gives this error message. Michael -- Michael Meskes | Go SF 49ers! Th.-Heuss-Str. 61, D-41812 Erkelenz | Go Rhein Fire! Tel.: (+49) 2431/72651 | Use Debian GNU/Linux! Email: Michael@Fam-Meskes.De | Use PostgreSQL!