| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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 |