Devart Forums

Hello thank You very much for the support !

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