[EMAIL PROTECTED] 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 [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])