Re: BUG #8095: postgres acquiring lock on a table when not in transaction - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #8095: postgres acquiring lock on a table when not in transaction
Date
Msg-id 9653.1366491731@sss.pgh.pa.us
Whole thread Raw
In response to BUG #8095: postgres acquiring lock on a table when not in transaction  (vaiayand@gmail.com)
List pgsql-bugs
vaiayand@gmail.com writes:
> We investigated one issue and found the following:
> postgres is acquiring a lock on table when not in trancation during prepared
> ROLLBACK statement. It is releasing the acquired lock at end.
> but postgres should not get lock on a table when not in transaction. After
> acquiring any lock, if backend process dies (say SIGTERM signal), the
> postgres will be in lock-not-released state.

Thanks for the report.  I believe I've fixed this.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Nachiket Vaidya
Date:
Subject: missing attachment for bug 8095
Next
From: E E
Date:
Subject: Re: BUG #8056: postgres forgets hstore over time