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                                            [EMAIL PROTECTED]
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to