Multiple Functions and Tables in different Schemas with COmposite Types

From: Jason Tesser <jasontesser(at)gmail(dot)com>
To: pgsql-jdbc <pgsql-jdbc(at)postgresql(dot)org>
Subject: Multiple Functions and Tables in different Schemas with COmposite Types
Date: 2010-03-11 02:07:31
Message-ID: 98bbb46a1003101807m475f3812gac5b381685d6498a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Jason Tesser 2010-03-11 02:20:45 Re: Multiple Functions and Tables in different Schemas with COmposite Types
Previous Message Lew 2010-03-11 01:48:11 Re: org.postgresql.util.PSQLException: Protocol error. Session setup failed