hi All, Is there anything special that I need to do to get ON CONFLICT DO NOTHING working with Postgresql? I'm using H2 2.1.210 (and I know it has been added since H2 1.4.200 in 2019) with PostgreSQL10Dialect (H2Dialect doesn't work either) but what I get is
on statement: insert into transaction_type (transaction_type, description) values ('sometx', 'xxxxxx') ON CONFLICT DO NOTHING; I get: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "insert into transaction_type (transaction_type, description) values ('sometx', 'xxxxxx') [*]ON CONFLICT DO NOTHING"; SQL statement: insert into transaction_type (transaction_type, description) values ('sometx', 'xxxxxx') ON CONFLICT DO NOTHING [42000-210] help? Tom -- 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/03b164cf-e394-4109-9bf5-ebb7d7dcb6edn%40googlegroups.com.