ERROR: syntax error at or near

[Anonymous]

Démarrage du job loading_dimension a 12:13 23/04/2018.
[statistics] connecting to socket on port 3613
[statistics] connected
ERROR: syntax error at or near "dim_temps"ERROR: syntax error at or near "dim_localisation"ERROR: syntax error at or near "dim_age"ERROR: syntax error at or near "dim_sexe"ERROR: syntax error at or near "dim_soldeEmoney"ERROR: syntax error at or near "dim_achatIshop"ERROR: syntax error at or near "dim_education"ERROR: syntax error at or near "dim_operateurTelecom"ERROR: syntax error at or near "dim_specialite"ERROR: syntax error at or near "dim_campagne"ERROR: syntax error at or near "dim_facebook"ERROR: syntax error at or near "dim_twitter"ERROR: syntax error at or near "dim_linkedin"ERROR: syntax error at or near "dim_whatsapps"
[statistics] disconnected
Job loading_dimension terminé à 12:13 23/04/2018. [Code sortie=0]

[TRF]

This is a PostgreSQL runtime error.

Share your tPostgesqlOutput component's settings.

[TRF]

What's in your tPostgesqlOutput schema?

It's definied as based on a generic schema from the repository but the corresponding schema is not selected.

Else, can you make some sentences to explain what you have tried?

(if you prefer you can do it in french)

[Anonymous]

Disons que mes données proviennent d'un annuaire LDAP deja connecter et tout.

Je  dois creer un entrepot de donnée sous PostgreSQL choix bien pensé.

J'avais deja cree un entrepot avec Mysql mais ca marcher facilement mais avec postgres c'est comme si il ne reconnaissait pas les tables de dimensions.

Meme apres creation des tables dimensions si j'essai de charger les tables de faits il ne reconnait pas les tables de dimensions.

Je suis nouveau su talend.

[Anonymous]

Hello,

This is an international forum and English is the language we use. Posting in English will allow you to get more visibility and more help. Thanks for your understanding!

Best regards

Sabrina

[TRF]

@bigathepa did you defined the default schema for the query?