Hello,
I have a process using pg_bulkload and sometimes i have duplicated keys in my csv file that pg_bulkload uses.
My question is: pg_bulkload insert it in sequential order ?
Example, if i have the following csv file:
key_1;0.00
key_1;100.00
And use the ON_DUPLICATE_KEEP = NEW in .ctl file, it's guaranteed that the value 0.00 will be overwritten with 100.00? Or pg_bulkload can't guarantee this order?
