Re: [Sqlalchemy-users] Reflection errors

2006-02-16 Thread Dimi Shahbaz
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 pret

Re: [Sqlalchemy-users] Reflection errors

2006-02-15 Thread 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',,Column('person

[Sqlalchemy-users] Reflection errors

2006-02-15 Thread Dimi Shahbaz
I think I've uncovered a bug in sqlalchemy's reflection feature. I've boiled down my existing postgres database to the following schema: CREATE TABLE people ( person text PRIMARY KEY ) ; CREATE TABLE prefs ( person text PRIMARY KEY REFERENCES people, name text ) ; CREATE TABLE sites (