Postgres Pro
Downloads
Home   >   mailing lists

alter table alter type CASCADE - Mailing list pgsql-general

From Sim Zacks
Subject alter table alter type CASCADE
Date
Msg-id 4BE132C4.3000003@compulab.co.il
Whole thread Raw
Responses Re: alter table alter type CASCADE  (Thom Brown <thombrown@gmail.com>)
Re: alter table alter type CASCADE  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
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.

Is there any intention of adding a CASCADE to alter type which would
automatically update any dependencies with the new datatype? Obviously
it should error out if it wouldn't have let you save one of the views
with the new datatype.

Thanks
Sim

pgsql-general by date:

Previous
From: Andre Lopes
Date:
Subject: Re: Function not RAISE NOTICE if a parameter is NULL
Next
From: Thom Brown
Date:
Subject: Re: alter table alter type CASCADE