request feature: alter view add column (or something like) - Mailing list pgsql-hackers

From Olivier Thauvin
Subject request feature: alter view add column (or something like)
Date
Msg-id 200802291735.03564.olivier.thauvin@aerov.jussieu.fr
Whole thread Raw
List pgsql-hackers
Sometimes, I have to add column to table, then adding the column to some view.

Currently it impossible to alter a view to add a new column, which is really
annoying. The only solution is to drop the view, and all dependented view,
then recreating everything.

Someone on #postgresqlfr said me there were discussion about that.

I think this would be a big improvement for pg 8.4.

My 2 cents.

Regards.

pgsql-hackers by date:

Previous
From: Zdenek Kotala
Date:
Subject: Re: Why we panic in pglz_decompress
Next
From: Justin
Date:
Subject: creating new aggregate function