Re: The unused_oids script should have a reminder to use the 8000-8999 OID range - Mailing list pgsql-hackers

From Tom Lane
Subject Re: The unused_oids script should have a reminder to use the 8000-8999 OID range
Date
Msg-id 26966.1564778973@sss.pgh.pa.us
Whole thread Raw
In response to Re: The unused_oids script should have a reminder to use the8000-8999 OID range  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: The unused_oids script should have a reminder to use the8000-8999 OID range  (Peter Geoghegan <pg@bowt.ie>)
Re: The unused_oids script should have a reminder to use the8000-8999 OID range  (Isaac Morland <isaac.morland@gmail.com>)
List pgsql-hackers
Peter Geoghegan <pg@bowt.ie> writes:
> I've taken your patch, and changed the wording a bit. I think that
> it's worth being a bit more explicit. The attached revision produces
> output that looks like this:

> Patches should use a more-or-less consecutive range of OIDs.
> Best practice is to make a random choice in the range 8000-9999.
> Suggested random unused OID: 9099

Maybe s/make a/start with/ ?

Also, once people start doing this, it'd be unfriendly to suggest
9099 if 9100 is already committed.  There should be some attention
to *how many* consecutive free OIDs will be available if one starts
at the suggestion.  You could perhaps print "9099 (42 OIDs available
starting here)", and if the user doesn't like the amount of headroom
in that, they could just run it again for a different suggestion.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Ibrar Ahmed
Date:
Subject: Re: SQL:2011 PERIODS vs Postgres Ranges?
Next
From: Ibrar Ahmed
Date:
Subject: Re: [PROPOSAL] Temporal query processing with range types