Thread: update table data type
Hi support community,
I have a tedious task with changing the data type of a single row from a postgresql 9.1.4 database.
command:
alter table bst alter summe set data type numeric(30,2) using summe::numeric;
result:
rule _RETURN on view bills_short depends on column "summe"
unfortunately more that 10 views depend on that table and i have 4 more tables to change.
Is there a convenient way to handle an issue like that?
Am I the only one with a problem like that? Its insane to recreate up to 40 views in order to change 4 columns.
Kinde regards,
Jonatan
--
Jonatan Reiners
On Wed, Aug 1, 2012 at 8:59 AM, Jonatan Reiners <jreiners@encc.de> wrote: > Hi support community, > I have a tedious task with changing the data type of a single row from a > postgresql 9.1.4 database. > command: > alter table bst alter summe set data type numeric(30,2) using > summe::numeric; > > result: > rule _RETURN on view bills_short depends on column "summe" > > unfortunately more that 10 views depend on that table and i have 4 more > tables to change. > Is there a convenient way to handle an issue like that? > > Am I the only one with a problem like that? Its insane to recreate up to 40 > views in order to change 4 columns. Unfortunately that is the case. Typically it's a good idea if you use a lot of views to organize the creation of them into scripts so you can just re-apply them. merlin