Marc:
I am using Sequoia (latest from CVS) with Postgres 8.2.1 and
JPOX 1.1.5 on top of that.
When I ask JPOX to create a table, it issues this query:
CREATE TABLE "PRODUCT"
(
"SKU" varchar(255) NOT NULL,
PRIMARY KEY ("SKU")
)
Yet, when I look at the database in postgres, it has the
table name as product (lower case).
It looks like the case is not being preserved for me
even though the identifiers are quoted.
Neil
--
Neil Aggarwal, (214)986-3533, www.JAMMConsulting.com
FREE! Eliminate junk email and reclaim your inbox.
Visit http://www.spammilter.com for details.
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Marc
Herbert
Sent: Monday, January 15, 2007 4:45 AM
To: [email protected]
Subject: Re: [Sequoia] Table names are lowercase when using Sequoia from
jpox
Emmanuel Cecchet <[EMAIL PROTECTED]> writes:
> I was just checking and the standard only talks about quote and
> double-quote (no back-quote). Quoted identifiers may be used to break
> some of the identifier rules. Specifically, quoted identifiers may be
> used to bestow a reserved word as a name, or to allow normally
> unusable characters and symbols within a name.
By the way double quotes can also be used to force case-sensitivity
for identifiers.
PostgreSQL is using double quotes like this (PostgreSQL is always
leaning towards the standard).
MySQL case-sensitivity seems... filesystem dependent :-)
See https://forge.continuent.org/jira/browse/SEQUOIA-765
for details and pointers about case-sensitivity.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
