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

Re: problem with pg_dump

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: problem with pg_dump
Date: 2012-07-31 13:15:31
Message-ID: jv8lpn$kaq$1@dough.gmane.org (view raw or flat)
Thread:
Lists: pgsql-novice
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.

Thomas



In response to

pgsql-novice by date

Next:From: Adam MacklerDate: 2012-07-31 13:49:27
Subject: Learning SQL: nested CTE and UNION
Previous:From: Jonatan ReinersDate: 2012-07-31 12:55:05
Subject: Re: problem with pg_dump

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