Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#308 SQL commands convert schema name ton lowercase

3.6.3
closed-invalid
Jakub Vrána
PostgreSQL (24)
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.