I am having postgres 8.1.4.

The following code:

from sqlalchemy import *
from sqlalchemy.databases.postgres import PGBigInteger

metadata = BoundMetaData('postgres://user:[EMAIL PROTECTED]/mydb', echo=True)

company_tbl = Table('company', metadata,
     Column('company_id', PGBigInteger, primary_key=True,
autoincrement=True),
     Column('another_bigint', PGBigInteger))

metadata.drop_all()
metadata.create_all()

producing the following SQL statement:

CREATE TABLE company (
        company_id SERIAL NOT NULL,
        another_bigint INTEGER,
        PRIMARY KEY (company_id)
)

A bug or am I missing something?

thanks
sanjay


--~--~---------~--~----~------------~-------~--~----~
 You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to