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