Re: Getting NOT NULL constraint from pg_attribute

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Getting NOT NULL constraint from pg_attribute
Дата
Msg-id 29075.1535039315@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Getting NOT NULL constraint from pg_attribute  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> And arguably there's a fair bit of redundancy in pg_attribute, just
> because it's convenient for tupledescs.  Given that pg_attribute very
> commonly is the largest catalog table by far, that very well could use
> some attention.  Without tupdescs in mind, there's really not much point
> for pg_attribute to repeat a good portion of pg_type again, for example,
> nor is attcacheoff really meaningful.

Agreed about attcacheoff, but I'm less sure that we can drop the
"redundant" info copied from pg_type.  The sticking point there is
that somebody could drop a column, then drop the type the column had,
but you still need to be able to skip over values in that column.
So at least attlen and attalign are not removable.

            regards, tom lane


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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal: schema private functions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: A really subtle lexer bug