Re: create trigger

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(at)comptechnews(dot)com ---------
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------