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(at)mail(dot)usis(dot)bkc(dot)lv
Systems Manager URL: http://www.usis.bkc.lv/
USIS Riga 7 Smilsu Str., Riga LV1050, LATVIA