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
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? |