Re: [SQL] Problem with postgreSQL triggers

> to use the traditionnal structure: 
>                create trigger <trigger name>
>                before delete on <table name>
>                for each row
>                BEGIN
>                query;
>                END;    ?
> Otherwise, how can I deal with the "execute procedure <procedure
> name>" statement? Thanks
As from postgresql.org website:

CREATE TRIGGER name { BEFORE | AFTER } { event [OR 
...] } ON table FOR EACH { ROW | STATEMENT } 
EXECUTE PROCEDURE ( arguments ) 
you should apparently create a procedure/function much of the same 
as with: 
CREATE FUNCTION name ( [ ftype [, ...] ] ) RETURNS rtype 
AS definition LANGUAGE 'langname' 

BEGIN/END I think would be restricted to transactions. And therefore 
would be considered reserved words?

Just my idea. Haven't used triggers in Pg yet myself. You might see 
under contributed things / refint (referential integrity) package 
somewhere, there should be lots of triggers I assume.



Emils Klotins       e-mail: emils@mail.usis.bkc.lv
Systems Manager     URL: http://www.usis.bkc.lv/
USIS Riga           7 Smilsu Str., Riga LV1050, LATVIA