Driver does not return comments for types

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Driver does not return comments for types
Date: 2012-03-06 19:09:08
Message-ID: jj5ncg$m1a$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

when defining a comment on a type like this:

create type footype as (id integer);
comment on type footype is 'foobar';

The driver will not return the comment in the remarks column when calling DatabaseMetaData.getTables()

The reason for this is, that AbstractJdbc2DatabaseMetaData joins pg_class against pg_description which is not correct for types as far as I can tell.

For types pg_description must be joined against pg_type (using pg_type.oid = pg_description.objid)

Not sure what the best method to integrate this into the statement used by getTables() would be though.

Regards
Thomas

Browse pgsql-jdbc by date

  From Date Subject
Next Message Francisco Javier Morosini Eguren 2012-03-07 02:00:54 PgNotificationHelper
Previous Message Dave Cramer 2012-03-06 14:58:02 Re: JDBC4 Postgresql Driver, Version 9.1-901 - Is it stable or dev version?