How to unlock a table after client dies during a transaction? - Mailing list pgsql-general

From Ting Zhou
Subject How to unlock a table after client dies during a transaction?
Date
Msg-id Pine.SOL.3.91.991020235848.22398B-100000@burro.baylor.edu
Whole thread Raw
List pgsql-general
Hi,

My client application dies during a transaction ( insert into a table ).
Next time when connect to psql again and try to operate on the same table,
it's trapped in a deadlock scenario.  Is there any way to unlock the table?

And another problem is that if psql exit unexpectedly during a client
application during which a new table is created, the transaction is
rolled back, but a table with the same name can not be created anymore.
How to solve this problem?

Thanks a lot

Zhou

pgsql-general by date:

Previous
From: Johann Höchtl
Date:
Subject: When will it be implemented
Next
From: Yan Zhang Chen
Date:
Subject: How to build pgsql without producing the shared lib libpg.so?