Re: alter table alter type CASCADE
| От | Chris Barnes |
|---|---|
| Тема | Re: alter table alter type CASCADE |
| Дата | |
| Msg-id | BLU149-W27BF8183582DCB6E39B18AD4F40@phx.gbl обсуждение исходный текст |
| Ответ на | Re: alter table alter type CASCADE (Thom Brown <thombrown@gmail.com>) |
| Ответы |
Re: alter table alter type CASCADE
|
| Список | pgsql-general |
It has been some years since I worked with Oracle, doesn't Oracle recompile the view when the object it references changes in structure?
Send
From: thombrown@gmail.com
Date: Wed, 5 May 2010 10:12:34 +0100
Subject: Re: [GENERAL] alter table alter type CASCADE
To: sim@compulab.co.il
CC: pgsql-general@postgresql.org
2010/5/5 Sim Zacks <sim@compulab.co.il>
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
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
Win a $10,000 shopping spree from Hotmail! Enter now Enter now
В списке pgsql-general по дате отправления: