Set all variable-length fields of pg_attribute to null on column drop

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Set all variable-length fields of pg_attribute to null on column drop
Дата
Msg-id 249d819d-1763-4580-8110-0bf91a0f08b7@eisentraut.org
обсуждение исходный текст
Ответы Re: Set all variable-length fields of pg_attribute to null on column drop
Re: Set all variable-length fields of pg_attribute to null on column drop
Список pgsql-hackers
I noticed that when a column is dropped, RemoveAttributeById() clears 
out certain fields in pg_attribute, but it leaves the variable-length 
fields at the end (attacl, attoptions, and attfdwoptions) unchanged. 
This is probably harmless, but it seems wasteful and unclean, and leaves 
potentially dangling data lying around (for example, attacl could 
contain references to users that are later also dropped).

I suggest the attached patch to set those fields to null when a column 
is marked as dropped.
Вложения

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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: Report planning memory in EXPLAIN ANALYZE
Следующее
От: "Hayato Kuroda (Fujitsu)"
Дата:
Сообщение: RE: Is this a problem in GenericXLogFinish()?