If frontend dies?

From: Leon <leon(at)udmnet(dot)ru>
To: "'pgsql-general(at)hub(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: If frontend dies?
Date: 1999-07-16 11:08:04
Message-ID: 378F1294.8FEE6E04@udmnet.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Leon 1999-07-16 13:11:17 Weird behavior of 'default user'
Previous Message Leon 1999-07-16 10:59:20 Re: [GENERAL] Weird behavior of 'default user'