Re: How to release locks

"Andrus" <eetasoft@online.ee> wrote
>
> insert command takes a long time. I terminated the client application from
> Windows XP client manager during insert command.
> At next re-run application and pgadmin both hang in DELETE FROM line
>
> I think I can reproduce this. Postgres server is in FreeBSD.
> I can require server admin to do something after the problem occurs.
>
> What should I do after reproducing the problem ?
>

A backtrace information would be most useful. Just build a debug verison
(--enable-debug) and restart the server, when you reproduce the problem,
attach gdb to it, then "bt".

Regards,
Qingqing