Re: alter table alter type CASCADE

2010/5/5 Sim Zacks <sim(at)compulab(dot)co(dot)il>:
> One of the biggest problems I have maintaining a database with a lot of
> views is that when I want to change a datatype, I have to drop every
> view uses the column and every view that uses those views etc...
> This turns into a maintenance nightmare.

Then I would question your approach to maintenance. In the past when
I've had to deal with this type of thing, all views were created from
a script. Edit the script, run the script, you're done. Do it in a
transaction and if there are any errors nothing changes. Script looks
something like:

begin;
drop view x1;
drop view y1;
... more drop statements
create view x1...
create view y1 ...
commit;