Changes to functions and triggers

Поиск
Список
Период
Сортировка
От darcy@druid.net (D'Arcy J.M. Cain)
Тема Changes to functions and triggers
Дата
Msg-id m132vTP-000AY3C@druid.net
обсуждение исходный текст
Ответы Re: Changes to functions and triggers  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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@{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.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Big 7.1 open items
Следующее
От: Ryan Kirkpatrick
Дата:
Сообщение: Re: Call for port testing on fmgr changes