DatabaseMetaData.getTables() problem

From: "w(dot)winter" <w(dot)winter(at)logitags(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: DatabaseMetaData.getTables() problem
Date: 2002-10-27 09:39:54
Message-ID: 002f01c27d9e$e49e0060$667ba8c0@panzerknacker
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-patches

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message w.winter 2002-10-27 09:54:40 precision of numeric type
Previous Message Victor Rodriguez 2002-10-25 23:11:36 DataSource support

Browse pgsql-patches by date

  From Date Subject
Next Message Barry Lind 2002-10-29 16:55:14 Re: DatabaseMetaData.getTables() problem
Previous Message Dennis Björklund 2002-10-26 05:30:36 Re: swedish translation