Search Postgresql Archives

Re: createlang

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux