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 do you have the same problem with the fetchall()? r = conn.execute( 'SHOW CLIENT_ENCODING' ) print r.fetchall() Glauco -- +------------------------------------------------------------+ Glauco Uri glauco(at)sferacarta.com Sfera Carta Software® info(at)sferacarta.com Via Bazzanese,69 Casalecchio di Reno(BO) - Tel. 051591054 +------------------------------------------------------------+ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---