Re: relid of non user created tables

On 2/7/15 5:55 AM, Tom Lane wrote:
> 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.

I think the better question is "Why do you want to know this?" I suspect 
there's a better way to do whatever you're trying to do.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com