Cannot create index if table name contains uppercase characters

Поиск
Список
Период
Сортировка
От Oldr(ich Dlouhý
Тема Cannot create index if table name contains uppercase characters
Дата
Msg-id 3F7A9DE6.5010104@seznam.cz
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Dave Page"
Дата:
Сообщение: Re: Question: Russian data
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: Cannot create index if table name contains uppercase characters