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

2023-12-22 Thread Peter Eisentraut
On 22.12.23 10:05, Alvaro Herrera wrote: On 2023-Nov-30, Peter Eisentraut wrote: 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

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

2023-12-22 Thread Alvaro Herrera
On 2023-Nov-30, Peter Eisentraut wrote: > 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 w

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

2023-11-30 Thread Robert Haas
On Thu, Nov 30, 2023 at 6:24 AM Peter Eisentraut wrote: > 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

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

2023-11-30 Thread Peter Eisentraut
Eisentraut Date: Thu, 30 Nov 2023 12:19:20 +0100 Subject: [PATCH v1] Set all variable-length fields of pg_attribute to null on column drop When a column is dropped, the fields attacl, attoptions, and attfdwoptions were kept unchanged. This is probably harmless, but it seems wasteful, and leaves