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

Re: BUG #2496: Troubles with fixed-point types (NUMERIC, DECIMAL,...)

From: "William ZHANG" <uniware(at)zedware(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2496: Troubles with fixed-point types (NUMERIC, DECIMAL,...)
Date: 2006-06-27 15:01:23
Message-ID: e7rjgb$2dug$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Can you set "log_statement" in postgresql.conf and post the logged
statements?

--
With regards,
William ZHANG

----- Original Message ----- 
From: ""Heinz-Peter Heidinger"" <hph(at)comserve-it-services(dot)de>
Newsgroups: pgsql.bugs
Sent: Saturday, June 24, 2006 3:44 PM
Subject: BUG #2496: Troubles with fixed-point types (NUMERIC, DECIMAL,...)


>
> The following bug has been logged online:
>
> Bug reference:      2496
> Logged by:          Heinz-Peter Heidinger
> Email address:      hph(at)comserve-it-services(dot)de
> PostgreSQL version: 8.x
> Operating system:   all (Linux & Win was tested)
> Description:        Troubles with fixed-point types (NUMERIC, DECIMAL,...)
> Details:
>
> OpenOffice 1.x/2.x & StarOffice7/..8 cannot write fixed-point values
> (NUMERIC|DECIMAL) to a PGSQL database when using a JDBC interface and a
> desktop locale of 'german' (maybe others as well) is used.
>
>
> The resulting message is:
>
>    ERROR: column <XXX> has type numeric but
>    expression has type character varying. 



In response to

pgsql-bugs by date

Next:From: marcin.mankDate: 2006-06-27 18:24:34
Subject: BUG #2500: subscribing for digest
Previous:From: Dave PageDate: 2006-06-27 14:29:41
Subject: Re: BUG #2499: Error Message pgAdmin III

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