Re: loop on a rule

On Mar 07 Ago 2001 20:53, you wrote:
> =?iso-8859-1?q?Mart=EDn=20Marqu=E9s?= <martin(at)bugs(dot)unl(dot)edu(dot)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(at)unl(dot)edu(dot)ar
Programador, Administrador | Centro de Telematica
Universidad Nacional
del Litoral
-----------------------------------------------------------------