[sqlalchemy] Re: problem with SHOW command

2008-07-07 Thread Glauco 

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

[sqlalchemy] Re: problem with SHOW command

2008-07-07 Thread Manlio Perillo 

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