Re: loop on a rule

On Mar 07 Ago 2001 20:53, you wrote:
> Martín Marqués <martin@bugs.unl.edu.ar> 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
 
-----------------------------------------------------------------