pg.ddx.io  pljava-dev@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Subject: [Pljava-dev] User defined Function
Date: Mon, 18 Feb 2008 13:05:16 +0100
Message-ID: <002d01c87226$86c7bda0$a5c8a8c0@perantoarr> (raw)
In-Reply-To: <Pine.BSO.4.64.0802151849180.15289@leary.csoft.net>
References: <001201c86c96$60e713f0$a5c8a8c0@perantoarr>
	<Pine.BSO.4.64.0802151849180.15289@leary.csoft.net>

:~\-----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





view thread (6+ messages)

Message-ID: <002d01c87226$86c7bda0$a5c8a8c0@perantoarr>
Permalink:  ../002d01c87226$86c7bda0$a5c8a8c0@perantoarr/
Also on:    postgresql.org/message-id/002d01c87226$86c7bda0$a5c8a8c0@perantoarr

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] User defined Function
  In-Reply-To: <002d01c87226$86c7bda0$a5c8a8c0@perantoarr>
  References: <001201c86c96$60e713f0$a5c8a8c0@perantoarr> <Pine.BSO.4.64.0802151849180.15289@leary.csoft.net> <002d01c87226$86c7bda0$a5c8a8c0@perantoarr>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox