AgentM <agentm(at)themactionfaction(dot)com> writes:
> If I want to use these locks, it seems I will have to hard-code some
> offset into each app or hash the schema name and use that as an
> offset :( In any case, I can't imagine the "wtf?" nightmares an
> accidental collision would induce.
That depends entirely on how you are choosing to assign the lock key
numbers. If you use something involving table OID, for example, there
is not a risk of collision from schema considerations.
regards, tom lane