Message-ID: <gh-pgjdbc-pgjdbc-3562-c2718842814@github.com>
From: "rtrier (@rtrier)" <noreply+rtrier@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Wed, 12 Mar 2025 19:02:54 +0000
Subject: Re: [pgjdbc/pgjdbc] issue #3562: After insert with PreparedStatement into table with complex types querying leads to resultset with incorrect type
In-Reply-To: <gh-pgjdbc-pgjdbc-3562@github.com>
References: <gh-pgjdbc-pgjdbc-3562@github.com>
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Login: rtrier
X-GitHub-Comment-Id: 2718842814
X-GitHub-Comment-Type: issue_comment
X-GitHub-Issue: 3562
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-Type: comment
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3562#issuecomment-2718842814
Content-Type: text/plain; charset=utf-8

If read getPGType(int) is called first:

getPGType(119193)
	at org.postgresql.jdbc.TypeInfoCache.getPGType(TypeInfoCache.java:582)
	at org.postgresql.jdbc.PgResultSet.initSqlType(PgResultSet.java:3224)
	at org.postgresql.jdbc.PgResultSet.getSQLType(PgResultSet.java:3213)
	at org.postgresql.jdbc.PgResultSet.internalGetObject(PgResultSet.java:204)
	at org.postgresql.jdbc.PgResultSet.getObject(PgResultSet.java:3072)
	at de.gdiservice.bplan.BPlanDAO.createBPlan(BPlanDAO.java:423)
	at de.gdiservice.bplan.BPlanDAO.findById(BPlanDAO.java:295)
	at de.gdiservice.bplan.BPlanWriteReadTest.runGeoplex(BPlanWriteReadTest.java:110)
	at de.gdiservice.bplan.BPlanWriteReadTest.main(BPlanWriteReadTest.java:164)
getPGType(119193)=> not found

Setting 
	getPGType(119193)=> onPath=false => " pgTypeName=""xplan_gml"."bp_status""
	getPGType(119193) onPath=false => pgNameToOid.put(xplan_gml.bp_status, 119193)
	getPGType(119193)=> pgNameToOid.put("xplan_gml"."bp_status", 119193)
	getPGType(119193)=> pgNameToOid.put(119193, "xplan_gml"."bp_status")