| 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: | Whole Thread | Raw Message | 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? |