Re: [**EXTERNAL**] Re: [pgsql-admin] "Soft-hitting" the 1600 column limit

[Ron <ronljohnsonjr@xxxxxxxxx>]

On 06/06/2018 01:54 PM, Moradhassel, Kavian wrote:

To my mind, it makes perfect sense for columns to persist in the table structure when dropped…the only question I have is whether the column would survive a VACUUM FULL?  i.e. if the table is rewritten after the column is dropped, would that change things?

 

Kav Moradhassel | Ciena

kmoradha@xxxxxxxxx | 385 Terry Fox Drive | Ottawa, ON, K2K 0L1  Canada

+1

Another solution would be to dump/drop/create/load just that table.

--
Angular momentum makes the world go 'round.