Dear LabKey team,

Following on this issue, and after shortly discussing with Adam Rauch in the Basel's LabKey conference, I would like to document some inconsistency when bulk-importing data with repeated primary key values.

There are two different behaviors:

1- When the list has as PK an auto-incremental integer, importing data with already existing PK values will be ignored and the already existing data records will be appended to the list as new records with new generated PK value.

2 - When the list does not have an auto-incremental PK, importing data with already existing PK values will report a duplicate key error and data will be neither updated nor appended. E.g. "row 2: ERROR: duplicate key value violates unique constraint "c163d1650_test2_pk" Detail: Key (pk)=(PK1) already exists."

Any chances to restore the updating feature when uploading data files as existed in the past?

Thanks a lot for your great product!
Eva Pujadas