Re: [JDBC] DatabaseMetaData.getCatalogs()

2001-07-09 Thread jason 

[[[ Original Message from Tom Lane [EMAIL PROTECTED] ]]]

 [EMAIL PROTECTED] writes:
  Okay here's a context diff against CVS for getting table privileges.
 
 This appears not to be correct for current sources --- the privilege
 set has changed since 7.1.

Ah you probably know better than me. It works in 7.1 for me, but does it have to be 
backwards compatible? Where can I find out how the new privilege set works?

Thanks,
Jason

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [JDBC] DatabaseMetaData.getCatalogs()

2001-07-09 Thread jason 

[[[ Original Message from Peter Eisentraut [EMAIL PROTECTED] ]]]

 The list of columns you return is wrong.  There is no COLUMN_NAME column.

Does PostgreSQL actually support privileges for individual columns?

 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).

Sorry about that. Surely the grantee is the username in the relacl field e.g. 
{=,jason=arwR} and the grantor is the owner of the table?

Jason

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

Re: [JDBC] DatabaseMetaData.getCatalogs()

2001-07-08 Thread jason 

[[[ Original Message from Bruce Momjian [EMAIL PROTECTED] ]]]

 
 Just send over a context diff patch, either against 7.1.2 or CVS.

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?).

Jason Davies

[EMAIL PROTECTED]
 diff


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [JDBC] DatabaseMetaData.getCatalogs()

2001-07-08 Thread Bruce Momjian 

I am Cc'ing the jdbc list.

 [[[ Original Message from Bruce Momjian [EMAIL PROTECTED] ]]]
 
  
  Just send over a context diff patch, either against 7.1.2 or CVS.
 
 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?).
 
 Jason Davies
 
 [EMAIL PROTECTED]

[ Attachment, skipping... ]

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 853-3000
  +  If your life is a hard drive, |  830 Blythe Avenue
  +  Christ can be your backup.|  Drexel Hill, Pennsylvania 19026

---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl