The following code doesn't work when sqlite is used as a backend; the unique index on both tables is created with the same name.
This is SQLAlchemy 0.1.7 with pysqlite2 2.2.2. from sqlalchemy import * a = Table('a', Column('id', Integer, primary_key=True), Column('name', String, unique=True) ) b = Table('b', Column('id', Integer, primary_key=True), Column('name', String, unique=True) ) global_connect('sqlite', {'filename': ':memory:'}) a.create() b.create() ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid0709&bid&3057&dat1642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users