Re: problem with pg_dump

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
>
>
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org (mailto:pgsql-novice(at)postgresql(dot)org))
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>