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
-----------------------------------------------------------------