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

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.