| Lists: | pgsql-jdbcpgsql-patches |
|---|
| From: | Kris Jurka <jurka(at)ejurka(dot)com> |
|---|---|
| To: | pgsql-patches(at)postgresql(dot)org |
| Subject: | JDBC Driver - Schema Awareness |
| Date: | 2002-09-14 19:09:18 |
| Message-ID: | 3D83895E.C3A82547@ejurka.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc pgsql-patches |
This patch makes the JDBC Driver's DatabaseMetaData class schema aware.
It also implements a number of new methods including
getProcedureColumns
getTablePrivileges
getColumnPrivileges
getBestRowIdentifier
getVersionColumns
This also splits the DatabaseMetaDataTest into two cases for simple
properties and complicated queries.
I will add complete tests for the DatabaseMetaData class next week.
Kris Jurka
| Attachment | Content-Type | Size |
|---|---|---|
| schemas.patch | text/plain | 120.0 KB |
| DatabaseMetaDataPropertiesTest.java | text/x-java | 7.5 KB |
| From: | Kris Jurka <jurka(at)ejurka(dot)com> |
|---|---|
| To: | Barry Lind <barry(at)xythos(dot)com> |
| Cc: | Dave Cramer <Dave(at)micro-automation(dot)net>, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: JDBC Driver - Schema Awareness |
| Date: | 2002-09-20 05:19:46 |
| Message-ID: | 3D8AAFF2.B20D088@ejurka.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc pgsql-patches |
Barry Lind wrote:
>
> Kris,
>
> This all looks great. However I did notice that you didn't include
> changes for LargeObjectManager.java and Serialize.java. Both of these
> classes issue selects against pg_ tables and thus should be made schema
> aware. Is that something you can include? If not I can do it.
>
> thanks,
> --Barry
The following patch adds schema awareness to the LargeObjectManager and
parts of Serialize. The API for Serialize has no notion of schemas and
did not change that. It also adds some missing escape characters on
LIKE clauses missing from the original patch. This patch does not
supercede the original, but adds to it. Two new files have been added
to implement a Serialize regression test.
Kris Jurka
| Attachment | Content-Type | Size |
|---|---|---|
| schemas2.patch | text/plain | 22.0 KB |
| SerializeTest.java | text/plain | 1.2 KB |
| SerializeObject.java | text/plain | 197 bytes |
| From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
|---|---|
| To: | Kris Jurka <jurka(at)ejurka(dot)com> |
| Cc: | Barry Lind <barry(at)xythos(dot)com>, "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: [PATCHES] JDBC Driver - Schema Awareness Patch applied |
| Date: | 2002-10-01 00:36:04 |
| Message-ID: | 1033432565.1971.31.camel@inspiron.cramers |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc pgsql-patches |
Thanks to Kris, the driver now supports schema's under 7.3
Dave
| From: | dima <_pppp(at)mail(dot)ru> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | unsubscribe |
| Date: | 2002-10-01 07:52:51 |
| Message-ID: | 3D995453.9000302@mail.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc pgsql-patches |