Hi David Thanks for that - much appreciated :-)
> > > Hi > > I usually use MySQL to develop on, however I need to work with Postgres for > the first time today so I fired it up. I have a routine which converts a > non-SQL database into the database of choice, converting its schema into a > new table in the target database using SQA, and then copies all the data in > the source database into the new SQL table. > > That all worked fine into the Postgres+pg8000 database. My problem is when I > then attempt to open up a table again using auto reflection I get an error > I've never seen before, and I don't get how this can be, given the table was > created via sqlalchemy? The data looks fine in the table, and all columns > are created as I expected (converting to the correct Postrgres column types > etc. > > Error when I issue t = Table('my_table', meta, autoload=True) is; (sorry > about the screen shot, I'm working in a bad RDP client and can't cut/paste > into my Mac. :-( > > <PastedGraphic-1.png> > > So it appears to be having some problem in the reflection, but I can't see > why - I hope there is a setting in the connection or something I can do to > fix this up? I've never used Postgres before, so I'm groping in the dark.. > From Googling around, it appears that there is some issue with determining > the schema or some such, but it's all assuming I know a lot more about > Postgres than I do! > > Cheers > Warwick > > > Hi Warwick, > > You are using pg8000 1.08 and PostgreSQL >= 9.0. Upgrade to pg8000 1.09, it > fixes this issue (there are new PostgreSQL types introduced in version 9 > which pg8000 didn't know of in 1.08, and added in 1.09). > > regards > -- > David Moore > Senior Software Engineer > St. James Software > Email: dav...@sjsoft.com > > -- > 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 > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. -- 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 sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.