Re: OID conflicts - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: OID conflicts
Date
Msg-id 20060918212011.GK8796@svana.org
Whole thread Raw
In response to OID conflicts  (Gevik Babakhani <pgdev@xs4all.nl>)
Responses Re: OID conflicts  (Tom Dunstan <pgsql@tomd.cc>)
List pgsql-hackers
On Mon, Sep 18, 2006 at 10:09:52PM +0100, Tom Dunstan wrote:
> Hmm. A simpler way lessen the pain might be to have a script which could
> update OIDs in your catalog files. You'd have to run it BEFORE doing a
> merge. Ie, suppose I've allocated 2978-2991 in my patch, but since then
> OIDs have been allocated up to and including 2980. The way to tell that

<snip>

Seems awfully complicated. The numbers don't mean anything, they don't
have to be contiguous. If you want to reduce the chance of conflict,
find a nice big block in unused_oids, add a random number between 0 and
100 and use that. Or squeeze yourself into a block that exactly fits
what you need. There's simply not that many patches that need numbers
to worry about anything complicated.

When I needed a few dozen OIDs for an (unapplied) patch I simply picked
2900 and went up from there. That was a while ago and there's no
conflict yet.

Have anice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [PATCHES] Patch for UUID datatype (beta)
Next
From: Peter Eisentraut
Date:
Subject: Re: new language translation (.po)