How to unlock a table after client dies during a transaction?

From: Ting Zhou <zhout(at)PLUM(dot)BAYLOR(dot)EDU>
To: pgsql-general(at)hub(dot)org
Subject: How to unlock a table after client dies during a transaction?
Date: 1999-10-21 05:29:12
Message-ID: Pine.SOL.3.91.991020235848.22398B-100000@burro.baylor.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Yan Zhang Chen 1999-10-21 06:02:13 How to build pgsql without producing the shared lib libpg.so?
Previous Message Johann Höchtl 1999-10-21 01:33:26 When will it be implemented