3 messages in org.postgresql.pgsql-jdbcRe: DatabaseMetaData.getTables() is s...
FromSent OnAttachments
Marc HerbertJul 20, 2006 9:20 am 
Mark LewisJul 20, 2006 1:12 pm 
Marc HerbertJul 21, 2006 7:19 am 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: DatabaseMetaData.getTables() is silently quoting table identifiers?Actions...
From:Marc Herbert (Marc@continuent.com)
Date:Jul 21, 2006 7:19:06 am
List:org.postgresql.pgsql-jdbc

Marc Herbert <Marc@continuent.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>