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
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 |