Re: getSuperTables - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: getSuperTables
Date
Msg-id alpine.BSO.2.00.1004301756490.102@leary.csoft.net
Whole thread Raw
In response to getSuperTables  (Paolo Ambrosio <p.ambrosio@tecnoteca.it>)
List pgsql-jdbc

On Thu, 29 Apr 2010, Paolo Ambrosio wrote:

> I need the JDBC3 method getSuperTables for a software I'm working on.
>
> I am attaching the patch and I would appreciate if someone could take a
> look at it, and perhaps commit it into the cvs repository.
>

The JDBC javadoc for getSuperTables [1] is kind of odd.  It says:

     Supertables have to be defined in the same catalog and schema
     as the sub tables. Therefore, the type description does not
     need to include this information for the supertable.

This seems like an odd restriction based on some other database, but it is
not the case in PG.  I guess we have to follow it though because there
really isn't any place to indicate the schema if it isn't the same as the
sub-table.  Please update your patch to include this restriction.

Also your patch should be in context diff format (use "cvs diff -c").

Kris Jurka

pgsql-jdbc by date:

Previous
From: Pavel Milovantsev
Date:
Subject: Unified setBlobs / setBinaryStream question
Next
From: Kris Jurka
Date:
Subject: Re: Unified setBlobs / setBinaryStream question