Re: Multiple Functions and Tables in different Schemas with COmposite Types
| От | Jason Tesser |
|---|---|
| Тема | Re: Multiple Functions and Tables in different Schemas with COmposite Types |
| Дата | |
| Msg-id | 98bbb46a1003101820h2ef41b09w45ce304fa8c01469@mail.gmail.com обсуждение исходный текст |
| Ответ на | Multiple Functions and Tables in different Schemas with COmposite Types (Jason Tesser <jasontesser@gmail.com>) |
| Ответы |
Re: Multiple Functions and Tables in different Schemas with COmposite
Types
|
| Список | pgsql-jdbc |
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?
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.
В списке pgsql-jdbc по дате отправления: