Changes to functions and triggers

From: darcy(at)druid(dot)net (D'Arcy J(dot)M(dot) Cain)
To: hackers(at)PostgreSQL(dot)org
Subject: Changes to functions and triggers
Date: 2000-06-16 12:43:47
Message-ID: m132vTP-000AY3C@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Something changed in 7.02 from 6.3. I used to do this:

CREATE FUNCTION make_date()
RETURNS opaque
AS '/usr/pgsql/modules/make_date.so'
LANGUAGE 'c';
CREATE TRIGGER make_edate
BEFORE INSERT OR UPDATE ON bgroup
FOR EACH ROW
EXECUTE PROCEDURE make_date(edate, aniv, emon, eyear);

This no longer works. I looked and the docs and it seems that this
should work instead.

CREATE FUNCTION make_date(date, int, int, int)
RETURNS opaque
AS '/usr/pgsql/modules/make_date.so'
LANGUAGE 'c';
CREATE TRIGGER make_edate
BEFORE INSERT OR UPDATE ON bgroup
FOR EACH ROW
EXECUTE PROCEDURE make_date('edate', 'aniv', 'emon', 'eyear');

But this gives me;

ERROR: CreateTrigger: function make_date() does not exist

Is this broken now or am I not understanding the documentation? Why
is it looking for a make_date that takes no args?

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ryan Kirkpatrick 2000-06-16 13:14:22 Re: Call for port testing on fmgr changes
Previous Message Jan Wieck 2000-06-16 12:42:12 Re: Big 7.1 open items