"Jim C. Nasby" <jimn(at)enterprisedb(dot)com> writes:
> One problem I see with userlock is that you're asking for lock ID
> conflicts unless you control everything on the system that's using
> userlocks.
Well, the lock IDs already include the database OID under the hood,
so you only need to control stuff within your database. Beyond that,
yeah, it's your responsibility...
regards, tom lane