Cannot create index if table name contains uppercase characters

From: Oldr(ich Dlouhý <oldrich(dot)dlouhy(at)seznam(dot)cz>
To: PGAdmin support forum <pgadmin-support(at)postgresql(dot)org>
Subject: Cannot create index if table name contains uppercase characters
Date: 2003-10-01 09:27:02
Message-ID: 3F7A9DE6.5010104@seznam.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgadmin-support by date

  From Date Subject
Next Message Моисеев Алексей Николаевич 2003-10-01 09:44:03 Russian data in SQL_ASCII encoding
Previous Message Dave Page 2003-10-01 08:29:27 Re: Question: Russian data