This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
When utilizing the new PostgreSQL bulk loader to write to the database you get the follow error:
PostgreSQL Bulk loader failed to enter copy state. ERROR: syntax error at or near "(¶LINE 1: ...eagp_assembly_analytics.testbulkloader from STDIN (DELIMETER...¶
This is a Postgres version issue. Postgres changed the syntax for the COPY command slightly and they added parameters.
The command we run uses the the ENCODING parameter which wasn't added until version 9.1 of Postgres.
Release Notes 9.1
Upgrade to Postgres version 9.4 or higher. Alteryx Help PostgreSQLValidated On: Database Version 9.4ODBC Client Version 09.06.0310ODBC Client Version 11.7