Robert,
Did you get this sorted out?
Dave
On Thu, 2002-06-27 at 10:48, Robert Treat wrote:
> 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
> >
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>
