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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/h2-database/03b164cf-e394-4109-9bf5-ebb7d7dcb6edn%40googlegroups.com.
