Multiple Functions and Tables in different Schemas with COmposite Types

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

Предыдущее
От: Navanethan Muthusamy
Дата:
Сообщение: Clarification With Money data type
Следующее
От: Jason Tesser
Дата:
Сообщение: Re: Multiple Functions and Tables in different Schemas with COmposite Types