agora inbox for pljava-dev@postgresql.org  

help / color / mirror / Atom feed

Subject: [Pljava-dev] User defined Function
Date: Fri, 15 Feb 2008 18:51:48 -0500 (EST)
Message-ID: <Pine.BSO.4.64.0802151849180.15289@leary.csoft.net> (raw)
In-Reply-To: <001201c86c96$60e713f0$a5c8a8c0@perantoarr>
References: <001201c86c96$60e713f0$a5c8a8c0@perantoarr>



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

view thread (6+ messages)  latest in thread

Message-ID: <Pine.BSO.4.64.0802151849180.15289@leary.csoft.net>
Permalink:  ../Pine.BSO.4.64.0802151849180.15289@leary.csoft.net/
Also on:    postgresql.org/message-id/Pine.BSO.4.64.0802151849180.15289@leary.csoft.net

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 using the --to and --cc options:
  reply via email

  To: pljava-dev@postgresql.org
  Subject: Re: [Pljava-dev] User defined Function
  In-Reply-To: <Pine.BSO.4.64.0802151849180.15289@leary.csoft.net>

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

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