Received: from bugs.unl.edu.ar (bugs.unl.edu.ar [168.96.132.208]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7809u635850 for ; Tue, 7 Aug 2001 20:09:56 -0400 (EDT) (envelope-from martin@bugs.unl.edu.ar) Received: from localhost (localhost [127.0.0.1]) by bugs.unl.edu.ar (Postfix) with ESMTP id 394542AB43; Tue, 7 Aug 2001 21:09:28 -0300 (GMT) Received: by bugs.unl.edu.ar (Postfix, from userid 1004) id 995812AB38; Tue, 7 Aug 2001 21:09:25 -0300 (GMT) Content-Type: text/plain; charset="iso-8859-1" From: =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= To: Tom Lane Subject: Re: loop on a rule Date: Tue, 7 Aug 2001 21:09:24 -0300 X-Mailer: KMail [version 1.2] References: <01080719220707.11074@bugs> <29386.997228438@sss.pgh.pa.us> In-Reply-To: <29386.997228438@sss.pgh.pa.us> Cc: pgsql sql Mailing List MIME-Version: 1.0 Message-Id: <01080721092408.11074@bugs> Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS snapshot-20010714 X-Archive-Number: 200108/114 X-Sequence-Number: 4335 On Mar 07 Ago 2001 20:53, you wrote: > =?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/rewri >teHandler.c You need version 1.93.2.1, assuming that you're on PG 7.1.2. Yes, I'm on PostgreSQL 7.1.2. I have a resently updated cvs of pgsql (about 3 hours old), but I don't want to put the cvs version on my stable server (I use it on my WorkStation only). How can I patch the source of my pgsql 7.1.2 src tree? Any docs are welcomed! Saludos..... and tons of thanks.... :-) -- Cualquiera administra un NT. Ese es el problema, que cualquiera administre. ----------------------------------------------------------------- Martin Marques | mmarques@unl.edu.ar Programador, Administrador | Centro de Telematica Universidad Nacional del Litoral -----------------------------------------------------------------