Re: DatabaseMetaData.getTables() is silently quoting table identifiers?

From: Marc Herbert <Marc(dot)Herbert(at)continuent(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: DatabaseMetaData.getTables() is silently quoting table identifiers?
Date: 2006-07-21 14:19:29
Message-ID: khjirlrghvy.fsf@meije.emic.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Marc Herbert <Marc(dot)Herbert(at)continuent(dot)com> writes:

> But now if I use .getTables(null, null, "MY_TABLE", null) to ask
> whether this table actually exists, the answer is "no" (empty) because
> .getTables() acts like I quoted the MY_TABLE identifier.
>
> It's quite annoying to create a table and not be able to see it...
>
> Tested with postgresql-server.i686 8.0.7-1PGDG and 8.2dev-503
> Maybe this is a server-side issue?

I finally did my archeology homework:

Date: 2002-10-27 09:39:54 GMT
Subject: DatabaseMetaData.getTables() problem

<http://comments.gmane.org/gmane.comp.db.postgresql.jdbc/1614>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Michael Guyver 2006-07-23 00:55:42 Trouble with CallableStatement
Previous Message Mark Lewis 2006-07-20 20:13:11 Re: DatabaseMetaData.getTables() is silently quoting table