yeah, thanks. :-) 2010/4/8 Michael Bayer <mike...@zzzcomputing.com>
> > On Apr 7, 2010, at 9:56 PM, 诚子 wrote: > > > there > > > http://my.unix-center.net/~WeiZhicheng/2010/04/07/the-problem-using-sequence-in-postgresql-via-sqlalchemyuh-a-patch-file/<http://my.unix-center.net/%7EWeiZhicheng/2010/04/07/the-problem-using-sequence-in-postgresql-via-sqlalchemyuh-a-patch-file/> > > is the full detian in my problem. > > now It's work for me,but is there has another good idea? > > > "default" is a Python-side default. For a default that is rendered in > CREATE TABLE, you're looking for "server_default". Sequence doesn't > currently work directly with server_default so you need to declare it > separately: > > s = Sequence('lala_id_seq') > t1 = Table('t1', m, > Column('foo', Integer, > primary_key=True, > server_default=text("nextval('lala_id_seq')"), > autoincrement=False) > ) > > s.create(engine) > m.create_all(engine) > > none of this is required if you just use SERIAL, which is the default > behavior if you don't turn off "autoincrement". > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com<sqlalchemy%2bunsubscr...@googlegroups.com> > . > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- my.unix-center.net/~WeiZhicheng -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.