Pkey restraint error

💬 App Building
1

I am trying to allow a page I created to let users insert a record. I set up a GUI SQL using key value pairs. Now, when it runs, I get the following error " Insert into rp_shipped_2025 failed: you must satisfy the constraint 'Rp shipped 2025 pkey'

This error message has been driving me crazy for quite some time. Nobody seems to be able to explain what it means or how to fix it. I have an id field in the table which is auto-incrementing. At this point I have no idea what else to try.

Can someone please help here?

2

Now I am also getting a pkey error when trying to import data into a database.

Duplicate key value violates unique constraint "tp_shipped_2025_pkey"

These pkey errors are going to drive me crazy. Is there any way to fix them?

3

Which database are you using? How is the primary key constraint set up? Does the column have a default established?