thanks....in fact i used something less documented, "column._label", since that includes logic for truncating the size down if over 30 chars in length. this is committed to 0.1 and 0.2.

On May 23, 2006, at 4:12 AM, Sean Cazzell wrote:

I'm seeing the same problem with postgresql and SA 0.2.  Currently
indexes are getting named like "ux_column/ix_column" - is there any
reason this couldn't be changed to "ux_table_column"?

I've made the change to schema.py and it works for me. Attached diff is
for the 0.2 branch.


Sean Cazzell


On Mon, 2006-05-15 at 21:32 +1000, Jamie Wilkinson wrote:
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
<sa_index_name_fix.diff>



-------------------------------------------------------
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

Reply via email to