Re: [JDBC] DatabaseMetaData.getCatalogs()

2001-07-10 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > > The list of columns you return is wrong. There is no COLUMN_NAME column. > > Does PostgreSQL actually support privileges for individual columns? No. Even if it would, this would belong into DatabaseMetaData.getColumnPrivileges(). getColumnPrivileges() could still

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 ge

Re: [JDBC] DatabaseMetaData.getCatalogs()

2001-07-09 Thread Peter Eisentraut
[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_NA

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

Re: [JDBC] DatabaseMetaData.getCatalogs()

2001-07-08 Thread Tom Lane
[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. regards, tom lane ---(end of broadcast)---

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 getColumnPr

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 m

Re: [JDBC] DatabaseMetaData.getCatalogs()

2001-07-08 Thread Bruce Momjian
> [[[ Original Message from Peter Eisentraut <[EMAIL PROTECTED]> ]]] > > > [EMAIL PROTECTED] writes: > > > > > Is there a reason why getCatalogs() is not supported in the JDBC driver? First > > of all, what is the definition of a catalog? The MySQL JDBC driver simply returns > > a list of the da

Re: [JDBC] DatabaseMetaData.getCatalogs()

2001-07-08 Thread jason
[[[ Original Message from Peter Eisentraut <[EMAIL PROTECTED]> ]]] > [EMAIL PROTECTED] writes: > > > Is there a reason why getCatalogs() is not supported in the JDBC driver? First > of all, what is the definition of a catalog? The MySQL JDBC driver simply returns > a list of the databases so a s

[JDBC] DatabaseMetaData.getCatalogs()

2001-07-06 Thread jason
Hi, Is there a reason why getCatalogs() is not supported in the JDBC driver? First of all, what is the definition of a catalog? The MySQL JDBC driver simply returns a list of the databases so a simple select datname from pg_database; would do the same thing. However there is probably a reason