double quotes in unicode dbs - Mailing list 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!