Re: [SQL] Adding a column to a VIEW which has dependent objects.

2004-01-12 Thread scott.marlowe
On Sat, 10 Jan 2004, Tom Lane wrote: > Rajesh Kumar Mallah <[EMAIL PROTECTED]> 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, yo

Re: [SQL] Adding a column to a VIEW which has dependent objects.

2004-01-10 Thread Tom Lane
Rajesh Kumar Mallah <[EMAIL PROTECTED]> 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

[SQL] Adding a column to a VIEW which has dependent objects.

2004-01-10 Thread Rajesh Kumar Mallah
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 o