[Sqlalchemy-tickets] Issue #3835: invalid autoincrement setting can be reflected, causing failures
Brought to you by:
zzzeek
From: Michael B. <iss...@bi...> - 2016-10-20 21:10:42
|
New issue 3835: invalid autoincrement setting can be reflected, causing failures https://bitbucket.org/zzzeek/sqlalchemy/issues/3835/invalid-autoincrement-setting-can-be Michael Bayer: ``` #!python from sqlalchemy import * m = MetaData() t = Table( 't', m, Column( 'x', Integer, primary_key=True) ) e = create_engine("postgresql://scott:tiger@localhost/test", echo=True) m.drop_all(e) m.create_all(e) e.execute("alter table t alter column x type varchar(50)") m2 = MetaData() t2 = Table('t', m2, autoload_with=e) from sqlalchemy.schema import CreateTable print CreateTable(t2) ``` output: sqlalchemy.exc.ArgumentError: Column type VARCHAR(50) on column 't.x' is not compatible with autoincrement=True |