Re: When the locially dropped column is also physically dropped

[Jim Nasby <decibel(at)decibel(dot)org>]

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(at)nasby(dot)net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)