[sqlalchemy] Re: SA 0.5.6 how to create a sequence on a non-primary key field with postgres backend

2009-11-01 Thread sim
My apologies, it does indeed work as advertised. The problem turned out to be between the seat and the keyboard :) thanks for the help. On Oct 30, 1:54 am, "Michael Bayer" wrote: > sim wrote: > >     creation_order = Column('creation_order', PGBigInteger, Sequence > > ('creation_order_seq')) >

[sqlalchemy] Re: SA 0.5.6 how to create a sequence on a non-primary key field with postgres backend

2009-10-29 Thread Michael Bayer
sim wrote: > creation_order = Column('creation_order', PGBigInteger, Sequence > ('creation_order_seq')) this works fine for me and this is covered in test cases too. from sqlalchemy import * from sqlalchemy.databases.postgres import PGBigInteger engine = create_engine('postgres://scott:ti.