Re: [GENERAL] Using connection after fork

2004-08-10 Thread Tom Lane
Jeff <[EMAIL PROTECTED]> writes: > I've been bit by this sort of thing before. When you fork() the child > inherits all the file descriptors , including the one connected to PG. > But when the child dies that FD will be closed, thus it will also be > closed in the parent causing "odd behavior

[GENERAL] Using connection after fork

2004-08-10 Thread Peter Eisentraut
I'm looking at a database-using program (PostgreSQL/libpq and MySQL) which does the following: A daemon process opens a database connection, forks children on request, and those children access the database using that inherited connection. After one request, the child dies. It seems to me th