From: | "Reuben Cummings" <reubano(at)gmail(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | neooffice form problem with numerics |
Date: | 2008-11-22 19:57:44 |
Message-ID: | 68bad9530811221157h287201d0jb43ad5e7539fd0f3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi, I am trying to use a neooffice form to insert numerical values
into a postgres database and get the following error:
ESTERROR: 42804: column "back_load" is of type numeric but expression
is of type character varying at character 35
ESTHINT: You will need to rewrite or cast the expression.
ESTLOCATION: transformAssignedExpr,
/Users/Shared/src/postgresql/postgresql-8.3.1/build-leo/src/../../src/backend/parser/parse_target.c:440
ESTSTATEMENT: INSERT INTO "public"."security" ( "back_load",
"company_id", "expense_ratio", "front_load", "is_benchmark",
"proxy_id", "security_name", "security_type_id", "ticker", "turnover"
) VALUES ( $1, $2, $3, $4, $5, $6, $7, $8, $9, $10 )
I am using PostgreSQL 8.3.1 on Mac OS X 10.5.5 and have tried the
following drivers:
pg74.216.jdbc3
postgresql-8.3-603.jdbc3
postgresql-8.4dev-700.jdbc3
This also happens no matter what kind of form field I use, formatted
or numerical.
Any advice? Thanks!
Reuben Cummings
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2008-11-23 01:21:48 | Re: neooffice form problem with numerics |
Previous Message | David Wall | 2008-11-18 00:29:45 | Streaming Blobs in PG 8.3 |