[Pljava-dev] User defined Function

From: books at ejurka(dot)com (Kris Jurka)
To:
Subject: [Pljava-dev] User defined Function
Date: 2008-02-15 23:51:48
Message-ID: Pine.BSO.4.64.0802151849180.15289@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pljava-dev

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

In response to

Responses

Browse pljava-dev by date

  From Date Subject
Next Message Kris Jurka 2008-02-15 23:58:39 [Pljava-dev] User defined Function
Previous Message Andreas Rossel 2008-02-14 12:07:21 [Pljava-dev] User defined Function