Menu

#308 SQL commands convert schema name ton lowercase

3.6.3
closed-invalid
PostgreSQL (42)
5
2013-03-30
2013-03-28
Anonymous
No

When i try to write SQL commands, schema name are systematically lowercased, but meaning the feedback inconsistant.

Having a schema already created, named "TEST" (capitalized)
I try « CREATE TABLE TEST.test_schema ( id integer ); »

I got :
«
CREATE TABLE TEST.test_schema ( id integer )
Error in query: ERROR: schema "test" does not exist
»

but writing « create schema TEST; »
leads to :
«
create schema TEST
Query executed OK, 0 rows affected. (0.015 s) Edit
»
in fact, the credated schema is named "test" in lowercase.

Discussion

  • Jakub Vrána

    Jakub Vrána - 2013-03-30
    • status: open --> closed-invalid
     
  • Jakub Vrána

    Jakub Vrána - 2013-03-30

    This doesn't look like Adminer bug. Adminer just passes the SQL command to the server.

     

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.