fork() bad - Mailing list pgsql-general

From Richi Plana
Subject fork() bad
Date
Msg-id Pine.LNX.4.04.9903222125190.2296-100000@jaguar.mozcom.com
Whole thread Raw
Responses Re: [GENERAL] fork() bad
List pgsql-general
Hi,

I'm probably doing something wrong here.

My process establishes a connection with a PostgreSQL backen and then
fork()s (twice, actually). To make things even more complicated (though I
don't know if it affects things), my connection handle is a global
variable in a dynamically-loaded shared object.

I tried PQreset()ing the connections after forking and then I'd try a
begin but I'd get the ff.:

NOTICE:  BeginTransactionBlock and not in default state

What does that mean?


So, what's the deal with fork()ing and connections?


L   L Richi Plana 8^)         ,-,-.     ,-,-.     ,-,-.     ,-,-.     ,-
LL LL Systems Administrator  / / \ \   / / \ \   / / \ \   / / \ \   / /
LLLLL Mosaic Communications, Inc. \ \ / /   \ \ / /   \ \ / /   \ \ / /
LLLLL mailto:richip@mozcom.com     `-'-'     `-'-'     `-'-'     `-'-'
------------------------------------------------------------------------
P G P Key available at http://www2.mozcom.com/~richip/richip.asc
Tired of Spam? Join this CAUCE! http://www.cauce.org/


pgsql-general by date:

Previous
From: Richi Plana
Date:
Subject: max # concurrent?
Next
From: M Simms
Date:
Subject: Re: [GENERAL] fork() bad