Re: problem with pg_dump

From: Jonatan Reiners <jreiners(at)encc(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: problem with pg_dump
Date: 2012-07-31 12:55:05
Message-ID: D175095040B74CC080A0F28038FF397F@encc.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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
>
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thomas Kellerer 2012-07-31 13:15:31 Re: problem with pg_dump
Previous Message Thomas Kellerer 2012-07-31 12:13:17 Re: problem with pg_dump