Re: How to release locks

> Do you mean that the statement hadn't been fully transmitted yet?

Yes. Sending 2 MB takes most of time so client is terminated in this stage.

> If so, the backend would have just been waiting for the rest of the
> statement to arrive.  Perhaps you're looking at some sort of network bug
> that caused the backend not to be told that the connection was lost.

If so why pgAdmin Cancel command does not terminate the process ? If process
is waiting for data,
Cancel signal sent through pgAdmin should terminate process immediately.

Andrus.