Search Postgresql Archives

Re: quoted identifier behaviour

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thomas Kellerer wrote:
Randall Smith wrote on 14.03.2007 18:59:
I'm trying to get Postgresql to work with software that uses JDBC and Oracle for a large government project. So I have to report that the application won't work with Postgresql because it (PG) doesn't adhere to the standard. That's usually something I say about Oracle and MySQL. I'm an advocate of Postgresql and usually tout SQL compliance as a strength, so it bothers me that this is not in line to be corrected.

Then the software is not written well :)

DatabaseMetaData.storesLowerCaseIdentifiers() correctly tells the program that PG stores everything in lowercase. So if a (JDBC based) software wants to be truly multi-DBMS enabled, it *has* to retrieve those things from the driver.

Thomas


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq


I don't write Java software so I can't discuss what you said. However, the SQL the app sends IS SQL compliant and Postgresql is not. A table named foo should be accessible as both foo and "FOO" according to the standard.

Randall



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux