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@xxxxxxx
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
