Re: question regarding pg_database.h and DatabaseRelationId

On Tue, Apr 18, 2006 at 12:45:27AM +0200, Peter Eisentraut wrote:
> Gevik Babakhani wrote:
> > Could someone explain the numbering logic in naming the relations?
>
> There is none.  The numbers are presumably assigned in some
> lowest-available manner, but over the years it has become pretty
> random.

In the src/include/catalog directory there are two scripts, unused_oids
and duplicate_oids. When you need a new oid you run the unused_oids and
pick one somewhere near the rows with similar meaning. The numbers are
so all over the place that you may as well consider them random...

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.