CSV data load has some problem to insert data into postgres database

Description

step1:

CREATE TABLE jcp_event
(
jcp_event_id bigint NOT NULL,
event_name character varying(200) NOT NULL,
event_type character varying(20),
event_desc character varying(200),
event_status character varying(3),
event_display_name character varying(50),
parent_event_id bigint,
last_archival_date date,
creation_date date NOT NULL,
created_by bigint NOT NULL,
update_date date NOT NULL,
updated_by bigint NOT NULL,
CONSTRAINT jcp_event_pk PRIMARY KEY (jcp_event_id)
)

step2:

am trying to insert data using csv file ,but in the above table "parent_event_id" is nullable column so that i did't put any value for this but while executing this below changeset it is throwing below exception

Changeset:

<changeSet id="716" author="jaws">
<comment>Inserting JCP_EVENT seed data . . .</comment>
<loadData tableName="JCP_EVENT" file="liquibasedb/Seeddata_Updation/JCP_EVENT_LOGINMODULE.csv"/>
</changeSet>

Exception:
invalid input syntax for integer: ""

please find the attachement
Is there a way to short out this problem ,this is happening only for postgresql ,same thing working fine for oracle.

Environment

windows,linux

Activity

Show:

Nathan Voxland December 12, 2013 at 4:04 PM

Working for me with 3.0.8 snapshot. I think this was fixed with an earlier issue, but I cannot tell for sure because you didn't add the attachment

Cannot Reproduce

Details

Reporter

Affects versions

Priority

Created June 27, 2013 at 7:16 AM
Updated December 12, 2013 at 4:04 PM
Resolved December 12, 2013 at 4:04 PM