Re: [Sqlalchemy-users] Reflection errors

[Michael Bayer]

OK, what version of Postgres are you using ?  I cut-and-pasted the same tabledefs into a postgres 8.0.4 DB, ran the same program, and it goes all the way through.  I added a second loop that prints repr(table) for each, and it produces pretty much the right table defs: Table('people', <sqlalchemy.databases.postgres.PGSQLEngine object at 0x5c9d10>, Column('person',<sqlalchemy.databases.postgres.PGText object at 0x7c6310>,key='person',primary_key=True,nullable=False,hidden=False,default=None), schema=None) Table('prefs', <sqlalchemy.databases.postgres.PGSQLEngine object at 0x5c9d10>, Column('person',<sqlalchemy.databases.postgres.PGText object at 0x7c6690>,ForeignKey('people.person'),key='person',primary_key=True,nullable=False,hidden=False,default=None), Column('name',<sqlalchemy.databases.postgres.PGText object at 0x7c6630>,key='name',primary_key=False,nullable=True,hidden=False,default=None), schema=None) Table('sites', <sqlalchemy.databases.postgres.PGSQLEngine object at 0x5c9d10>, Column('site',<sqlalchemy.databases.postgres.PGText object at 0x7c6210>,key='site',primary_key=True,nullable=False,hidden=False,default=None), schema=None) Table('sites_config', <sqlalchemy.databases.postgres.PGSQLEngine object at 0x5c9d10>, Column('site',<sqlalchemy.databases.postgres.PGText object at 0x7c6870>,ForeignKey('sites.site'),key='site',primary_key=True,nullable=False,hidden=False,default=None), schema=None) On Feb 15, 2006, at 2:52 PM, Dimi Shahbaz wrote: from sqlalchemy import * pg_engine = create_engine('postgres',                         {'database':'alchemytest',                         'host':'127.0.0.1',                         'user':'dimator',                         'password':'.....'}, )# echo=True) tables = ['people','prefs','sites','sites_config'] for table in tables:   print table   t = Table(table, pg_engine, autoload = True)