[development] Postgres- For compatibility reasons we don't drop columns but rename them?

Chris Johnson chris at tinpixel.com
Sat Dec 17 04:43:59 UTC 2005

Rowan Kerr wrote:
> On 12/16/05, Neil Drumm <drumm at delocalizedham.com> wrote:
>>Postgres: ALTER TABLE {$table} RENAME $column TO $column_old // For
>>compatibility reasons we don't drop columns but rename them
>>Why do we do this? What compatibility reasons?
> It's been a while since I dealt with any of our pg stuff at work, but
> I think Postgres doesn't actually allow you to drop columns... You
> would have to create a new table without the column, and then move all
> the data over.
> Could be completely off-base though!
> -Rowan

Postgres 7.4 and 8.0 can both drop a column.


More information about the development mailing list