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

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 mike...@zzzcomputing.com wrote: sim wrote:     creation_order = Column('creation_order', PGBigInteger, Sequence

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

Hi, I have been trying to create an autoincrement field for a postgres table and it just doesn't seem to work unless the column is also the primary key. (An initial look at the postgres.py file in databases seems to confirm this but I am a complete newb when it comes to the SA source). I have

[sqlalchemy] can I specifiy a postgres bigint using declarative_base?

Just started with SQLAlchemy, been great so far but have been tripped up by the following; Using the standard ORM stuff of; Base = declarative_base() class Temp(Base): __tablename__ = 'temp' somecol = Column('somecol', Integer) In posgres this declares 'somecol' as an `integer' but I

[sqlalchemy] Re: can I specifiy a postgres bigint using declarative_base?

fine am I good to go? I saw some other threads mentioning adding a BigInteger to types but no final word on whether that is a good thing or not? On Aug 4, 10:51 pm, sim simon.cus...@gmail.com wrote: Just started withSQLAlchemy, been great so far but have been tripped up by the following; Using