join datasets failure

laura

Joining datasets is failing with an error log to say 'Copy thread failed'. My datasets are in postgres and I can see the joined table schema created there (but no data). I tried both visual SQL join and a python join. Both cases are throwing the error below. Does anyone have any suggestions? Thanks.

org.postgresql.util.PSQLException: ERROR: unterminated quoted string at or near "'\'"
Position: 60
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processCopyResults(QueryExecutorImpl.java:964)
at org.postgresql.core.v3.QueryExecutorImpl.startCopy(QueryExecutorImpl.java:726)
at org.postgresql.copy.CopyManager.copyIn(CopyManager.java:54)
at org.postgresql.copy.CopyManager.copyIn(CopyManager.java:178)
at org.postgresql.copy.CopyManager.copyIn(CopyManager.java:163)

Clément_Stenac

Hi Laura,

Is this PostgreSQL 8.X ? DSS only supports PostgreSQL 9.X

Regards,

laura

Hi Clément,

It's postgres 9.3.10

Regards,
Laura