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@comserve-it-services.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@comserve-it-services.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.