Unanswered: Mule, Postgres and Auto Generated Keys
I am using Mule and Postgres and I have a trivial task to insert two rows in two related tables. The primary key of the first table is a foreign key in the second one.
So to insert the second row I need to get autogenerated key and put it into the second one.
The problem is that Mule returns error:
Root Exception stack trace:
org.postgresql.util.PSQLException: Returning autogenerated keys is not supported.
It seems that the problem related to the Postgres database engine and there is no way to use RETURNING id or currval() in Mule.
Is there another way to make it working? (UUID is not an option)
PS. Environment: Mule CE 3.6 and Mule Anypoint Studio. Postgres 9.2 (JDBC driver 41)