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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/ca3b5777-bab9-469e-ad92-95bdda3c55c3n%40googlegroups.com.
