Re: drop view with out cascading the dependents

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, 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-20 15:02:12
Message-ID: AANLkTin72BEXH8PHn2KUY9Y9hN3bbUzqngXvhwapCPHU@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/10/20 Merlin Moncure <mmoncure(at)gmail(dot)com>:
> 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...
Ok, We're still on 8.3 here, and management reluctant to upgrade.
(which makes some sense).

--
GJ

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-10-20 15:21:57 Re: recovery from out of disk space
Previous Message Viktor Bojović 2010-10-20 14:59:25 Re: truncating or full vacuuming