This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi, They all seem to be related to how LS uses Postgres Quoting (or lack of). Basically, Lightspeed never quotes identifiers like schema names, table names and column names. According to Postgres documentation (http://www.postgresql.org/docs/8.0/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS) this may lead to "interesting" results: I had the pleasure of encoutering this "bug" twice, once in having a schema name that contained a dash (which is illegal unless quoted), my schema name was xyz-catalog. The second bug had to do with Having a table name created with Double quotes. i.e.: CREATE TABLE "Types" ... Since Lightspeed does not quote the table names, and issues a SQL like: SELECT FROM Types ... PgSQL internally converts this to "types". SELECT FROM "Types" ... Everything would work.. Although I haven't encountered it myself, I assume the same applies to column names as well.. I hope this is descrpitive enough.. Next, I'll try using LightSpeed from Linux, I'll let you know if I run into anything "interesting" over there... BTW, Ivan. NpgSQL 2.x has both a 3.5 and 2.0 "branch", the 2.0 is free from any 3.5 reference / dependency: http://pgfoundry.org/frs/download.php/2205/Npgsql2.0.5-bin-ms.net.zip
|
|
|
|
|
Hi, By default, LightSpeed does not quote identifiers. This is primarily because the various databases treat that differently - some will automatically start making case sensitive evalutions when quoted. To enable quoted identifiers however please just set the quoteIdentifiers property on your LightSpeedContext to true. This will force identifier quoting no matter what database you're using. We look forward to hearing how you get on with the Linux side of things - we did work to ensure LightSpeed works with Mono and appreciate any feedback from somebody using it in the field. I hope that helps, John-Daniel Trask |
|
|
|
|
Thanks,
|
|
|
|
