Re: drop view with out cascading the dependents

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Ravi Katkar <Ravi(dot)Katkar(at)infor(dot)com>, "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:19:38
Message-ID: AANLkTin_AqDB=L3rpQatNqS=7o6dPVMmehw-HeDXKNGr@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Oct 19, 2010 at 3:12 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> 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?
>
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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Katkar 2010-10-19 14:47:13 Re: drop view with out cascading the dependents
Previous Message Mauricio Chamati 2010-10-19 14:12:58 Database INNOVATION