Re: create trigger
От | Robert B. Easter |
---|---|
Тема | Re: create trigger |
Дата | |
Msg-id | 00121418543929.00289@comptechnews обсуждение исходный текст |
Ответ на | create trigger (Sandeep Joshi <sjoshi@Zambeel.com>) |
Ответы |
Re: create trigger (can't compile example, problem with include files)
|
Список | pgsql-general |
Trigger functions, no matter what language, have be RETURNS OPAQUE. Here is an example (in the PostgreSQL docs): http://www.comptechnews.com/~reaster/postgres/triggers20290.htm Sorry I can't help more as I've never actually used C triggers, just PL/pgSQL ones. On Thursday 14 December 2000 18:04, Sandeep Joshi wrote: > I am trying to use "triggers". I get an error after "create trigger". > Does anybody know why? > > create function insert_into_db2 RETURNS int AS > '/work/posgresql/lib/libpq.so' language 'C'; > > create trigger trial before insert or update on db1user for each row > execute procedure insert_into_db2(); > > ERROR: CreateTrigger: function insert_into_db2() must return OPAQUE > > Does anybody know why? > > Also, if a function is enforced to return OPAQUE then what is the > "RETURNS" clause? > > > One more question, > If a trigger does not succeed then I want to ABORT transaction, is > it possible? how? > > > - Sandeep -- -------- Robert B. Easter reaster@comptechnews.com --------- - CompTechNews Message Board http://www.comptechnews.com/ - - CompTechServ Tech Services http://www.comptechserv.com/ - ---------- http://www.comptechnews.com/~reaster/ ------------
В списке pgsql-general по дате отправления: