Re: creating functions - Mailing list pgsql-general

From Dale Walker
Subject Re: creating functions
Date
Msg-id 39A86AB4.99E3375@icr.com.au
Whole thread Raw
In response to Re: creating functions  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
Stephan Szabo wrote:
>
> > but I received this as the error:
> > ----------------------------------------------------------
> > ERROR:  Unrecognized language specified in a CREATE FUNCTION:
> > 'plpgsql'.  Recognized languages are sql, C, internal and the
> > created
> > procedural languages.
> > ----------------------------------------------------------
>
> By default the procedural languages are not loaded.  There's a
> script createlang which you can use to load the plpgsql language
> into your database.  (If you want it in all future databases,
> I believe if you add it to template1, all later dbs have it
> enabled)

got it.....

and guess what the sample function worked!

Thanks for that..

--
Dale Walker                                              dale@icr.com.au
Independent Computer Retailers (ICR)               http://www.icr.com.au
ICRnet                               http://www.icr.net.au

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: creating functions
Next
From: andrew@ugh.net.au
Date:
Subject: Local Users "su'ing" (REPOST)