Re: advisory locks and permissions - Mailing list pgsql-hackers

From Tom Lane
Subject Re: advisory locks and permissions
Date
Msg-id 9698.1158952801@sss.pgh.pa.us
Whole thread Raw
In response to Re: advisory locks and permissions  (AgentM <agentm@themactionfaction.com>)
List pgsql-hackers
AgentM <agentm@themactionfaction.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: initdb ignores invalid locale names
Next
From: Tom Lane
Date:
Subject: Re: advisory locks and permissions