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 по дате отправления: