On Sun, Apr 16, 2017 at 08:02:54PM -0700, Guyren Howe wrote: > Seems like a simple question, but I’ve never found a good answer to this and > similar issues. > > I would think it was safe to let me add columns to a view on which other > views depend, but Postgres won’t let me. > > I can imagine ways of sort-of dealing with this. I might maintain a SQL file > with views to create in a suitable order, Then I could drop all views, edit > the definition of one, then run the file, but this is awfully tedious. > > What is best practice in this situation?
If you're not re-ordering existing columns, you can use CREATE OR REPLACE VIEW Justin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
