From: Michael Meskes <meskes@postgresql.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: ganesan <ganesanm@technauts.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: NOTICE: BeginTransactionBlock and not in default
Date: Tue, 2 May 2000 11:24:07 +0200
Message-ID: <20000502112407.B3097@fam-meskes.de> (raw)
In-Reply-To: <29250.956445314@sss.pgh.pa.us>
References: <390221CE.8421F2B2@technauts.com>
<29250.956445314@sss.pgh.pa.us>
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!
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-interfaces@postgresql.org
Cc: meskes@postgresql.org, tgl@sss.pgh.pa.us, ganesanm@technauts.com
Subject: Re: NOTICE: BeginTransactionBlock and not in default
In-Reply-To: <20000502112407.B3097@fam-meskes.de>
* 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