On 02 Apr 2014, at 20:13, Victor Sterpu <vic...@caido.ro> wrote: > There may pass a few days or weeks until next lock. > But I don't undesrtand why the whole table is locked if there is one > uncommited transaction. > > The following scenario might be the cause: > 1. Transaction is started > 2. the client application is closed because of a power surge, the started > transaction will never be commited > 3. from the server point of view there is a unfinished transaction that will > block future statements > > Is this normal behaviour?
I’m pretty sure that with such a powersurge the connection gets closed, causing the transaction to roll back. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll find there is no forest. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
