Hello, The way to read the sources is as follows: PostgreSQL 9.5 introduced the ON CONFLICT clause, which offers a much better way to emulate ON DUPLICATE KEY IGNORE than the "standard" / default way to do it (go further down in the switch case statements, and you'll see what is going to be done for PostgreSQL 9.3).
In any case, the error message you're getting should be helpful here. jOOQ simply cannot emulate the clause in your case. I mean, in the absence of knowing about any keys (hence "non-updatable tables"), what should jOOQ do? If you think this is a bug, I invite you to provide a more complete example of what you're doing. Thanks, Lukas 2018-05-24 8:36 GMT+02:00 <[email protected]>: > Getting the above exception while inserting the records in a table. > > I am using the Jooq 3.10.7 and Postgres 9.4 and I didn't see the > Postgres_9.4 specific onDuplicateKeyIgnore handling cases in the attached > screenshot. > > Does jooq support Postgres 9.4? > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
