[JDBC driver ignores catalog and schema]
On Fri, 07 Sep 2001 09:58:36 -0400, Tom Lane wrote:
I think it'd be a mistake to expend much effort on this issue in JDBC
right now. We will eventually implement SQL92-compliant schemas in the
backend, and once that happens it'll be possible to do
I am trying to retrieve information about the structure of the database
using the DatabaseMetadata class. I am using version 7.1.3 and the latest
JDBC Drivers I can find. I got similar results with the versions supplied
with Mandrake 8.0 (7.0.3 and associated drivers)
The problems are:
1.
On Thu, 6 Sep 2001 22:30:58 +0100, you wrote:
The problems are:
1. No Index information from the getIndexInfo method
Hmmm... looking at the source, it apppears that
DatabaseMetaData.getIndexInfo() is implemented. If it doesn't
work for you, we would need more information about the problem
to be
Rene Pijlman [EMAIL PROTECTED] writes:
Reading the book Understanding the SQL standard it seems that
what the standard calls a schema is a database in PostgreSQL. A
catalog is a set of schemas. Following the standard, a session
is supposed to have access to a catalog, but in PostgreSQL it
2001 09:13
To: Tom Falconer
Cc: '[EMAIL PROTECTED]'
Subject:Re: [JDBC] DatabaseMetadata problems
On Thu, 6 Sep 2001 22:30:58 +0100, you wrote:
The problems are:
1. No Index information from the getIndexInfo method
Hmmm... looking at the source, it apppears
On Fri, 07 Sep 2001 10:12:39 +0200, I wrote:
getColumns() was fixed recently. It returned only columns with a
comment (IIRC).
No, it returned only columns with a default value, according to
Jeroen van Vianen who fixed it (in 7.2).
See http://fts.postgresql.org/db/mw/msg.html?mid=1032468