I guess my issues here is that the driver doesn't seem to provide me a way of handling tablenamespace when types of the same name live in 2 different schemas.
Can I control this at all?
On Wed, Mar 10, 2010 at 9:07 PM, Jason Tesser
<jasontesser@gmail.com> wrote:
I am getting this error function person_save(testclient.person, unknown, testclient.email[], unknown) does not exist when using a prepared statement.
the reason for this is SELECT oid FROM pg_catalog.pg_type WHERE typname = $1
is called and $1 is person
it gets the wrong oid, multiple OID are returned
I tried to make my type be schema.person but that doesn't work
This IN parameters are composite types so I had to create objects that extended PGObject to make it work
My procs all work as I can call from pgadmin by setting searchpath. But from java with a prepared statement and ? as the IN parameters it fails even with the searchpath set.