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()
0.4.6
Traceback (most recent call last):
File "postgres_show_bug.py", line 11, in <module>
print r.scalar()
File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py",
line 1661, in scalar
self.connection._handle_dbapi_exception(e, None, None, self.cursor)
File "/var/lib/python-support/python2.5/sqlalchemy/engine/base.py",
line 942, in _handle_dbapi_exception
raise exceptions.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
sqlalchemy.exceptions.InterfaceError: (InterfaceError) cursor already
closed None None
What's the problem?
If I execute the query directly with psycopg2, there are no errors.
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
-~----------~----~----~----~------~----~------~--~---
