Ported Postgres database fails adding new ids

Question

I have ported a database from MySQL to Postgresql, running behind a django app on heroku.

In adding new rows to tables, Postgres is going back to the start of the id's, in effect starting at 1. I'd deleted some data, say the id's 1, 2 and 3. Now I'm trying to add a new row, which should be id=137, it's trying to use id=4, which already exists. How do I get Postgres to 'refresh' it's auto-id for new rows and find the next available id? Is there some way to do this in Django or in pgAdmin?

klin · Accepted Answer · 2015-06-30 01:57:35Z

2

You should use function setval():

SELECT setval('mytable_mycolumn_seq', 136); -- Next nextval will return 137

answered Jun 30, 2015 at 1:57

klin

123k15 gold badges240 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Ported Postgres database fails adding new ids

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related