> 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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster