Re: pg_pconnect+PostgreSQL cursors

on 12/26/02 9:59 AM, serg(at)city(dot)gov(dot)te(dot)ua purportedly said:

> I've got closing of cursor and transaction! why??? I use permanent connection,
> why I've got closing of cursor and transaction!???

The "p" in "pconnect" means *persistent*, not permanent. The connection will
persist after the script has completed, however, the connection is handled
by the web server process and its true lifetime is only the lifetime of the
process. For Apache, this will vary by configuration, and is difficult to
predict when hosting multiple sites.

Tip: persistent connections are only useful when you want (and have the
resources to support) to minimize connection overhead. Any other use and you
are likely to be severely disappointed.

Keary Suska
Esoteritech, Inc.
"Leveraging Open Source for a better Internet"