Re: Add primary keys to system catalogs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Add primary keys to system catalogs
Дата
Msg-id 346555.1610994782@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Add primary keys to system catalogs  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Add primary keys to system catalogs  ("Joel Jacobson" <joel@compiler.org>)
Список pgsql-hackers
I wrote:
> ... I still like the idea of marking OID relationships in the
> catalog headers though.  Perhaps we should take Joel's suggestion
> of a new system catalog more seriously, and have genbki.pl populate
> such a catalog from info in the catalog header files.

On second thought, a catalog is overkill; it'd only be useful if the data
could change after initdb, which this data surely cannot.  The right way
to expose such info to SQL is with a set-returning function reading a
constant table in the C code, a la pg_get_keywords().  That way takes a
whole lot less infrastructure and is just as useful to SQL code.

[ wanders away wondering about a debug mode in which we actually validate
OIDs inserted into such columns... ]

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: schema variables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: search_plan_tree(): handling of non-leaf CustomScanState nodes causes segfault