Identity field throwing error

I imported about 2000 rows from a Google Sheets table, with came with an

id

id

column that was already populated with incrementing integers. When I now try to add an additional row to this table (which I've set as a Primary Key and as an Identity column), I keep getting the "duplicate key value violates unique constraint" error. I've looked around on GitHub and here on Discord for how to solve this, which seems to revolve around resetting the sequence to start at the next

id

id

integer after the max one already in the table, but I cannot for the life of me figure out what SQL query I should be running to do this (or even how to find the name of the "sequence"). Please help?

Supabase•4y ago•

2 replies

Jay Pinho

Identity field throwing error

I imported about 2000 rows from a Google Sheets table, with came with an

id

id

id

id

integer after the max one already in the table, but I cannot for the life of me figure out what SQL query I should be running to do this (or even how to find the name of the "sequence"). Please help?

Identity field throwing error

Similar Threads

Identity field throwing error

Similar Threads

Similar Threads

Similar Threads