double quotes in unicode dbs

Поиск
Список
Период
Сортировка
От Peter Novodvorsky
Тема double quotes in unicode dbs
Дата
Msg-id 871y99ldod.fsf@shamrock.office.altlinux.ru
обсуждение исходный текст
Ответы Re: double quotes in unicode dbs  (Thomas Beutin <tyrone@laokoon.IN-Berlin.DE>)
Re: double quotes in unicode dbs  (Holger Klawitter <lists@klawitter.de>)
Список pgsql-general
Hello!

   I'm writing native driver for OpenOffice.Org for PostgreSQL. I used
to use 8-bit charset db to test a driver (koi8-r, actually), and when I
tried UNICODE db I've found the following problem: queries with double
quotes don't work. For example,

       SELECT * FROM TEST1;

works, but

       SELECT * FROM "TEST1";

doesn't. I'd gladly remove all quoting of table names, but it is done
by sdbc layer of OpenOffice.Org, and I don't want to hack it.

   Is it bug of PostgreSQL multibyte support or mine syntax error?

Thanks.

--
Peter Novodvorsky                             nidd@myxomop.com
   http://garcia.myxomop.com/NiddWiki   Deadheads, unite!

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Trigger which fires on commit? (Multi-table intergrity constraint)
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Create index ... On ... (lower(field1), lower(field2)) doesn't work?