Hi everyone, I have a question I use Postgresql Before creating a database, the name is uppercase and lowercase, and there is no problem.
Later SQLAlchemy was updated to version 1.4 Don't know when the version started, When creating a database again, use uppercase and lowercase names, which will always be lowercase database names. As a result, using drop database will fail. I am currently using: Arch-linux postgresql V13.6-1 sqlalcgemy V1.4.33 pyscopg2 V2.93 dictalchemy3 V1.0.0 E.g : engine = sqlalchemy.create_engine( "postgresql://xxx:yyy@localhost/postgres" ) conn = engine.connect() conn.execute( "commit" ) stt = "CREATE DATABASE ABCDEF" conn.execute(stt) conn.close() =============== The database name will become abcdef I'm not sure if this is the reason for sqlalchemy or pyscopg2 ? Thank you everyone. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/ca3b5777-bab9-469e-ad92-95bdda3c55c3n%40googlegroups.com.