[sqlalchemy] Re: SQLAlchemy does not always generate sequence for primary key field

2015-02-22 Thread Jan Murre
Seems that the difference in in the support for the smallserial datatype. This is not available for postgres 9.1.13: http://www.postgresql.org/docs/9.1/static/datatype-numeric.html Op zondag 22 februari 2015 09:23:38 UTC+1 schreef Jan Murre: I have the following model: class GeoLocation

[sqlalchemy] SQLAlchemy does not always generate sequence for primary key field

2015-02-22 Thread Jan Murre
I have the following model: class GeoLocation(Base): __tablename__ = geolocations id = Column(SmallInteger, primary_key=True) name = Column(String(8), nullable=False) coordinates = Column(String(80), nullable=False) Using SQLAlchemy 0.9.8 and postgresql 9.3.6 it