On 20.04.2011 17:51, Tom Lane wrote:
... which means that the first transaction is completed and can no longer be holding any locks.
Predicate locks are held after transaction commit. They can only be cleaned once the xid is older than the oldest xmin among all active serializable transactions.
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs