drop view with out cascading the dependents

From: Ravi Katkar <Ravi(dot)Katkar(at)infor(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: drop view with out cascading the dependents
Date: 2010-10-19 05:43:32
Message-ID: 46AC8D44F3AE1F4888F137837D0DF63508871E63CB@INHYWEXMB2.infor.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi List,

Is there any feature to drop the view with out cascading the dependents.

Below is my requirement.

I have a view which is dependent on the other view/table. I wanted to drop the view dynamically and recreate the view with same name ( definition of view will differ ) with out cascading its dependents, after that I created the view it should have its dependents as to that of older one.

Thanks in advance.

Thanks,
Ravi Katkar

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Torsten Zühlsdorff 2010-10-19 06:48:13 Re: Problem with initdb: creates database which do not exists
Previous Message Greg Smith 2010-10-19 05:26:00 Re: select count(*) status these days