topic Re: FatalPostgresql ELT problem with update in Talend Studio

FatalPostgresql ELT problem with update

billimmer — Fri, 28 Oct 2016 16:35:32 GMT

Hi Group,
Using 6.2.1 postgresql ELT input ----> map ----> output, there seems to be an issue I cannot work around (without resorting to the postgresqlrow component.
For the update to work I need to assign an alias in the elt output. I check the "Use different table name" box and add: "mytable myalias".
When I run the job I get: UPDATE "myschema"."mytable myalias"
Note the quotes added around "mytable myalias", which produces a syntax error in postgresql
The result should be: UPDATE "myschema"."mytable" "myalias"
Does anyone know of a workaround for this?
Thanks!

Re: FatalPostgresql ELT problem with update

cterenzi — Fri, 28 Oct 2016 18:55:38 GMT

You might try something like "mytable\" \"myalias"

Re: FatalPostgresql ELT problem with update

billimmer — Fri, 28 Oct 2016 20:12:56 GMT

Thanks for the reply. I did try that and you get UPDATE "myschema".""mytable" "myalias"" which doesn't work.