Multiple Functions and Tables in different Schemas with COmposite Types - Mailing list pgsql-jdbc

From Jason Tesser
Subject Multiple Functions and Tables in different Schemas with COmposite Types
Date
Msg-id 98bbb46a1003101807m475f3812gac5b381685d6498a@mail.gmail.com
Whole thread Raw
Responses Re: Multiple Functions and Tables in different Schemas with COmposite Types  (Jason Tesser <jasontesser@gmail.com>)
List pgsql-jdbc
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.

pgsql-jdbc by date:

Previous
From: Navanethan Muthusamy
Date:
Subject: Clarification With Money data type
Next
From: Jason Tesser
Date:
Subject: Re: Multiple Functions and Tables in different Schemas with COmposite Types