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, but it would be nice to stay in the SA-world even with these 
indices.

And for schema-evolution purposes, we utilize reflection to compare tables. 
Reflection does not not include indices like the above though. Or I missed 
them?

If not, is there a way to add that to SA, maybe through a plugin? I'd be happy 
to contribute if this is seen as valuable addition, I must add though that 
because we solely use postgres, I won't be able to add support for anything 
beyond that - but maybe others would step up to integrate other engines.

Diez

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to