Re: [HACKERS] When the locially dropped column is also physically dropped

2007-04-28 Thread Heikki Linnakangas
Jim Nasby wrote: On Apr 27, 2007, at 12:35 PM, Gregory Stark wrote: 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 al

Re: [HACKERS] When the locially dropped column is also physically dropped

2007-04-27 Thread Jim Nasby
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 w

Re: [HACKERS] When the locially dropped column is also physically dropped

2007-04-27 Thread Gregory Stark
"rupesh bajaj" <[EMAIL PROTECTED]> writes: > Hi, > 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 wi

[HACKERS] When the locially dropped column is also physically dropped

2007-04-27 Thread rupesh bajaj
Hi, 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 auto