Re: drop view with out cascading the dependents

That's true . it wont work if we add remove the columns.
I wanted to add column to view and change the data type to existing column

-----Original Message-----
From: Grzegorz Jaśkiewicz [mailto:gryzman(at)gmail(dot)com]
Sent: Tuesday, October 19, 2010 7:50 PM
To: Tom Lane
Cc: Ravi Katkar; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] drop view with out cascading the dependents

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