Re: question regarding pg_database.h and DatabaseRelationId - Mailing list pgsql-hackers

From Martijn van Oosterhout
Subject Re: question regarding pg_database.h and DatabaseRelationId
Date
Msg-id 20060418081358.GA30923@svana.org
Whole thread Raw
In response to Re: question regarding pg_database.h and DatabaseRelationId  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
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.

pgsql-hackers by date:

Previous
From: "energumen@buaa.edu.cn"
Date:
Subject: how can i get the binary format of timestamp?
Next
From: Hannu Krosing
Date:
Subject: Re: Is full_page_writes=off safe in conjunction with