Hi,
When running this function with postgresql 8.4 and sqla 0.5.5,
def test(dbstring):
from sqlalchemy import create_engine
db = create_engine(dbstring)
conn = db.connect()
from sqlalchemy.sql import text
gq = text("""
SET search_path TO public;
DROP SCHEMA IF EXISTS foo CASCADE;
CREATE SCHEMA foo;
""")
conn.execute(gq)
conn.close()
the schema foo is not created. However, removing the
SET search_path TO public;
line makes it work. This is not the case when issuing these commands
directly via psql. Any idea what might be going on here?
Regards, Faheem.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
