Postgresql Sequence not increase by 1
I use a sequence in the PostgreSQL table with an 8-digits start number like: 20000101 20000102 And execute INSERT query with SQLAlchemy ORM in API (AWS lambda) like: result = session.query("select nextval(‘mydb.student_id_seq’)").one_or_none() id = result[0] student_model = Student( id=id, name="Name", class_id="Class ID", grade="A" ) But sometimes a sequence number increases by a random number or… Read More Postgresql Sequence not increase by 1