Re: Warning: you don't own a lock of type ExclusiveLock - Mailing list pgsql-general

From Gary Chambers
Subject Re: Warning: you don't own a lock of type ExclusiveLock
Date
Msg-id alpine.DEB.2.00.1202091347180.25264@equinox.garychambers.com
Whole thread Raw
In response to Re: Warning: you don't own a lock of type ExclusiveLock  (Chris Angelico <rosuav@gmail.com>)
List pgsql-general
Chris,

> pg_advisory_unlock (along with the other functions in that family) works
> on a set of mythical objects with no actual meaning beyond what the
> database administrator chooses to give them.

Thank you for your excellent description.  I have never used the advisory
lock functionality that Postgres provides, and your reply combined with
Merlin's multi-part primer on them, it's easy to see their value,
application, and implementation.

Finally, with respect to my original request, it's quite conceivable that
the application is attempting to free the lock more times than it requested
it.  Thank you again for your reply!

-- Gary Chambers

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Strategy for Primary Key Generation When Populating Table
Next
From: Rich Shepard
Date:
Subject: Re: Strategy for Primary Key Generation When Populating Table