Devart Forums

Hello, I'm using the following statement in a batch query with pgDAC 6.3.2 and the Batch_Test table from https://blog.devart.com/using-batch-ope ... 1614856095

insert into batch_test(id, f_integer) values (:id,:value) on conflict on constraint "pk_batch_test" do update set f_integer=:value2

raises an error: sintax error near "on"

Does pgDac supports this kind of statement or I'm doing something wrong ?

By the way insert into batch_test(id, f_integer) values (:id,:value) on conflict do nothing

works fine.
thanks

Hello,
Thank you for the information. We've reproduced the issue and are currently working to resolve it. We'll keep you updated on the progress.

wbr, Oleg
Devart Team

Hello thank You very much for the support !

Hello,
PgDAC doesn't yet support Insert with the ON CONFLICT clause in Batch queries, unfortunately.

wbr, Oleg
Devart Team