Help on Trugger/Function - Mailing list pgsql-admin

From Pam Wampler
Subject Help on Trugger/Function
Date
Msg-id 2E4528861499D41199D200A0C9B15BC0012F4504@taylorwhite.com
Whole thread Raw
Responses Re: Help on Trugger/Function
List pgsql-admin
I am new to postgresql -- I am trying to create a trigger on a table --
I get this error on the function
   ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
Recognized languages are sql, C, internal, and created procedural
languages.

Here is my function that I get this error on:

create function head_insert() returns OPAQUE as '
   BEGIN
   NEW.tests := 0;
   NEW.fails  := 0;
   NEW.reps  := 0;
  END;
'
LANGUAGE 'plpgsql';



pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_dumpall won't work?
Next
From: Simone Tellini
Date:
Subject: Re: pg_dumpall and pg_dumps