On Thu, May 3, 2012 at 3:52 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > I'm inclined to say that you can PREPARE if your session holds a given > advisory lock at either session or transaction level, but not both. > This is a bit annoying but doesn't seem likely to be a real problem in > practice, so thinking of a hack to support the case seems like more > work than is justified.
I'd be more inclined to say that if you have a session-level lock, you can't prepare, period. Doesn't a rollback release session-level locks? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers