You are not logged in.
I want to insert rows in an PostgreSQL database having rejected row to be log in a special file.
I'm using a tPostgresqlOutput with "commit every" 10000, "Die on error" false.
When an error occurs on "insert", all the following rows are rejected with the following message "current transaction is aborted, commands ignored until end of transaction block"
While using tOracleOutput I don't get this kind of error.
I can counter this by setting "commit every" to 1, but is there any other way to save "commit" and go through first SQL error?
--My config :
PosgreSQL Database Server 8.2