Postgresql bulk insert warning

Help Activities
, ,
1

Hi

the workflow will bulk insert datatable into a postgresql table using Bulk Insert activity.

Warning is

The provided driver version does not support Bulk Insert operations. Please check the drivers.

The bot would not stop but continues to execute and insert records into the db but takes very long time as number of records are high.

My understanding is db switched from bulk mode data insertion to each record data insertion and this is expected with sql.

postgresql version - 14.2
psqlodbc version - 13.02

did anyone faced such situation and what is the solution to get it into bulk mode.

2

@loginerror, @ppr do you have any idea regarding this

3

Hi @AdityaVN

I’m facing same issue, if its solved, could you please let me know how you have overcome this issue.

thanks

4

sure, will post here if I have a solution

5

Hi, I have the same problem, did you find a solution ?

6

Hi
no didn’t have a solution for this so I had to change my design approach