"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> Is it possible for one backend (with superuser privs) to release a lock
> held by anotether?
As of 8.0 this is not possible for regular locks, because there'd be no
way to update the other backend's internal data structure that shows
what locks it holds. I think though that there is no corresponding
structure for userlocks and so in principle it could be done for
userlocks.
Whether it's a good idea is a whole 'nother question. It strikes me
as a foot-gun with no evident redeeming social value. In particular,
there would most likely be some state inside the client app showing
that it holds this userlock, and so the inability-to-update-state
problem comes right back at that level.
regards, tom lane