Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group