Can you set "log_statement" in postgresql.conf and post the logged statements?
-- With regards, William ZHANG ----- Original Message ----- From: ""Heinz-Peter Heidinger"" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
