[Pljava-dev] User defined Function

Kris Jurka books at ejurka.com
Fri Feb 15 23:51:48 UTC 2008



On Mon, 11 Feb 2008, Andreas Rossel wrote:

> But if I trie to call the function i get an error message. The command:
>
>            select testeiner(1);
>
> ERROR: function testeiner(integer) does not exist

This is because the javatest schema is not in your search_path.  PG will 
only look for functions in the schemas you tell it to.

http://www.postgresql.org/docs/8.3/static/ddl-schemas.html#DDL-SCHEMAS-PATH

Kris Jurka




More information about the Pljava-dev mailing list