Re: UPDATE_RULE

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
>
>

In response to

  • UPDATE_RULE at 2002-10-23 19:59:22 from Eric Hallander

Responses

Browse pgsql-jdbc by date

  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