PostgreSQL ALTER SEQUENCE using psycopg2 in django

Question

I am trying to alter sequence of id field in my table using psycopg. This is works fine on my local server, but not working on production. I am not getting exceptions, the sequence is just not restarting.

def alter_sequence(last_id):
    try:
        dbname = settings.DATABASES['default']['NAME']
        user = settings.DATABASES['default']['USER']
        host = settings.DATABASES['default']['HOST']
        password = settings.DATABASES['default']['PASSWORD']
        port = settings.DATABASES['default']['PORT']
        connection = psycopg2.connect(
            dbname=dbname,
            user=user,
            password=password,
            host=host,
            port=port,
        )
        cursor = connection.cursor()
        cursor.execute('ALTER SEQUENCE "gs_requests_id_seq" RESTART WITH {}'.format(last_id))
        connection.close()
    except Exception as e:
        print(e)
    pass

I double-checked the database settings - its correct. Other database operations, performed by django ORM with this settings is works fine.

I think, this is not enough information about my project settings but dont know what information I need to specify. I have postgres 9.6 on my local computer and 10.1 on production.

Smit Mehta · Accepted Answer · 2018-03-28 07:06:18Z

1

cursor.execute('ALTER SEQUENCE gs_requests_id_seq RESTART WITH {};'.format(last_id))

Try this!! it will worked for me!

answered Mar 28, 2018 at 7:06

Smit Mehta

1019 bronze badges

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

Comments

umaru · Accepted Answer · 2018-03-28 08:20:35Z

1

I found source of the problem. I didn't commit:

connection.commit()

answered Mar 28, 2018 at 8:20

umaru

17812 bronze badges

Collectives™ on Stack Overflow

PostgreSQL ALTER SEQUENCE using psycopg2 in django

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related