[sqlalchemy] Re: reflection for indices, function-based indices

2009-02-03 Thread Diez B. Roggisch
Index support for Postgres was recently added to the trunk and I merged it into the reflection branch. You are welcome to check out the reflection branch and give it a go. You could do a quick check like so: import sqlalchemy as sa from sqlalchemy.engine.reflection import Inspector e =

[sqlalchemy] Re: reflection for indices, function-based indices

2009-01-04 Thread Randall Smith
Michael Bayer wrote: On Dec 17, 2008, at 6:36 AM, Diez B. Roggisch wrote: Hi, we've got some function-based indices we currently create using plain text()-calls, like this: CREATE UNIQUE INDEX users_lower_email_index ON user_db.users

[sqlalchemy] Re: reflection for indices, function-based indices

2008-12-17 Thread Michael Bayer
On Dec 17, 2008, at 6:36 AM, Diez B. Roggisch wrote: Hi, we've got some function-based indices we currently create using plain text()-calls, like this: CREATE UNIQUE INDEX users_lower_email_index ON user_db.users (lower(email)); This works,