Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] How to add columns to view with dependencies - Mailing list pgsql-general

From Guyren Howe
Subject [GENERAL] How to add columns to view with dependencies
Date
Msg-id AEE30266-CB88-44D7-9CED-812B24BB3979@gmail.com
Whole thread Raw
Responses Re: [GENERAL] How to add columns to view with dependencies  (Justin Pryzby <pryzby@telsasoft.com>)
Re: [GENERAL] How to add columns to view with dependencies  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [GENERAL] How to add columns to view with dependencies  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List pgsql-general
Tree view
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?

pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] Clone PostgreSQL schema
Next
From: Justin Pryzby
Date:
Subject: Re: [GENERAL] How to add columns to view with dependencies