Ahora lo tengo así, pero no borra ningun articulo al ejecutarlo:
CREATE TRIGGER trigger_borrado_ocurrencias_clave BEFORE DELETE ON articulos
FOR EACH ROW
EXECUTE PROCEDURE eliminar_ocurrencia();
y una funcion:
CREATE OR REPLACE FUNCTION eliminar_ocurrencia() RETURNS TRIGGER AS '
BEGIN
DELETE FROM ocurrencias_clave WHERE tabla=CAST(TG_RELNAME AS TEXT) AND
id=OLD.id;
RETURN NEW;
END;
' LANGUAGE 'plpgsql';
Si ejecuto
DELETE FROM articulos WHERE id=1;
me responde:
DELETE 0
gracias anticipadas
dr7tbien