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

On 12/16/05, Neil Drumm <drumm@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