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