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 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 -~----------~----~----~----~------~----~------~--~---