from django.db import connection
if __name__=="__main__":
sql = "create sequence tb_id_seq start with 1 increment by 1 minvalue 1 maxvalue 9223372036854775807 cache 2;"
cursor = connection.cursor()
cursor.execute(sql)
cursor.close()
执行结果:无异常,但数据库中没有新增tb_id_seq。单独在数据库中执行上述sql就可以创建成功。请问为什么?
用的是什么数据库?
postgresql 8.1.4
@SJ_1986: 加上connection.commit()试试:
cursor = connection.cursor()
cursor.execute(sql)
connection.commit()
cursor.close()