PL/JAVA issues

Поиск
Список
Период
Сортировка
Искать

PL/JAVA issues

От:
yogesh <yogesh.arora.daffodil@gmail.com>
Дата:
Hello frnds,
    I have created a PL/JAVA class.
Step 1.   create a Function in Postgres  that returns a set of Complex
type
Step 2  . Create a Complex Type.
Step 3.   Write the Class
Step 4.   Deploy it in Postgres
Step 5.   Call the Method
Step 6.   Method calls and it founds the required method but then
gives the Error that relation not Found ( Table)  but the table exists
in the Database....


Any body has the  solution of it. Please reply me...

 Regards,
    Yogesh Arora

Re: PL/JAVA issues

От:
Richard Broersma Jr <rabroersma@yahoo.com>
Дата:
--- On Wed, 10/31/07, yogesh  wrote:

> Step 6.   Method calls and it founds the required method but then
> gives the Error that relation not Found ( Table)  but the table exists
> in the Database....

When you specify that table name, did you qualify it with its associated schema? Also, depending on how you created your table names (created case sensitive tables names using quotations), you may need to need to supply the propery spelled and quoted table names to the pl function.

Regards,
Richard Broersma Jr.
FAQ