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

Rowan Kerr rowan0 at gmail.com
Sat Dec 17 03:01:09 UTC 2005


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


More information about the development mailing list