Re: ALTER TABLE modifications

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: pg(at)fastcrypt(dot)com, Hannu Krosing <hannu(at)tm(dot)ee>, PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: ALTER TABLE modifications
Date: 2003-11-14 14:57:46
Message-ID: Pine.LNX.4.44.0311141556360.4276-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Rod Taylor writes:

> The method is rename old column, add new column, move data across, move
> or reform dependencies, drop old column.

I can do this by hand. If we have an explicit command to do it, then it
needs to preserve the table schema. Else, this feature would be mostly
useless and a certain source of complaints.

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 2003-11-14 15:32:41 Re: cvs head? initdb?
Previous Message Tom Lane 2003-11-14 14:47:23 Re: Problem with compilation 7.3.4

Browse pgsql-patches by date

  From Date Subject
Next Message Rod Taylor 2003-11-14 15:48:59 Re: ALTER TABLE modifications
Previous Message Rod Taylor 2003-11-14 14:32:57 Re: ALTER TABLE modifications