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?

Jay PinhoOP•10/6/22, 4:47 PM

OK, just solved it. Turns out I needed to encase my table name (which has a space in it) in double quotes inside single quotes. Like this:

SELECT PG_GET_SERIAL_SEQUENCE('"Table Name"','id');SELECT PG_GET_SERIAL_SEQUENCE('"Table Name"','id');

garyaustin•10/6/22, 4:51 PM

Just a note that you are asking for long term headaches using caps or spaces in column or table names unless you are forced to. You will forget the quotes at some point.

Identity field throwing error

Similar Threads

Similar Threads

Similar Threads