Re: How to successfully create a new function?

You should "install" the language in your database.

http://www.postgresql.org/docs/8.0/static/xplang.html

On Fri, Mar 30, 2012 at 12:17 PM, Jim Moon <moonjamesg(at)gmail(dot)com> wrote:

> Andreas,
>
>
> Thank you for your advice--query and other:
>
>
> This query:
>
>
> CREATE OR REPLACE FUNCTION "sp_SetScenario"(scen character varying)
> RETURNS void AS
>
> $BODY$DECLARE
>
> sqlStatement varchar(500);
>
> BEGIN
>
> SET sqlStatement = 'ALTER USER postgres WITH
> DEFAULT_SCHEMA = $1';
>
> EXECUTE(sqlStatement);
>
> END;
>
> $BODY$
>
> LANGUAGE 'pgpsql' VOLATILE
>
> COST 100;
>
>
>
>
>
> returns:
>
>
>
> ERROR: language "pgpsql" does not exist
>
> ********** Error **********
>
> ERROR: language "pgpsql" does not exist
>
> SQL state: 42704
>
>
>
> The only language options in the New Function “wizard” in pgAdmin III are:
>
> internal
>
> c
>
> sql
>
>
> I would be grateful for any further suggestions from you or others.
>
> Kind regards,
> Jim
>
>
>
>