Postgres Pro
Downloads
Home   >   mailing lists

Re: alter table alter type CASCADE - Mailing list pgsql-general

From Thom Brown
Subject Re: alter table alter type CASCADE
Date
Msg-id u2kbddc86151005050212r72c375b3x2d83ad4b219f75da@mail.gmail.com
Whole thread Raw
In response to alter table alter type CASCADE  (Sim Zacks <sim@compulab.co.il>)
Responses Re: alter table alter type CASCADE  (Chris Barnes <compuguruchrisbarnes@hotmail.com>)
List pgsql-general
Tree view
2010/5/5 Sim Zacks <sim@compulab.co.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.

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

--

Yes, there is an intention of adding such functionality (3rd item) but probably not very straightforward: http://wiki.postgresql.org/wiki/Todo#Views_.2F_Rules

Regards

Thom

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: alter table alter type CASCADE
Next
From: Cédric Villemain
Date:
Subject: Re: (psuedo) random serial for PK or at least UNIQUE NOT NULL?