Thread: getSuperTables

Hello,

I need the JDBC3 method getSuperTables for a software I'm working on.

I have implemented it using syntax and coding guidelines as close as possible to the rest of the surronding code. I
triedit with PostgreSQL 8.4, and I don't know the structure of the catalog for version 7, so it throws an exception if
theserver version not at least 8.0. 

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.


Regards,
Paolo

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