[apa64]

I got an error about invalid data type while trying to update a row in the Database Explorer’s Edit data view. The column type is bigint but it seems that the DB Explorer is trying to update it with varchar value even though I input a number.

The database is PostGreSQL 8.0, my driver is postgresql-8.1-407.jdbc3.jar and the error message was:
“Error updating: ERROR: column “fk_…” is of type bigint but expression is of type character varying”

[apa64]

…and the Eclipse version is 3.2.1 and the MyEclipse version is 5.1.0 GA.

[Haris Peco]

apa64,

Could you send ddl for table (right click and call Generate>DDL) and what you type to this column

Thanks,

[Author]

Posts