i used bulk insert connector to insert below array to table on postGreSQL,
[{“keyvalue”:"001"},{“keyvalue”:"002"},{“keyvalue”:"003"}]
The "keyvalue" is unique key on the table. if the array have 3 items, one item is exists in the table, then the other items would be bulk inserted to table, only one item failed due to unique key error. then I can use "error.exception.cause.updateCounts" to get items which be successfully inserted.
but i found the flow can work on MSSQL, but can't work on postGreSQL.
That mean, when I bulk insert three items to MSSQL, only duplicated keyvalue can't be inserted,
but when I bulk insert same items to posGreSQL, all keyvalue can't be insert only if there has one duplicated key.
HI Manish
Here is log when i was using insert into ... on conflict do nothing returning .....。
by the way. i reviewed an article about insert on postgresql or oracle. How to set up the DB connector to process INSERT .. RETURNING (INTO) clause | MuleSoft Help Center
but the article is for insert connector , but not for bulk insert connector.
Thanks
