trouble with trigger/function???

Поиск
Список
Период
Сортировка
От chris markiewicz
Тема trouble with trigger/function???
Дата
Msg-id 000501c02d2b$f5c3afe0$dbb846c6@cmarkiewicz
обсуждение исходный текст
Список pgsql-general
hello.

i have been trying to create a trigger or trigger/function combination but i
have so far been unsuccessful.  my task is simple, when someone inserts a
row in the PERSON table, create a row in the RESOURCE table (note that i
have to pass parameters).  details below...

first, the basic procedure and trigger are shown here:

CREATE FUNCTION sp_person_resource() RETURNS bool
    AS 'insert into resource(rid, name, type, desc) values (1905, ''chris'',
''person'', ''blah''); select true;'
    LANGUAGE 'sql';

CREATE TRIGGER trig_person_resource BEFORE INSERT ON person
    FOR EACH ROW EXECUTE PROCEDURE sp_person_resource();

i do not know what to use for a return type (i don't really need to return
anything).  but when i try to write a trigger to call that fn, it tells me
that the fn must return opaque...i modify my proc but it tells me that "sql
fns cannot return type opaque."

what's going on?  and a side question, what is opaque?

thanks
chris


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

Предыдущее
От: Marcin Mazurek
Дата:
Сообщение: pg_dump on view
Следующее
От: Philip Warner
Дата:
Сообщение: Re: pg_dump on view