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

From Peter Geoghegan
Subject Re: The unused_oids script should have a reminder to use the8000-8999 OID range
Date
Msg-id CAH2-WznHrXoEN8qp57gTLQEtDao-xCr_ZXP7-Sqyr315rW4ZvQ@mail.gmail.com
Whole thread Raw
In response to Re: The unused_oids script should have a reminder to use the8000-8999 OID range  (Julien Rouhaud <rjuju123@gmail.com>)
Responses Re: The unused_oids script should have a reminder to use the8000-8999 OID range  (Julien Rouhaud <rjuju123@gmail.com>)
Re: The unused_oids script should have a reminder to use the 8000-8999 OID range  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Aug 2, 2019 at 1:42 AM Julien Rouhaud <rjuju123@gmail.com> wrote:
> Trivial patch for that attached.

Thanks!

> The output is now like:
>
> [...]
> Using an oid in the 8000-9999 range is recommended.
> For instance: 9427
>
> (checking that the suggested random oid is not used yet.)

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

I would like to push this patch shortly. How do people feel about this
wording? (It's based on the documentation added by commit a6417078.)

-- 
Peter Geoghegan

Attachment

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: partition routing layering in nodeModifyTable.c
Next
From: Andres Freund
Date:
Subject: Re: pglz performance