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
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
"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
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