Hi, According to the docs merge() "implements the semantics of an INSERT … ON DUPLICATE KEY UPDATE statement, which will update the row regardless of which (unique) key value is already present".
This doesn't seem to be the case. I have a unique key comprising of 2 fields and I'm getting an exception instead of the merge following through. This is with PostgreSQL: "Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "some_unique_key" Detail: Key (field1, field2)=(value1, value2) already exists." Shouldn't record.merge() insert the missing record or update it if it already exists? Thanks! -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/92eca557-7835-49a7-98d4-58e8a11784b6n%40googlegroups.com.
