Postgres Pro
Downloads
Home   >   mailing lists

Re: relid of non user created tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: relid of non user created tables
Date
Msg-id 13789.1423310114@sss.pgh.pa.us
Whole thread Raw
In response to relid of non user created tables  (Deepak S <in.live.in@live.in>)
Responses Re: relid of non user created tables  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
Tree view 
Deepak S <in.live.in@live.in> writes:
> I wish to know if it is safe to assume that non user created tables always have a relid of less than 10,000 (I chose
thisvalue after trial and error).
 

Depends what you consider "user created".  System catalogs with
manually-assigned OIDs will have OIDs below 10K, but initdb creates
numerous things that don't have manually-assigned OIDs.  And what of,
say, TOAST tables attached to user tables?

You might find the comments for FirstNormalObjectId in
src/include/access/transam.h enlightening.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Stas Kelvich
Date:
Subject: Re: Cube extension kNN support
Next
From: Magnus Hagander
Date:
Subject: Re: New CF app deployment