Re: [HACKERS] Does having a NULL column automatically exclude the table from the tupleDesc cache?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Does having a NULL column automatically exclude the table from the tupleDesc cache?
Дата
Msg-id 16777.1487179006@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [HACKERS] Does having a NULL column automatically exclude the table from thetupleDesc cache?  (Ryan Murphy <ryanfmurphy@gmail.com>)
Ответы Re: [HACKERS] Does having a NULL column automatically exclude thetable from the tupleDesc cache?  (Ryan Murphy <ryanfmurphy@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Ryan Murphy <ryanfmurphy@gmail.com> writes:
> My question is this:  HeapTupleNoNulls() is run first to see if there are
> any columns that can be NULL.  It looks like the fetchatt() that uses the
> cache in the tupleDesc can only be used if there are no NULLable columns in
> the table.  Is my understanding correct?

No, that tests whether the particular tuple contains any null fields, not
whether the whole table is declared NOT NULL.
        regards, tom lane

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: [HACKERS] [PATCH] Fix pg_proc comment grammar
Следующее
От: Ryan Murphy
Дата:
Сообщение: Re: [HACKERS] Does having a NULL column automatically exclude thetable from the tupleDesc cache?