| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Barry Lind <blind(at)xythos(dot)com> |
| Cc: | snpe <snpe(at)snpe(dot)co(dot)yu>, <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: DatabaseMetaData.getTables problem |
| Date: | 2002-11-08 18:57:26 |
| Message-ID: | Pine.LNX.4.33.0211081353050.14247-200000@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Giving it another look this change needs to be made in two places for the
schema and non-schema aware code paths. Patch attached.
Kris Jurka
On Fri, 8 Nov 2002, Kris Jurka wrote:
>
> The problem is that the join to retrieve the table's comment from
> pg_description is not properly constrained. A table's comment is
> stored in pg_description with the objoid of the table's pg_class
> oid and objsubid = 0. A table's column's comments are stored with the
> table's pg_class oid and objsubid of pg_attribute.attnum. If any column
> in the table has a comment then the query will not work properly
> (retrieving extra rows).
>
> Kris Jurka
>
| Attachment | Content-Type | Size |
|---|---|---|
| tablecomment.patch | text/plain | 2.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2002-11-08 20:20:18 | Re: idle processes - pg_recvbuf |
| Previous Message | Josh Trutwin | 2002-11-08 18:43:35 | idle processes - pg_recvbuf |