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@gmail.com]
Sent: Tuesday, October 19, 2010 7:50 PM
To: Tom Lane
Cc: Ravi Katkar; pgsql-general@postgresql.org
Subject: Re: [GENERAL] drop view with out cascading the dependents
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