"Teemu Juntunen" <teemu.juntunen@xxxxxxxxxx> writes: > CREATE TRIGGER td_y AFTER DELETE ON chlid FOR EACH ROW EXECUTE PROCEDURE fn_td_y(); > It seems that SELECT results to null, so the master has already deleted the row. Is this intended and how can I solve this? Your trigger is firing after the RI triggers. If you want it to fire before, give it a name that is before them (in ASCII order). regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general