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
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
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.