Re: createArrayOf, type resolved outside search_path on arrays of composite

Jean-Pierre Pelletier wrote:
>
> Can the type cache be flushed programmatically ?

No.

> Could a workaround be for createArrayOf() to be extended
> to accept schema qualified type name?

I think that would only be part of the fix, you'd still need to make the
type cache schema aware (even if the driver didn't track changes to
search_path). The JDBC javadoc for createArrayOf states that the
typeName parameter "is the value returned by Array.getBaseTypeName". So
you'd need to change that to return a schema qualified name and I'm not
sure what else would need to change.

> An unrelated problem is that I had to override toString()
> in testtype to avoid "malformed record literal", is this the
> recommended way to handle composite type?
>

Right now the JDBC driver doesn't know much about composite types, so
that does seem like the correct workaround.

Kris Jurka