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
|
| Список | 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 по дате отправления: