Forum Discussion

cesar_bolanos's avatar
cesar_bolanos
New Contributor
6 years ago

Insert error with JDBC insert and PGSQL

I have a pipeline that reads from Oracle and writes to PGSQL. When inserting to PGSQL, I get this error Batch entry 0 insert into “pg_temp”.“crmi002b_ut_pprs001” (“end_date”, “opportunity_type”, “s...
pipeline
jaybodra's avatar
jaybodra
New Contributor III
6 years ago

@cesar.bolanos did you try defining TIMESTAMP without time zone?

  • cesar_bolanos's avatar
    cesar_bolanos
    New Contributor
    6 years ago

    This also happens with int fields