Jonatan Reiners, 31.07.2012 14:55:
> Both are set to lc_monetary = 'de_DE.UTF-8'
> Maybe they mean something different on both OSs or one installation is faulty and ignores this setting.
Hmm, that's strange (actually "Eu67.667,00" looks very strange anyway. It should be EUR or € but not Eu)
> I think I will go the way and convert the value to numeric.
> unfortunately this doesn't work
> alter table bst alter summe set data type numeric(30,2) using summe::numeric;
> Looks nice but:
> ERROR: cannot alter type of a column used by a view or rule
> DETAIL: rule _RETURN on view xb_buchversand_positionen depends on column "summe"
> Is there a nice way for the stupid me to cascade the alteration?
Unfortunately not. You need to drop (and re-create) every view that uses that table.
In response to
pgsql-novice by date
|Next:||From: Adam Mackler||Date: 2012-07-31 13:49:27|
|Subject: Learning SQL: nested CTE and UNION|
|Previous:||From: Jonatan Reiners||Date: 2012-07-31 12:55:05|
|Subject: Re: problem with pg_dump|