Problems w/ PL/pgSQL not being loaded?

From: "Diehl, Jeffrey" <jdiehl(at)sandia(dot)gov>
To: pgsql-sql(at)postgresql(dot)org
Subject: Problems w/ PL/pgSQL not being loaded?
Date: 2001-04-17 22:30:48
Message-ID: B51F0C636E578A4E832D3958690CD73E0130BEB2@es04snlnt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all.

Once again, I'm trying to climb the learning curve...

I'm trying to write a trigger in PL/pgSQL to update some tables. When I try
to load the function, I get an error message:

The function is:

create function update_modified () returns opauqe as '
BEGIN
NEW.modified := ''now()'';
return 1;
END;
'
language 'plpgsql';

The error message indicates that I'm trying to us an unrecognized language.
The recognized languages are sql, C, internal and other created languages.
I've not loaded anything besides the default.

1. How do I load PL/pgSQL?

2. Does this function look right? It should change the a.modified field
upon update.

Thanx again,
Mike Diehl,
Network Monitoring Tool Devl.
284-3137
jdiehl(at)sandia(dot)gov

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Philip Hallstrom 2001-04-17 23:02:15 Re: Problems w/ PL/pgSQL not being loaded?
Previous Message Nils Zonneveld 2001-04-17 22:25:31 Re: Same question about PostgreSql