Thread: getTables()

Hi,

Sorry folks it's me once again.  The following method from DatabaseMetaData.java (v 1.48 JDBC2 compliant) excludes tables that have rules attached to it.

 private static final String getTableTypes[][] = {
    {"TABLE", "(relkind='r' and relhasrules='f' and relname !~ '^pg_' and relname !~ '^xinv')"},
    {"VIEW", "(relkind='v' and relname !~ '^pg_')"},
    {"INDEX", "(relkind='i' and relname !~ '^pg_')"},
    {"SEQUENCE", "(relkind='S' and relname !~ '^pg_')"},
    {"SYSTEM TABLE", "(relkind='r' and relname ~ '^pg_')"},
    {"SYSTEM INDEX", "(relkind='i' and relname ~ '^pg_')"}
   };

I don't think this is right because getTables() should essentially mimic the behavior of psql's \dt

Thanks,
Richie

 

---

Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site

This was fixed about three weeks ago.  A compiled driver with this code
has not yet been posted to jdbc.postgresql.org, so to get it you will have
to check it out of cvs and build from source.

Kris Jurka


On Fri, 25 Oct 2002, Robinson wrote:

>
> Hi,
>
> Sorry folks it's me once again.  The following method from DatabaseMetaData.java (v 1.48 JDBC2 compliant) excludes
tablesthat have rules attached to it. 
>
>  private static final String getTableTypes[][] = {
>     {"TABLE", "(relkind='r' and relhasrules='f' and relname !~ '^pg_' and relname !~ '^xinv')"},
>     {"VIEW", "(relkind='v' and relname !~ '^pg_')"},
>     {"INDEX", "(relkind='i' and relname !~ '^pg_')"},
>     {"SEQUENCE", "(relkind='S' and relname !~ '^pg_')"},
>     {"SYSTEM TABLE", "(relkind='r' and relname ~ '^pg_')"},
>     {"SYSTEM INDEX", "(relkind='i' and relname ~ '^pg_')"}
>    };
>
>
> I don't think this is right because getTables() should essentially mimic the behavior of psql's \dt
>
> Thanks,
> Richie
>
>
>
>
>
> ---------------------------------
> Do you Yahoo!?
> Y! Web Hosting - Let the expert host your web site