I have a table with a UUID as the primary key field. I am using a procedure to insert a parent and child record and using a UUID generated by an external system (webhook). The UUID insert is generating a "duplicate key" error on insert, but when I SELECT the uuid, nothing is returned. I've even manually scanned all the UUIDs in the table and verified the UUID I'm trying to insert does not exist in the table, and yet nothing I do will get past the duplicate key.
I've tried to vacuum the table, recreate the primary key, recreate the table, and even recreated the database and remigrated data to it. And it's not just one UUID... out of 350,000 records, there are about 20 or so that are throwing "duplicate key" errors. Any ideas what I can try next?
