Hi support community,
I have a tedious task with changing the data type of a single row from a postgresql 9.1.4 database.
alter table bst alter summe set data type numeric(30,2) using summe::numeric;
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.
pgsql-novice by date
|Next:||From: Merlin Moncure||Date: 2012-08-01 16:00:07|
|Subject: Re: update table data type|
|Previous:||From: George McIlwaine||Date: 2012-07-31 21:41:06|
|Subject: Re: postgres domain service account won't start the postgres service|