[sqlalchemy] postgresql EXCLUDE constraint

2010-09-23 Thread A.M.
Hello, I am using this PostgreSQL exclusion constraint: CONSTRAINT only_one_valid EXCLUDE USING (synthetic_id WITH =,COALESCE(obsoleteby,'') WITH =), How can I represent this using SQLAlchemy Table metadata so that I can create the table from the metadata? Cheers, M -- You received this

Re: [sqlalchemy] postgresql EXCLUDE constraint

2010-09-23 Thread Michael Bayer
custom DDL is most directly via the DDL() element: http://www.sqlalchemy.org/docs/core/schema.html#sqlalchemy.schema.DDL or if you want a more general use EXCLUDE construct that accepts arguments and SQL expressions you can subclass DDLElement and build a compilation function: