Problem with tPostgresqlOutput

[_AnonymousUser]

Hello.
I'm actually using Talend to compare this product with CloverETL.
In this goal, I'm doing some tests with component tPostgresqlOutput but I always receive this message while inserting in PostgreSQL :
Exception in component tPostgresqlOutput_1
org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at or near """"
...
However, if I return data into flat file there is no problem...
PS : My connection is well configured.

Can somebody help me?
Olivier

[_AnonymousUser]

Did you enter a table name in tPostgresqlOutput properties ?

Yes fortunately but thank you for your help.

are you located france, bordeaux ?

yes

Well, I think too this is a problem with Postgres version...

Best regards
Olivier

[Anonymous]

When I print SQL requests, I get (with empty strings for prenom and / or nom) :

INSERT INTO "test"."output1" ("id","prenom","nom") VALUES (1,titi,toto)
INSERT INTO "test"."output1" ("id","prenom","nom") VALUES (2,NULL,NULL)
INSERT INTO "test"."output1" ("id","prenom","nom") VALUES (3,titi,NULL)

I only see 2 ways to get this error : either schema or table property is not filled (requests would look like INSERT INTO ""."output1" ... or INSERT INTO "test"."" ...).

[_AnonymousUser]

I only see 2 ways to get this error : either schema or table property is not filled (requests would look like INSERT INTO ""."output1" ... or INSERT INTO "test"."" ...).

Yes I know but values are not null and shemas are correctly filled because when I put a tFileOutputDelimited instead of a tPostgresqlOutput, I don't have this error any longer and my file contains the good values. This is why I think this is a problem with version/configuration of Postgres.
Here is the contents of my table (no error possible with values )




Best regards
Olivier

[_AnonymousUser]

Hello,
I finally found the problem.
In fact, in a database connection edition, a schema have to be indicated.
In a postgres database, every table is created in a default schema "public".
It was this default schema that was missing in my configuration.
Thanks for your help.

[Anonymous]

[_AnonymousUser]

I am still getting the same error, inspite of specifying the schema and everything.. can anyone help.

[_AnonymousUser]

Hi 
Here I am having a situation.
I am having a talend job :
 tpostgresqlInput -> tmap -> tpostgresqloutput
in tpostgresqlinput : select id,name from employee;
tpostgresql output : it is employee_staging table with the below information
id,name,created_time,updated_time
created_time i am always keeping as the current time in the tmap.
Now the requirement is whenever there is a update then only i need to stamp the updated_time.
tpostgresqloutput:
action on table : insert or update
So how can i differentiate between insert and update and stamp the updated_time to current time whenever there is a update.