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(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 produces the right create > statements: > > CREATE TABLE geolocations ( > id SMALLSERIAL NOT NULL, > name VARCHAR(8) NOT NULL, > coordinates VARCHAR(80) NOT NULL, > PRIMARY KEY (id)) > > On another machine, same SQLAlchemy version but with postgresql 9.1.13 it > does not, producing: > > CREATE TABLE geolocations ( > id SMALLINT NOT NULL, > name VARCHAR(8) NOT NULL, > coordinates VARCHAR(80) NOT NULL, > PRIMARY KEY (id)) > > Any pointers? > > > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.