Postgres - No results were returned by the query

Nine Stars

Postgres - No results were returned by the query

I haven't done much with Talend and Postgresql in the past, so I need some help.
My job:
tPostgresqlConnection > tPostgresqlInput1 > tFileInputDelimited > tmap > tPostgresqlOutput
I am trying to:
1. DELETE ALL ROWS IN THE TABLE TO BE LOADED
2. INSERT ALL RECORDS FROM A FILE
ERROR:
Exception in component tPostgresqlInput
org.postgresql.util.PSQLException: No results were returned by the query.
My SQL works fine out side of Talend to delete the data in the table.
DELETE FROM myTable
Community Manager

Re: Postgres - No results were returned by the query

Hi
To execute a delete statement, you should use tpostgresqlRow component, tPostgresqlInput is used to select data from table. 
----------------------------------------------------------
Talend | Data Agility for Modern Business
Seventeen Stars

Re: Postgres - No results were returned by the query

OK, no to delete records I suggest tPostgresqlOutput with table action Delete.
The key for delete the records are the schema column marked as key. No other columns are necessary.
Because you cannot select the records and delete them at the same time I suggest you select the records to delete and export them in a file and after that you read the file and delete them.
tPostgresqlInput -> tFileOutputDelimited
tFileInputDelimited -> tMap -> tPostgresqlOutput
Nine Stars

Re: Postgres - No results were returned by the query

Can I please get a screenshot of how you have your tPostgresqlOutput setup?
I am unable to get my tPostgresqlOutput to delete when I try table action Default & Delete, Truncate Table & Delete, Clear Table & Delete
The tpostgresqlRow successfully does the delete.