Re: - Mailing list pgsql-general

From Tom Lane
Subject Re:
Date
Msg-id 25493.1099876425@sss.pgh.pa.us
Whole thread Raw
In response to  (Einar Már Björvinsson <emb@media.is>)
List pgsql-general
=?iso-8859-1?Q?Einar_M=E1r_Bj=F6rvinsson?= <emb@media.is> writes:
> The program starts by opening a connection to the database, enter the =
> infinite while loop to run some functions.=20

> Inside the while loop it forks many childs which then call one function =
> from the library I made.

Are you trying to say that you are opening a database connection in the
parent process and passing it down for the children to play around with?
This is a fairly bad idea, unless you have an interlock mechanism to
ensure that only one child uses it at a time.

> It is as if the handle to the connection is not valid any more.=20

Perhaps the child is closing the connection when it's done with it.

            regards, tom lane

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Postresql RFD version 2.0 Help Wanted.
Next
From: Tatsuo Ishii
Date:
Subject: Re: Can this be indexed?