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.
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?
Kind regards,
Jonatan
--
Jonatan Reiners
Am Dienstag, 31. Juli 2012 um 14:13 schrieb Thomas Kellerer:
Sounds like you have different setting for for lc_monetary on the target than on the source.
Make sure both are set to the same value (in postgresql.conf)
That's one of the reasons I don't like the money datatype.
I prefer to store that in a regular numeric column and have the currency in another one
Thomas
--
To make changes to your subscription: