Using ON CONSTRAINT in a Batch Query
Posted: Thu 04 Mar 2021 14:55
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
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