----- Original Message ----- > 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. :-(
> 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.
<<attachment: PastedGraphic-1.png>>
