Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f77NsI630958 for ; Tue, 7 Aug 2001 19:54:18 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f77NrwY29389; Tue, 7 Aug 2001 19:53:58 -0400 (EDT) To: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= cc: pgsql sql Mailing List Subject: Re: loop on a rule In-reply-to: <01080719220707.11074@bugs> References: <01080719220707.11074@bugs> Comments: In-reply-to =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= message dated "Tue, 07 Aug 2001 19:22:07 -0300" Date: Tue, 07 Aug 2001 19:53:58 -0400 Message-ID: <29386.997228438@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200108/113 X-Sequence-Number: 4334 =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= writes: > As I said before, I am playing around with views and rules, and found out > that I have something wrong in one of the rules. My delete rule says > something like this: > CREATE RULE admin_delete AS ON > DELETE TO admin_view > DO INSTEAD ( > DELETE FROM carrera WHERE id_curso=old.id_curso; > DELETE FROM inscripcion WHERE carrera=old.id_curso; > DELETE FROM resol WHERE carr=old.id_curso; > DELETE FROM modalidad WHERE carrera=old.id_curso; > INSERT INTO log_carrera (accion,tabla) VALUES ('D','carrera'); > ); I think you need the patch for multi-action rules --- see http://www.ca.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/rewrite/rewriteHandler.c You need version 1.93.2.1, assuming that you're on PG 7.1.2. regards, tom lane