You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If we set lookup by id and try to import records it will create new record with id that we set in import file. It ignores sequences of ids in database.
That will lead to 'ERROR: duplicate key value violates unique constraint' in future.
The text was updated successfully, but these errors were encountered:
I don't think import by id is feasible due to the issues you note.
In some projects I created a column called import_key and set it to increasing numbers in the CSV file so I can import batches of rows several times in a deterministic way.
If we set lookup by id and try to import records it will create new record with id that we set in import file. It ignores sequences of ids in database.
That will lead to 'ERROR: duplicate key value violates unique constraint' in future.
The text was updated successfully, but these errors were encountered: