Driver does not return comments for types

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Driver does not return comments for types
Дата
Msg-id jj5ncg$m1a$1@dough.gmane.org
обсуждение исходный текст
Список 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
fortypes 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 по дате отправления:

Предыдущее
От: Dave Cramer
Дата:
Сообщение: Re: JDBC4 Postgresql Driver, Version 9.1-901 - Is it stable or dev version?
Следующее
От: Francisco Javier Morosini Eguren
Дата:
Сообщение: PgNotificationHelper