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

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: (view raw, whole thread or download thread mbox)
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 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:

In response to


pgsql-novice by date

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

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