QutEcoacoustics/baw-server

Add a unique constraint to `path` on `harvest_items`

Opened this issue · 0 comments

We found a case where a duplicate harvest_item row was made for the same file on disk. The path value was the same.

Consider adding a unique constraint to the harvest_items table.

Also does the btree index we're using not ensure uniqueness? Probably not. Seems like we missed something here.

Found by @hudson-newey