Re: How to release locks - Mailing list pgsql-general

From Andrus
Subject Re: How to release locks
Date
Msg-id dvupv7$rbd$1@news.hub.org
Whole thread Raw
In response to Re: How to release locks  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
List pgsql-general
I find that my killed connection server process process disappear in Status
after a long time.

> If pgAdmin's cancel is just dropping the connection, the server might
> take some time to notice it, especially if it's in the process of  running
> a query and doesn't have reason to talk to pgAdmin.

I think pgAdmin sends cancel command through postgres server main process.
So server
receives it immediately and sends it immediately to selected child process.

I don't have an idea what pgadmin cancel command exactly does.
After executing it processes remain visible in Status pane always.
I set log_statement = 'all'  in postgres.conf file but cancel command does
not wrote any entry to log file.

There is also Terminate button in Status panel but it is always disabled. I
havent found way to enable it.



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Advantages of PostgreSQL over MySQL 5.0
Next
From: "Brian Kitzberger"
Date:
Subject: Re: Hi,