postgresql does not emit BIGSERIAL for biginteger pk (regression in 0.7)

Issue #2065 resolved
Mike Bayer repo owner created an issue
from sqlalchemy import *
from sqlalchemy.schema import CreateTable

e = create_engine('postgresql://scott:tiger@localhost/test')

t = Table('aset', MetaData(), Column('asdf', BigInteger, primary_key=True))

print CreateTable(t).compile(dialect=e.dialect)

Comments (4)

  1. Mike Bayer reporter
    • removed status
    • changed status to open

    can't change SmallInt/BigInt type affinity - need to keep type affinities fundamental. breaks one orm test

  2. Log in to comment