On Sun, 28 Mar 2004, PostgreSQL Bugs List wrote:
> PostgreSQL version: 7.3.2 > Description: DatabaseMetaData.getTables() returns not a lot > > 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 !! > As with any jdbc problem the standard advice is to upgrade to the latest stable version of the driver (the 7.4 series) available from here http://jdbc.postgresql.org/download.html which is backwards compatible with 7.3 servers and see if the problem persists. One of the things that we played around with for a while before agreeing on how to handle it was the case of the name given and the name in the database. I don't recall what we did in 7.3.2, but currently you must match the case exactly with the server's name ie MYTABLE won't match mytable. Another thing to try would be to put just "%" as the table name and see what happens. Kris Jurka ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
