From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | Eric Hallander <ehallander(at)tellium(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: UPDATE_RULE |
Date: | 2002-10-25 09:23:48 |
Message-ID: | 1035537834.1831.165.camel@inspiron.cramers |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Eric,
The whole case sensitivity thing is a problem. It is likely that the
tables are actually in lower case in the databaase, no? Postgres
actually is a case sensitive database so you have to ask for the
information in the correct case. There is one caveat: if you do create
table FOO ... it willl create a table foo. If you do create table
"FOO"... you will get a table FOO. We have some case inconsistencies in
the driver because we are waffling back and forth wrt supporting the
underlying ability to have case sensitive names or not.
As far as the update rule, and delete rule go, no there isn't patch for
it. What are you looking for exactly?
Dave
On Wed, 2002-10-23 at 15:59, Eric Hallander wrote:
> I have seen some talk on some older threads about some patches for the
> getImported getExported Keys functions in the DatabaseMetaData class
> that fix:
>
> 1) Case sensitivity in the table name (right now I have to cast down to
> lower case to get results)
> 2) Return the proper values for the UPDATE_RULE, and DELETE_RULE columns
>
> I am currently using the latest developer 7.3 jdbc driver with java 1.4.
> Is there someplace I can get a fix to this?
>
> Eric
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Hale Pringle | 2002-10-25 15:22:09 | Re: Case Sensitivity |
Previous Message | Barry Lind | 2002-10-25 02:57:45 | Re: [PATCHES] Anoter JDBC Error |