From: | rossel at peranto(dot)de (Andreas Rossel) |
---|---|
To: | |
Subject: | [Pljava-dev] User defined Function |
Date: | 2008-02-18 12:05:16 |
Message-ID: | 002d01c87226$86c7bda0$a5c8a8c0@perantoarr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pljava-dev |
:~\-----Urspr?ngliche Nachricht-----
:~\Von: Kris Jurka [mailto:books at ejurka.com]
:~\Gesendet: Samstag, 16. Februar 2008 00:52
:~\
:~\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
:~\
OK, now I know the difference between sqlj.set_classpath() and search_path ...
Thanks for the hint.
Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | Stefano Bianchi | 2008-02-20 09:07:38 | [Pljava-dev] R: R: select CURRENT_TIMESTAMP is wrong |
Previous Message | Andreas Rossel | 2008-02-18 11:48:11 | [Pljava-dev] User defined Function |