Re: relid of non user created tables

On 2/7/15 5:55 AM, Tom Lane wrote:
> Deepak S <in(dot)live(dot)in(at)live(dot)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 this value 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