Right now when a record moves from a temp table to the final table, if there is a conflict with PKs or other constraints, no insert is made and the existing record is left alone.
PostgreSQL also supports a true "upsert", where an UPDATE can be run on conflict. Should mds-provider support that (maybe as an option)?
Right now when a record moves from a temp table to the final table, if there is a conflict with PKs or other constraints, no insert is made and the existing record is left alone.
PostgreSQL also supports a true "upsert", where an
UPDATEcan be run on conflict. Shouldmds-providersupport that (maybe as an option)?