On Aug 9, 2012, at 7:58 PM, Warwick Prince wrote: > 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. >
I'd highly recommend using psycopg2 here. Its featureset, performance (it's written completely in C), project velocity , and support responsiveness are unmatched not just by pg8000 but any other DBAPI I've used. -- 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.