SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 08:17 AM
| ||||
| ||||
 PL/JAVA issues 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      |
|
04-10-2008, 08:17 AM
| ||||
| ||||
| Re: PL/JAVA issues --- On Wed, 10/31/07, yogesh <yogesh.arora.daffodil@gmail.com> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
Linear Mode
