"Neil Aggarwal" <[EMAIL PROTECTED]> writes:
> 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.
As Emmanuel said, you should be able to reproduce this without
sequoia. If you can, then it is in contradiction with PostgreSQL
documentation (see SEQUOIA-765 for pointer) and should be filed by
PostgreSQL as a bug.
Another possibility is that there might be a difference between the
DML and DDL parts of the SQL standard that would explaining this
(i.e., not a bug: a feature!)
Unfortunately I have no time right now to investigate this.
Cheers,
Marc.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
