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.
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 |