"David G. Johnston" writes:
> On Mon, Jul 15, 2019 at 8:42 AM Paul Guo wrote:
>> This seems to a bit vague for users (how to rewrite but keep the table
>> definition) and it seems to still keep the dropped columns (though with
>> null). Isn't it better to leave the functionality to command like
On Mon, Jul 15, 2019 at 8:42 AM Paul Guo wrote:
> This seems to a bit vague for users (how to rewrite but keep the table
> definition) and it seems to still keep the dropped columns (though with
> null). Isn't it better to leave the functionality to command like 'vacuum
> full' to completely
Hello hackers,
I have been having a question about this with no answer from various sources
. As known after dropping a column using 'alter table', table is not
rewritten and vacuum full does not remove them also (still see the dropped
column in pg_attribute).
PG document says: