Re: createlang

Exit the psql prompt. Type the same command:

createlang plpgsql test

Then access your db:

psql test

And load your script:

\i test.sql

On Aug 15, 2005, at 4:45 PM, eoghan wrote:

> Hello
> Im trying to load plpgsql into my test db... Im wondering if theres a
> way to check if its loaded... I do:
> test-# createlang plpgsql test
> test-#
> When i try load an example function:
> test-# \i test.sql
> Im getting:
> psql:test.sql:5: ERROR: language "plpgsql" does not exist
> HINT: You need to use "createlang" to load the language into the
> database.
> Anyone any hints for me?
> Thanks
> Eoghan
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

-----
James Cradock, jcradock(at)me3(dot)com