Skip site navigation (1) Skip section navigation (2)

update table data type

From: Jonatan Reiners <jreiners(at)encc(dot)de>
To: pgsql-novice(at)postgresql(dot)org <pgsql-novice(at)postgresql(dot)org>
Subject: update table data type
Date: 2012-08-01 13:59:56
Message-ID: 1A6B1FD37F7B4C009F4CD04A26C26307@encc.de (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Merlin MoncureDate: 2012-08-01 16:00:07
Subject: Re: update table data type
Previous:From: George McIlwaineDate: 2012-07-31 21:41:06
Subject: Re: postgres domain service account won't start the postgres service

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group