I'm belatedly following up to this earlier posting.
The problem there was that I wasn't setting autocommit=True in
text(). However, I was wondering what I can do if I want to directly
write
conn.execute("somestuff")
conn.close()
and have it autocommitted, rather than using text(). The execute()
function doesn't appear to have an 'autocommit' option. What can I do
to have a autocommit happen in this case?
Regards, Faheem.
On Wed, 7 Oct 2009 17:37:51 -0400 (EDT), Faheem Mitha
<[email protected]> wrote:
>
> 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
> -~----------~----~----~----~------~----~------~--~---
>
>
--
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.
