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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
