Re: Multiple Functions and Tables in different Schemas with COmposite Types

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(at)gmail(dot)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.
>
>