On 27 May 2014 12:25, Yvonne Zannoun <yvonne.zannoun@xxxxxxxxxxxxxxxxxxxxx> wrote: > CREATE OR REPLACE FUNCTION delete_records() > RETURNS TRIGGER AS $$ > BEGIN > delete from "TABLE"; > RETURN NEW; > END; > $$ > LANGUAGE plpgsql; You can't return NEW in an ON DELETE trigger - there is no NEW record. Since you're going with a STATEMENT trigger instead, that's not really relevant anymore (no NEW _or_ OLD record, since statements aren't necessarily involved with single records), but I thought I'd mention that slight oversight ;) -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.
