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:gryz...@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 <t...@sss.pgh.pa.us> wrote: > Ravi Katkar <ravi.kat...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
