Adding a column to a VIEW which has dependent objects. - Mailing list pgsql-sql

From Rajesh Kumar Mallah
Subject Adding a column to a VIEW which has dependent objects.
Date
Msg-id 3FFFAFCE.50005@trade-india.com
Whole thread Raw
Responses Re: Adding a column to a VIEW which has dependent objects.
List pgsql-sql
Dear PostgreSQL gurus,


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.

Is there any workaround.

Also is there an easy way of dumping the definitions
of all the dependent views of a given object. Does information_schema
helps here.


Regds
mallah.




pgsql-sql by date:

Previous
From: "Kumar"
Date:
Subject: Re: how to show table structure?
Next
From: Tom Lane
Date:
Subject: Re: Adding a column to a VIEW which has dependent objects.