java H2数据库Postgres模式Upsert

Question

当H2数据库处于Postgres模式时，我如何检查它是否支持以下语句（upsert/on conflict）

INSERT INTO event_log_poller_state (aggregate_type, consumer_group_id, value) 
VALUES (?, ?, ?) 
on conflict (aggregate_type, consumer_group_id) " +
                    " do update SET VALUE = ? 
WHERE
  event_log_poller_state.aggregate_type = ? AND
  event_log_poller_state.consumer_group_id = ?

我得到语法错误42000

我写了以下程序来演示

https://github.com/tonymurphy/h2-postgres

编辑2019年10月：签出https://github.com/whisklabs/docker-it-scala或testcontainers。组织