Bug while loading the data into a table in grisql

This message was edited 1 time. Last update was at 12 Jul 2010 02:03:55

Hi

I am using the

Operating system Centos
postgres version is PostgreSQL 8.3.3
grid version is 1.0.0.6

While loading the data into the table using the copy command then I am getting the error as shown below.

GridSQL -> copy employee_details from '/home/postgres/emp.csv' delimiter ',' CSV;
SQLException: ERROR: java.lang.NumberFormatException: For input string: "newyork"

If I drop the XROWID column then the data is loaded

WHY…………………………………………..
Please reply……………………………………..

This appears to be a duplicate of this post: http://forums.enterprisedb.com/posts/list/2360.page, so I will lock this thread.