Re: Tuple data

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Tuple data
Дата
Msg-id 19562.977019803@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Tuple data  ("Michael Richards" <miker@interchange.ca>)
Список pgsql-hackers
"Michael Richards" <miker@interchange.ca> writes:
> Sometimes the t_hoff value in the tuple header is 32 which seems to indicate
> no NULL bitmap.

There's no null bitmap unless the HASNULLS infomask bit is set.

> This really makes me wonder what happens when you ALTER
> TABLE ADD COLUMN on a table since it doesn't seem to take more than O(1)
> time. Perhaps it is assumed if the attribute count is less than the actual
> number of attributes then the last ones are NULL and no NULL map is
> required.

ALTER ADD COLUMN doesn't touch any tuples, and you're right that it's
critically dependent on heap_getattr returning NULL when an attribute
beyond the number of attributes actually present in a tuple is accessed.
That's a fragile and unclean implementation IMHO --- see past traffic
on this list.
        regards, tom lane


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: locking bug?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 7.1 features list