I wondered about that, but in this case all of my tables are lowercase.
Since I've had to clean up mixed case implementations before, I also
lowercase everything else as well (functions, views, etc...)
I decided to create a test database to see if I could further isolate
the problem. I used the following schema in that database:
create table people (name char(10), number char(15));
insert into people values ('jenny','8675309');
now I am able to select from the table with no problems, but when I try
to use the object browser, I now get this error:
java.sql.SQLException: ERROR: no such attribute or function 'oid'
at org.postgresql.Connection.ExecSQL(Connection.java:533)
On the one hand this seems to imply that DatabaseMetaData.getTables is
working ok, but I think that maybe there is a problem with
DatabaseMetaData.getColumns?
Robert Treat
On Thu, 2002-06-27 at 05:42, Holger Mitterwald wrote:
> Hello Robert,
>
> Robert Treat wrote:
>
> >[DEBUG] DB=myserver::mydb Cat=null Sch=null
> >Exception occured during event dispatching:
> >java.lang.NullPointerException
> > at
> > org.postgresql.jdbc2.DatabaseMetaData.getTables(DatabaseMetaData.java:1707)
> > at se.pureit.dbvis.Selector.getTablesFor(Selector.java:679)
> > etc...
> >
> >
> Just a blind guess as I run into the same exception with an other program:
>
> DatabaseMetaData.getTables() is case-sensitive, but PostgreSQL expects
> table names as lowercase (if not quoted with "'").
> So rename all your tables to lowercase.
>
> Best regards,
> Holger
>