Re: JDBC patch for DatabaseMetaData - Mailing list pgsql-jdbc

From Peter Eisentraut
Subject Re: JDBC patch for DatabaseMetaData
Date
Msg-id Pine.LNX.4.30.0201101845560.749-100000@peter.localdomain
Whole thread Raw
In response to Re: JDBC patch for DatabaseMetaData  (Barry Lind <barry@xythos.com>)
List pgsql-jdbc
Barry Lind writes:

> It appears that this patch is trying to add schema support for the
> getTables method.  But since postgres doesn't yet support schemas
> (perhaps in 7.3), I don't see how this is going to be possible.  I
> certainly don't agree with the approach here that user = schema.  That
> may be how Oracle does it, but certainly isn't how the ANSI standard
> defines schemas.

It's not how ANSI defines it, but it can be shown to be equivalent.  In
particular, in Entry Level SQL92, schema names *must* be equal to the name
of the user that creates/owns it.  Furthermore, you can make the
implementation-defined extension that CREATE USER automatically creates a
schema for that user in each catalog.  Also, make the
implementation-defined restriction that you cannot give a name to a
database object that is already used in another schema in the same
catalog, and the restriction that you cannot explicitly qualify a name
with a schema.  Note that these are all extensions or restrictions
compared to the standard, not changes to defined behaviour.  Therefore, a
patch that currently considers schema==user is correct and
forward-compatible.

--
Peter Eisentraut   peter_e@gmx.net


pgsql-jdbc by date:

Previous
From: Benjamin.Feinstein@guardent.com
Date:
Subject: Re: LISTEN/NOTIFY support in JDBC driver?
Next
From: "Ed Yu"
Date:
Subject: Re: Statement.java patch (Postgresql 7.1.3)