Sorry, this was my mistake. I forgot to put the Parameter "NULL_AS" in the Advanced Settings tab of tGreenPlumGPLoad.
Worked well after that.
I am getting the same error when exporting from a mysqlinput component to a postgresqloutput component. The connection setting ahs the string delemiter set to ' (single quote). Any suggestions where to look. Swapping out the postgresqloutput component for a text file works fine.
Hey Did you found anything here, i am facing similar issue where the insert being sent without the quotes for strings and because of that Insert fails!
My table I'm trying to insert into is empty. There are no constraints on the table, not even primary key. When I attempt to insert the reformatted sql statement it goes in fine when connecting to the database correctly. How do I make Talend format the insert statement so that it will be accept by Postgresql?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables