ResultSetMetaData getColumnTypeName()
От | Marek Lewczuk |
---|---|
Тема | ResultSetMetaData getColumnTypeName() |
Дата | |
Msg-id | 4743E724.60608@lewczuk.com обсуждение исходный текст |
Ответы |
Re: ResultSetMetaData getColumnTypeName()
|
Список | pgsql-jdbc |
Hi, I would like to discuss an issue ResultSetMetaData.getColumnTypeName(). Within current implementation of PostgreSQL JDBC getColumnTypeName() returns only locale name of a type, even if it is a user-defined type. The JDBC docs says: "...returns type name used by the database. If the column type is a user-defined type, then a fully-qualified type name is returned." It means, that any other type that is not defined within pg_catalog should be returned with its schema name, so e.g. type my_price in schema blabla should be returned as "blabla.my_price". It's quite simple to fix it and I'm ready to do it, but before that I would like to ask about your opinion about changing this behavior. I found this problem when I needed to translate user-defined types to Java and without schema I cannot be sure, that a type is the one that I want to translate (cause there can be many types with the same local name). I would be appreciated for your comments. Ps. Kris - if we will accept, that getColumnTypeName() should return qualified name, then that will cause small changes within org.postgresql.jdbc2.TypeInfoCache class and I would like to know what about my previous changes within this class that are related to array types. Best wishes, Marek
В списке pgsql-jdbc по дате отправления: