alter table alter type CASCADE

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: alter table alter type CASCADE
Date: 2010-05-05 08:56:36
Message-ID: 4BE132C4.3000003@compulab.co.il
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2010-05-05 09:12:34 Re: alter table alter type CASCADE
Previous Message Andre Lopes 2010-05-05 08:09:08 Re: Function not RAISE NOTICE if a parameter is NULL