[h2] Re: Syntax error with ON CONFLICT

Hello! This PostgreSQL-specific clause is not supported by H2. You need to use the MERGE command from the SQL Standard: https://www.postgresql.org/docs/current/sql-merge.html https://h2database.com/html/commands.html#merge_using -- You received this message because you are subscribed to the

Re: [h2] Syntax error with ON CONFLICT

Greetings! The `ON CONFLICT ...` clause is Postgres specific and certainly not supported in H2. Please read Postgres' "MODE" as: some specific syntax is supported, but there is no guarantee of full compliance. Best regards Andreas On Wed, 2024-01-17 at 15:04 -0800, 'Drew Dimanlig' via H2

Re: [h2] Syntax error with ON CONFLICT

On 1/18/2024 1:04 AM, 'Drew Dimanlig' via H2 Database wrote: I'm getting this error trying to execute a query that does ON CONFLICT DO UPDATE: We don't support that part of the postgres syntax. You are better off using MERGE INTO, which we do support:

[h2] Syntax error with ON CONFLICT

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