I'm getting this error trying to execute a query that does ON CONFLICT DO UPDATE:
org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "INSERT INTO tasks (assignee_id, item_key, title, status, due_date, updated_at, state, company_id) VALUES (?,?,?,?,?,?,?,?) [*]ON CONFLICT (assignee_id, item_key, status) DO UPDATE SET assignee_id = excluded.assignee_id, title = excluded.title, status = excluded.status, item_key = excluded.item_key, status = excluded.status, due_date = excluded.due_date, updated_at = excluded.updated_at, state = excluded.state, company = excluded.company"; SQL statement: INSERT INTO tasks (assignee_id, item_key, title, status, due_date, updated_at, state, company_id) VALUES (?,?,?,?,?,?,?,?) ON CONFLICT (assignee_id, item_key, status) DO UPDATE SET assignee_id = excluded.assignee_id, title = excluded.title, status = excluded.status, item_key = excluded.item_key, status = excluded.status, due_date = excluded.due_date, updated_at = excluded.updated_at, state = excluded.state, company = excluded.company [42000-214] Here is my connection string: "jdbc:h2:mem:default;DB_CLOSE_DELAY=-1;MODE=PostgreSQL;DATABASE_TO_LOWER=TRUE;DEFAULT_NULL_ORDERING=HIGH;INIT=RUNSCRIPT FROM 'schema.sql';" Is there another setting I'm missing? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/54ebacf8-dd4f-4132-b332-0d97224596e6n%40googlegroups.com.