On 9/22/06, Jim C. Nasby <[EMAIL PROTECTED]> wrote:
I'm not asking for a defined solution to how to support multiple
different users of locks within the same database. I just want us to set
aside (as in, recommend they not be used) some set of numbers so that in
the future we could recommend a means of picking lock numbers that will
avoid collisions.

you pretty much already have this, current advisory lock exposes 64
bits of locktag storage.  there is 112 bits (3 int4 and 1 int2)
available.   this is since 8.1 when locktag was reorganized.  I was
actually going to suggest esposing these fields but had second
thoughts due to future proofing issues.

note i am not arguing that advisory lock should not be expanded in the
future or do string maps, just that at present talking about reserved
ranges would just confuse people since the lock space is intentionally


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not

Reply via email to