Ah, yes, I've noticed that this doesn't happen when I change this to
use Psycopg2. So, we must finally make the switch. Anyone know how to
compile Psycopg2 (with a compile flag, not by hackery) so that it does
NOT fill in the tzinfo strcuture for timestamps with timezones? We
pytz fans like our tzinfo structures better.
This ticket at initd.org remains un-worked-on, so I'd like to hear
from anyone else who has dealt with this problem and commented to
initd.org.
Thank you!
Gloria
On Feb 27, 5:53 pm, Michael Bayer <[EMAIL PROTECTED]> wrote:
> psycopg1 isnt really supported.
>
> On Feb 27, 2007, at 3:54 PM, Gloria wrote:
>
>
>
> > I am not able to print the object returned by sqlAlchemy in this
> > instance:
>
> > clients=Table('clients',metadata, autoload=True)
> > s = clients.select(clients.c.client_id==client_id)
> > #print str(s)
> > result = s.execute()
> > client = result.fetchone()
> > print client
>
> > The error:
>
> > Traceback (most recent call last):
> > File "db_interface/sqlAlchemyTest.py", line 61, in <module>
> > x=getClientData(1390)
> > File "db_interface/sqlAlchemyTest.py", line 46, in getClientData
> > print client
> > File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
> > 811, in __repr__
> > File "build/bdist.linux-i686/egg/sqlalchemy/engine/base.py", line
> > 672, in _get_col
> > File "build/bdist.linux-i686/egg/sqlalchemy/databases/postgres.py",
> > line 81, in convert_result_value
> > IndexError: list index out of range
>
> > I'm using Postgresql 8.1.5 and Psycopg 1.99.13 (the latter is old, and
> > used intentionally).
>
> > Thank you,
> > ~G~
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
