Re: drop view with out cascading the dependents - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: drop view with out cascading the dependents
Date
Msg-id AANLkTin_AqDB=L3rpQatNqS=7o6dPVMmehw-HeDXKNGr@mail.gmail.com
Whole thread Raw
In response to Re: drop view with out cascading the dependents  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: drop view with out cascading the dependents  (Ravi Katkar <Ravi.Katkar@infor.com>)
Re: drop view with out cascading the dependents  (Merlin Moncure <mmoncure@gmail.com>)
List pgsql-general
On Tue, Oct 19, 2010 at 3:12 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Ravi Katkar <Ravi.Katkar@infor.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?
>
only caveat is, it won't work if he adds/removes any columns. CREATE
OR REPLACE VIEW is rather useless in most practical implementations.



--
GJ

pgsql-general by date:

Previous
From: Mauricio Chamati
Date:
Subject: Database INNOVATION
Next
From: Ravi Katkar
Date:
Subject: Re: drop view with out cascading the dependents