Re: drop view with out cascading the dependents

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ravi Katkar <Ravi(dot)Katkar(at)infor(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: drop view with out cascading the dependents
Date: 2010-10-19 14:12:13
Message-ID: 9707.1287497533@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ravi Katkar <Ravi(dot)Katkar(at)infor(dot)com> writes:
> Is there any feature to drop the view with out cascading the dependents.

No. But why don't you use CREATE OR REPLACE VIEW?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mauricio Chamati 2010-10-19 14:12:58 Database INNOVATION
Previous Message David Fetter 2010-10-19 14:03:19 Re: Problem with initdb: creates database which do not exists