type cache info fix
| От | Gary Baker |
|---|---|
| Тема | type cache info fix |
| Дата | |
| Msg-id | CAE8acLAFcWVeLxqw+oHwvFfGdWO=XPN6NdGJ8nxMD8GfL0AbqQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: type cache info fix
|
| Список | pgsql-jdbc |
I found that type cache info wasn't honoring search path. (I had a
UDT type that shared a name with a table).
This fixed it.
diff --git a/org/postgresql/jdbc2/TypeInfoCache.java
b/org/postgresql/jdbc2/TypeInfoCache.java
index 2e79758..2d26fd0 100644
--- a/org/postgresql/jdbc2/TypeInfoCache.java
+++ b/org/postgresql/jdbc2/TypeInfoCache.java
@@ -234,7 +234,7 @@ public class TypeInfoCache implements TypeInfo {
if (_getOidStatement == null) {
String sql;
if (_conn.haveMinimumServerVersion("7.3")) {
- sql = "SELECT oid FROM pg_catalog.pg_type WHERE typname = ?";
+ sql = "SELECT ?::regtype::oid";
} else {
sql = "SELECT oid FROM pg_type WHERE typname = ?";
}
В списке pgsql-jdbc по дате отправления: