Re: When the locially dropped column is also physically dropped

On Apr 27, 2007, at 12:35 PM, Gregory Stark wrote:
>> I have dropped a column (say column name is 'A') from the relation  
>> R. By
>> setting the attisdropped as true in the pg_catalog.pg_attribute  
>> table. But
>> the column is dropped locially not the physically. Can you please  
>> tell me
>> when this column will be physically also dropped. Is this column is
>> automatically physically dropped? or I have to run some command to  
>> dropped
>> it physically.
>
> These kinds of questions are best sent to pgsql-general instead of - 
> hackers.
>
> The column won't be dropped physically until you execute one of the  
> commands
> that rewrites the table entirely. "CLUSTER" and "ALTER TABLE ALTER  
> column TYPE
> type" are the two popular ones.

UPDATE SET field1 = field1; would also work, right?
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)