2010/10/19 Grzegorz Jaśkiewicz <gryz...@gmail.com>: > 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.
In recent versions of postgres (I think 8.4+?) you can add columns to the view via create/replace (not drop of course). This greatly reduces the practical annoyances of dropping view dependencies, at least for me... merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
