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.
signature.asc
Description: This is a digitally signed message part.