Cannot create index if table name contains uppercase characters - Mailing list pgadmin-support

From Oldr(ich Dlouhý
Subject Cannot create index if table name contains uppercase characters
Date
Msg-id 3F7A9DE6.5010104@seznam.cz
Whole thread Raw
List pgadmin-support
-- PGAdmin --

version: PGAdmin III version 1.0.0
OS:      Windows XP Professional SP1

-- postgres --

Postgres: 7.3.4 on i686-pc-linux-gnu
OS:       RedHat Linux 9

- steps to reproduce --

1. Create table with uppercase characters in name (like "tTable")
2. Create index on that table

-- Actual results --

Index is not created
PGAdmin states that reference "public.ttable" does not exist

-- Expected results --

Index is created

-- Comment --

It looks like the PGAdmin lowercases the table name before sending it to 
postgres. If you see the SQL pane when creating the index, the table 
name is correct ("tTable") but in the error message it it lowercased 
("ttable").

Same error is when the SQL command is copied into SQL query tool.

When the same SQL command is entered on psql command line (on linux), 
the index is created



pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Question: Russian data
Next
From: "Dave Page"
Date:
Subject: Re: Cannot create index if table name contains uppercase characters