Re: DatabaseMetaData.getCatalogs() - Mailing list pgsql-jdbc

From Peter Eisentraut
Subject Re: DatabaseMetaData.getCatalogs()
Date
Msg-id Pine.LNX.4.30.0107091757400.677-100000@peter.localdomain
Whole thread Raw
In response to Re: DatabaseMetaData.getCatalogs()  (jason@netspade.com)
List pgsql-jdbc
jason@netspade.com writes:

> Okay here's a context diff against CVS for getting table privileges. I may have more code to add (I noticed
getColumnPrivileges()is not completed - could use my routine for parsing pg_class.relacl?). 

The list of columns you return is wrong.  There is no COLUMN_NAME column.
TABLE_CAT should be filled in with the database name (should be available
via getConnection().getCatalog()).  A missing TABLE_SCHEM should be set to
null (in the SQL sense).  Also you have GRANTOR and GRANTEE mixed up,
besides the fact that PostgreSQL doesn't store the GRANTEE at all (yet).

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-jdbc by date:

Previous
From: jason@netspade.com
Date:
Subject: Re: DatabaseMetaData.getCatalogs()
Next
From: Steve Wampler
Date:
Subject: Re: Too much data received?