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
>