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
Using ON CONSTRAINT in a Batch Query
Re: Using ON CONSTRAINT in a Batch Query
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
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
-
- Posts: 2
- Joined: Thu 04 Mar 2021 14:20
Re: Using ON CONSTRAINT in a Batch Query
Hello thank You very much for the support !
Re: Using ON CONSTRAINT in a Batch Query
Hello,
PgDAC doesn't yet support Insert with the ON CONFLICT clause in Batch queries, unfortunately.
wbr, Oleg
Devart Team
PgDAC doesn't yet support Insert with the ON CONFLICT clause in Batch queries, unfortunately.
wbr, Oleg
Devart Team