On Thu, Dec 16, 2004 at 06:02:04PM -0500, Keith Worthington wrote:
> I am trying to build a function to insert or update data in one table from
> date stored in another table. Eventually I hope to trigger this process based
> on data being INSERTed into the original table. I have written the code below
> based on the documentation and some help from this list. When I execute the
> code I get this error.
>
> ERROR: language "plpgsql" does not exist
Run createlang or CREATE LANGUAGE.
http://www.postgresql.org/docs/7.4/static/xplang.html http://www.postgresql.org/docs/7.4/s...reatelang.html http://www.postgresql.org/docs/7.4/s...elanguage.html
If you want all newly-created databases to have the language, then
create it in template1.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster