Re: [sqlalchemy] Nested select from insert into select union select

Wow, it worked - chapeau! Thanks for the super-fast response time and the workaround... On Friday, May 9, 2014 12:43:18 PM UTC+10, Michael Bayer wrote: OK well https://bitbucket.org/zzzeek/sqlalchemy/issue/3044/insert-from-select-unionhas a patch, that’s what we’ll be doing. a

Re: [sqlalchemy] Create database with sqlalchemy 0.8.0 and postgres

Hi, the pg8000 driver has an autocommit mode, activated using the boolean 'autocommit' attribute of the DBAPI connection. For example: import pg8000conn = pg8000.connect(user=postgres, password=C.P.Snow) conn.autocommit = Truecur = conn.cursor()cur.execute(CREATE DATABASE qux)conn.autocommit =

[sqlalchemy] Concurrent raw sql execution in a multi-threaded application: Connection is busy with results for another hstmt error

Hi, I am using sqlalchemy version 0.7.6 on Win 7. I am using sqlalchemy to execute raw SQL queries in parallel. Here is how I do it: eng = get_engine() #Threadsafe method to get engine raw_con = eng.connect().connection.connection raw_con.autocommit= True crsr = raw_con.cursor() res =

Re: [sqlalchemy] Concurrent raw sql execution in a multi-threaded application: Connection is busy with results for another hstmt error

On May 9, 2014, at 4:59 PM, Sylvester Steele sylvesterste...@gmail.com wrote: Hi, I am using sqlalchemy version 0.7.6 on Win 7. I am using sqlalchemy to execute raw SQL queries in parallel. Here is how I do it: eng = get_engine() #Threadsafe method to get engine raw_con =