Re: DatabaseMetaData.getTables problem - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: DatabaseMetaData.getTables problem
Date
Msg-id Pine.LNX.4.33.0211081353050.14247-200000@leary.csoft.net
Whole thread Raw
In response to Re: DatabaseMetaData.getTables problem  (Kris Jurka <books@ejurka.com>)
List 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

pgsql-jdbc by date:

Previous
From: "Josh Trutwin"
Date:
Subject: idle processes - pg_recvbuf
Next
From: Dave Cramer
Date:
Subject: Re: idle processes - pg_recvbuf