Date: Mon, 12 Jan 2004 09:34:33 -0700 (MST)
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Rajesh Kumar Mallah <mallah@trade-india.com>,
	<pgsql-sql@postgresql.org>
Subject: Re: Adding a column to a VIEW which has dependent objects. 
In-Reply-To: <9810.1073753325@sss.pgh.pa.us>
Message-ID: <Pine.LNX.4.33.0401120934150.19667-100000@css120.ihs.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII

On Sat, 10 Jan 2004, Tom Lane wrote:

> Rajesh Kumar Mallah <mallah@trade-india.com> writes:
> > How do people extend a parent view which has
> > lot of dependent views?
> > The parent view cannot be dropped because that will
> > require recreating a dozen of dependent views.
> 
> You're out of luck, you'll have to drop and remake them all.
> In future we could think about some kind of ALTER VIEW ADD COLUMN
> operation, but it ain't there now.
> 
> (I suppose if you were really desperate you could think about manually
> hacking the system catalogs, but this would be pretty risky on a
> production database.)
> 
> > Also is there an easy way of dumping the definitions
> > of all the dependent views of a given object.
> 
> You can chase the links in pg_depend to see what the dependent objects
> are, but extracting their definitions would be a tad harder ...

Note that the definitions for views are stored in pg_views as well.