getTables() not working for information_schema or pg_catalog

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема getTables() not working for information_schema or pg_catalog
Дата
Msg-id dm7eel$q6f$1@sea.gmane.org
обсуждение исходный текст
Ответы Re: getTables() not working for information_schema or pg_catalog  (Dave Cramer <pg@fastcrypt.com>)
Re: getTables() not working for information_schema or pg_catalog  (Kris Jurka <books@ejurka.com>)
Список pgsql-jdbc
Hello,

I just stumbled across something:

When I call

con.getMetaData().getTables(null, "information_schema", "%", null);

(where con is a java.sql.Connection), I would assume to get all tables
that are stored in the information_schema, but the returned ResultSet is
empty (next() immediately returns false).

The same is true when I call it with "pg_catalog"
Passing null for the table name does not make a difference.

getTables(null, "public", "%", null) is working fine.

Am I missing something, or is this broken?

I am using postgresql-8.1-404.jdbc3.jar and PG 8.1 on a Windows 2000 box
(with JDK 1.5)


Regards
Thomas

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: Log the sql query ?
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: getTables() not working for information_schema or pg_catalog