Re: [GENERAL] How to add columns to view with dependencies

2017-04-17 Thread Karsten Hilbert
On Sun, Apr 16, 2017 at 08:02:54PM -0700, Guyren Howe wrote: > 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. This

Re: [GENERAL] How to add columns to view with dependencies

2017-04-16 Thread Tom Lane
Guyren Howe writes: > 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 m

Re: [GENERAL] How to add columns to view with dependencies

2017-04-16 Thread Justin Pryzby
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

[GENERAL] How to add columns to view with dependencies

2017-04-16 Thread Guyren Howe
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