Hannu Krosing <hannu@skype.net> writes:
> Is it possible to release a lock without commit ?
Yes, but I don't see where that helps you here.
(To do any of this, you'd need to use the same kluge VACUUM does to hold
selected locks across a series of transactions. So in reality you'd
probably be thinking of committing a startup transaction and letting
some of the locks be released by that.)
regards, tom lane
