Re: DatabaseMetaData.getTables() problem

From: Barry Lind <blind(at)xythos(dot)com>
To: "w(dot)winter" <w(dot)winter(at)logitags(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: DatabaseMetaData.getTables() problem
Date: 2002-10-29 16:55:14
Message-ID: 3DBEBD72.8060706@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-patches

Wolfgang,

Can you try this test using the 7.3beta3 build of the driver from
jdbc.postgresql.org? I think this should be fixed in the latest build.

thanks,
--Barry

w.winter wrote:
> Hi,
>
> on testing our auto-configuration persistence framework ACP against
> PostgreSQL we found the following problem:
>
> There is a table A625431658_Person1, created as quoted mixed case
> identifier.
>
> I do:
> databaseMetaData.getTables(null, null, "%", new String[] {"TABLE"})
> --> A625431658_Person1 is in the ResultSet. OK.
>
> I do:
> databaseMetaData.getTables(null, null, "A625431658_Person1", new String[]
> {"TABLE"})
> --> A625431658_Person1 is NOT in the ResultSet.
>
> I do:
> databaseMetaData.getTables(null, null, "%erson1", new String[] {"TABLE"})
> --> A625431658_Person1 is in the ResultSet. OK.
>
> Seems there is a problem with mixed case ?
>
>
> Wolfgang
>
> ___________________
> Dr. Wolfgang Winter
> LogiTags Systems
> www.logitags.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2002-10-29 17:16:54 Re: notification support
Previous Message Barry Lind 2002-10-29 16:53:24 Re: precision of numeric type

Browse pgsql-patches by date

  From Date Subject
Next Message Kris Jurka 2002-10-29 18:37:49 Re: DatabaseMetaData.getTables() problem
Previous Message w.winter 2002-10-27 09:39:54 DatabaseMetaData.getTables() problem