Using ON CONSTRAINT in a Batch Query

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
chipburner
Posts: 2
Joined: Thu 04 Mar 2021 14:20

Using ON CONSTRAINT in a Batch Query

Post by chipburner » 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

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: Using ON CONSTRAINT in a Batch Query

Post by oleg0k » Fri 12 Mar 2021 14:44

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

chipburner
Posts: 2
Joined: Thu 04 Mar 2021 14:20

Re: Using ON CONSTRAINT in a Batch Query

Post by chipburner » Fri 12 Mar 2021 15:02

Hello thank You very much for the support !

oleg0k
Devart Team
Posts: 190
Joined: Wed 11 Mar 2020 08:28

Re: Using ON CONSTRAINT in a Batch Query

Post by oleg0k » Wed 14 Apr 2021 11:31

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

wbr, Oleg
Devart Team

Post Reply