Re: 'Error Message' "language plpgsql does not exist

On Thu, Aug 12, 2004 at 13:57:55 -0500, John Foster wrote: > ERROR: language "plpgsql" does not exist Apparently you haven't "installed" the Pl/PgSQL procedural language in your template database yet. See http://www.postgresql.org/docs/7.4/static/xplang.html for documentation and try

'Error Message' "language plpgsql does not exist

I got this error when setting up SQL-Ledger> Error! CREATE FUNCTION del_yearend() RETURNS OPAQUE AS ' begin delete from yearend where trans_id = old.id; return NULL; end; ' language 'plpgsql'; ERROR: language "plpgsql" does not exist Any ideas as to what or why? -- John Foster -- To UN