[sqlalchemy] Re: low-level commands in 2.0

2022-11-24 Thread zsol...@gmail.com
This is what I see with echo=True using the following block: select pg_catalog.version() [raw sql] {} select current_schema() [raw sql] {} show standard_conforming_strings [raw sql] {} BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode) DROP DATABASE IF EXISTS md_server [raw sql]

[sqlalchemy] low-level commands in 2.0

2022-11-24 Thread zsol...@gmail.com
Hi, I'm trying to run low-level commands like DROP DATABASE / CREATE DATABASE, with psycopg2. In 1.3 I used the following: with pg_engine.connect().execution_options(isolation_level="AUTOCOMMIT",autocommit=True) as conn: conn.execute(command) Now in 2.0 I run into many errors. I've