drop view with out cascading the dependents - Mailing list pgsql-general

From Ravi Katkar
Subject drop view with out cascading the dependents
Date
Msg-id 46AC8D44F3AE1F4888F137837D0DF63508871E63CB@INHYWEXMB2.infor.com
Whole thread Raw
Responses Re: drop view with out cascading the dependents  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: select count(*) status these days
Next
From: Torsten Zühlsdorff
Date:
Subject: Re: Problem with initdb: creates database which do not exists