TestUtil.createSchema( con, "third_schema" );
TestUtil.createTable( con, "third_schema.x", "third_schema_field_n float");
TestUtil.createSchema( con, "last_schema" );
TestUtil.createTable( con, "last_schema.y", "last_schema_field_n text");
stmt.execute("SET search_path TO first_schema, second_schema, last_schema, public;");
TypeInfo typeInfo = con.getTypeInfo();
int OID = typeInfo.getPGType("y");
ResultSet rs = stmt.executeQuery("SELECT 'second_schema.y'::regtype::oid");
assertTrue(rs.next());
assertEquals(OID, rs.getInt(1));
assertTrue(!rs.next());
TestUtil.dropSchema( con, "first_schema" );