If frontend dies? - Mailing list pgsql-general

From Leon
Subject If frontend dies?
Date
Msg-id 378F1294.8FEE6E04@udmnet.ru
Whole thread Raw
List pgsql-general
Hi!

It's me again. One more question:

Suppose you begin a transaction, create a table and then your
frontend dies. Backend still thinks that transaction is in
progress and doesn't allow creation of table with the same
name to other frontends. Restarting postmaster doesn't help.

So here is the question: what do I do with such 'zombie'
transactions? (The answer, I think , should have been in FAQ.)

--
Leon.


pgsql-general by date:

Previous
From: Leon
Date:
Subject: Re: [GENERAL] Weird behavior of 'default user'
Next
From: Michael Doornbos
Date:
Subject: concurrent connections