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: [email protected]
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> 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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
