To answer my own question; I imported -
from sqlalchemy.databases.postgres import PGBigInteger and then used that inplace of Integer in my column declarations. Apart from loosing Database agnosticism is there anything wrong with doing this? I tested inserting, querying and it all appeared 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 <[email protected]> wrote: > Just started withSQLAlchemy, 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 really want a > `bigint', is there a way to do this? I tried the obvious looking for > BigInteger, etc. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
