Re: relid of non user created tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: relid of non user created tables
Дата
Msg-id 13789.1423310114@sss.pgh.pa.us
обсуждение исходный текст
Ответ на relid of non user created tables  (Deepak S <in.live.in@live.in>)
Ответы Re: relid of non user created tables  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-hackers
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 по дате отправления:

Предыдущее
От: Stas Kelvich
Дата:
Сообщение: Re: Cube extension kNN support
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: New CF app deployment