Adding a column to a VIEW which has dependent objects.

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Adding a column to a VIEW which has dependent objects.
Date: 2004-01-10 07:54:54
Message-ID: 3FFFAFCE.50005@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-01-10 16:48:45 Re: Adding a column to a VIEW which has dependent objects.
Previous Message Kumar 2004-01-10 04:03:51 Re: how to show table structure?