Search Postgresql Archives

RE: Duplicate key in UUID primary key index...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux