Re: When the locially dropped column is also physically dropped

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: When the locially dropped column is also physically dropped
Date: 2007-04-30 17:09:41
Message-ID: 463622D5.80709@cox.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 04/27/07 07:01, rupesh bajaj wrote:
> 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
> automatically physically dropped? or I have to run some command to dropped
> it physically.

Why didn't you drop the column the proper way?

- --
Ron Johnson, Jr.
Jefferson LA USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGNiLVS9HxQb37XmcRAs/rAJ9KkXKlagXCe+RWnNd2824gZ0MTdQCgwHRy
uA2IsmiFw7WjrexvEHeY7w8=
=pqnT
-----END PGP SIGNATURE-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Markus Wollny 2007-04-30 17:20:12 Questions about TSearch2 and PG 8.2
Previous Message philippe 2007-04-30 16:46:43 Re: Server crash on postgresql 8.2.4 with tsearch2

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc Munro 2007-04-30 18:34:16 Re: Feature freeze progress report
Previous Message Josh Berkus 2007-04-30 17:04:25 Re: Feature freeze progress report