Glauco ha scritto:
> Manlio Perillo ha scritto:
>> Hi.
>>
>> I'm having strange problems when I execute a SHOW command with PostgreSQL.
>>
>> from sqlalchemy import create_engine, sql, __version__
>>
>> print __version__
>>
>> URL = 'postgres://xxx:[EMAIL PROTECTED]/xxx'
>> db = create_engine(URL, echo=True)
>> conn = db.connect()
>>
>> query = sql.text('SHOW CLIENT_ENCODING')
>> r = conn.execute(query)
>> print r.scalar()
>>
>>
>>
> I've no problem:
>
> 0.3.10
> 2008-07-07 15:22:29,161 INFO sqlalchemy.engine.base.Engine.0x..d4 SHOW
> CLIENT_ENCODING
> 2008-07-07 15:22:29,161 INFO sqlalchemy.engine.base.Engine.0x..d4 {}
> UTF8
>
What version of SQLAlchemy/PostgreSQL/psycopg2 are you using?
I'm using (on Debian Lenny):
* SQLAlchemy 0.4.6-1
* PostgreSQL 8.3.3-1
* psycopg2 2.0.7-4
>
> do you have the same problem with the fetchall()?
>
> r = conn.execute( 'SHOW CLIENT_ENCODING' )
> print r.fetchall()
>
It's the same.
Thanks Manlio Perillo
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
