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

From Qingqing Zhou
Subject Re: How to release locks
Date
Msg-id dvr0g0$28gv$1@news.hub.org
Whole thread Raw
In response to Re: How to release locks  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
List pgsql-general
"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



pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: How to release locks
Next
From: "surabhi.ahuja"
Date:
Subject: back slash separated values