On Feb 15, 2006, at 9:13 PM, Michael Bayer wrote:
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:
$ psql --version
psql (PostgreSQL) 7.4.8
Could this be the problem? I am not sure if we want to upgrade
postgres just now, as we have other things running off our current
installation.
In the mean-time, I've (painstakingly) recreated our schema in the
sqlalchemy metadata format.
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,de
fault=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,defa
ult=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,defa
ult=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)
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
