That's interesting and is probably the answer to my question as to why
this happens. Thanks, Nick. What it doesn't explain is why I was
able to connect to a test database using PhpPgAdmin and close the
browser, without logging out, and I was able to rename my test
database. I couldn't reproduce the behavior. I wonder if it is a
property of the particular browser or desktop platform. I was using
Firefox on a Mac. The users use Windows. I'm not sure which browser
they are using.
I also still want to know if there is a way to gracefully break that
persistent connection on the server side. Using a PHP front end over
the web, I don't always know who has a browser open.
Thanks,
Carol
On Mar 4, 2009, at 9:36 AM, Hajek, Nick wrote:
>>
>> The users are accessing the database using PhpPgAdmin. I
>> thought that this might happen if they closed the browser
>> without closing logging off. I know that if you do that the
>> browser will return to where you left it, when you open it
>> again. I tried that with my own database, and I couldn't
>> reproduce the condition.
>>
>> Carol
>
>
> A persistent connection is often used with PHP. With this, PHP will
> maintain the connection after a browser is closed or a user is logged
> off so that the next time a db connection is required, the response
> time
> is better. To break any persistent connections would require
> restarting
> the browser.
>
> Nick Hajek