BUG #1119: DatabaseMetaData.getTables() returns not a lot

The following bug has been logged online:

Bug reference:      1119
Logged by:          Andy Jefferson

Email address:      lists@ajsoft.net

PostgreSQL version: 7.3.2

Operating system:   Linux

Description:        DatabaseMetaData.getTables() returns not a lot

Details:

Hi,

Firstly I'm using the following on Linux
postgresql-server-7.3.2-5.1.91mdk
postgresql-7.3.2-5.1.91mdk
postgresql-jdbc-7.3.2-5.1.91mdk
postgresql-docs-7.3.2-5.1.91mdk

I connect with JDBC to jdbc:postgresql:jpox
i.e to a database "jpox" on my local machine. Connects fine.

If I call DatabaseMetaData.getTables(null,null,"my_table",null); I get a
ResultSet with nothing in it (rs.getNext() == false)

The table certainly exists in this DB !!

If I do DatabaseMetaData.getCatalogs(); I get
jpox
template0
template1

and if I do DatabaseMetaData.getSchemas(); I get
pg_catalog
public


So why does getTables() return nothing ? I've tried putting "%" at front and
end of the "my_table". No effect. I've seen mention of a bug back in v 7.2
for JDBC. Is this also in 7.3 ? If so, is there a workaround ?

I tried to use your mailing lists to report this and see if anyone else has
seen the same ... but after registering and trying posting with 3 different
email addresses and nothing ever appearing I decided to report here.

I really should submit a bug report about your mailing lists as well since
they basically either dont allow people to register, or dont allow them to
send messages.