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 also work, right?

Well, yes, except that it will bloat the table. If you wanted to physically drop the column to save space, you're not going to be happy with that.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to