Hi all, the subject pretty much explains it all. Here's a complete example of the issue. Any tips will be appreciate.
Regards, Mariano Python 2.7.2 (default, Oct 14 2011, 23:34:02) [GCC 4.5.2] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import sqlalchemy >>> sqlalchemy.__version__ '0.7.3' >>> from sqlalchemy import Table, Column, Integer, create_engine, MetaData, >>> CheckConstraint >>> from sqlalchemy.orm import sessionmaker >>> session = sessionmaker() >>> Session = session() >>> engine = create_engine('postgresql://usr:passws@localhost/base', echo=True) >>> Session.configure(bind=engine) >>> md = MetaData() >>> md.bind = engine >>> t = Table("test_ck", md, Column("id", Integer, primary_key=True), ... Column("id2", Integer, CheckConstraint("id2 between 1 and 10", name="my_constraint"))) >>> md.create_all(engine) 2011-10-21 19:53:45,523 INFO sqlalchemy.engine.base.Engine select version() 2011-10-21 19:53:45,523 INFO sqlalchemy.engine.base.Engine {} 2011-10-21 19:53:45,708 INFO sqlalchemy.engine.base.Engine select current_schema() 2011-10-21 19:53:45,709 INFO sqlalchemy.engine.base.Engine {} 2011-10-21 19:53:45,804 INFO sqlalchemy.engine.base.Engine select relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where n.nspname=current_schema() and relname=%(name)s 2011-10-21 19:53:45,804 INFO sqlalchemy.engine.base.Engine {'name': u'test_ck'} 2011-10-21 19:53:46,168 INFO sqlalchemy.engine.base.Engine CREATE TABLE test_ck ( id SERIAL NOT NULL, id2 INTEGER CHECK (id2 between 1 and 10), PRIMARY KEY (id) ) 2011-10-21 19:53:46,168 INFO sqlalchemy.engine.base.Engine {} 2011-10-21 19:53:47,116 INFO sqlalchemy.engine.base.Engine COMMIT >>> -- 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.