Re: BUG #3430: Case Sensitive Table Names

Поиск
Список
Период
Сортировка
От Stéphane Schildknecht
Тема Re: BUG #3430: Case Sensitive Table Names
Дата
Msg-id 468DF184.1080508@postgresqlfr.org
обсуждение исходный текст
Ответ на BUG #3430: Case Sensitive Table Names  ("Ashwin" <ashwin_poddar@persistent.co.in>)
Список pgsql-bugs
Ashwin a écrit :
> The following bug has been logged online:
>
> Bug reference:      3430
> Logged by:          Ashwin
> Email address:      ashwin_poddar@persistent.co.in
> PostgreSQL version: 8.2.4
> Operating system:   Linux
> Description:        Case Sensitive Table Names
> Details:
>
> I have a strange problem,
>
> I have created a Table with name Employee_Master
> when i fire a  Query as
> Select * from Employee_Master
> it give me an error as employee_master doesnt Exists.
> but when i rename my table name as employee_master
> the query works fine...
> is that necessary to have table names in small case????
> Please help me...
>
The other possibility would be to query your tables that way :

select * from "Employee_Master";

Which may not be that convenient.

Regards,
Stéphane




В списке pgsql-bugs по дате отправления:

Предыдущее
От: balajisundar@midascomm.com
Дата:
Сообщение: DB Install Problem
Следующее
От: "Gurjeet Singh"
Дата:
Сообщение: Re: BUG #3430: Case Sensitive Table Names