'Error Message' "language plpgsql does not exist

From: John Foster (jfoster_at_augustmail.com)
Date: 08/12/04

  • Next message: Brian Pack: "Re: rpm packages Debian" 
    To: Debian User <debian-user@lists.debian.org>
Date: Thu, 12 Aug 2004 13:57:55 -0500

    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 UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org 
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
  • Next message: Brian Pack: "Re: rpm packages Debian"

    Relevant Pages

    • seeking help with postgres installation and use
      ... much of the book is easily translated to Postgres. ... Then I enable plpgsql: ... $ grep -i FAIL ./regression.out ... language "plpgsql" does not exist ...
      (Fedora)
    • Re: I need some help from native speakers of Japanese
      ... a course called "Morphology and Syntax," etc. etc. ... with language is on the ground, ... And I found your question opaque. ... weren't sure whether the English sentence was intentional, ...
      (sci.lang.japan)
    • Re: I need some help from native speakers of Japanese
      ... a course called "Morphology and Syntax," etc. etc. ... with language is on the ground, ... And I found your question opaque. ... weren't sure whether the English sentence was intentional, ...
      (sci.lang.japan)
    • Re: "To visit an apartment"
      ... How is this so you find humor in ... a language you, presumably, cannot understand? ... is opaque to others. ... Purl Gurl ...
      (alt.usage.english)