From: | Fabio Arias <fharias(at)gmail(dot)com> |
---|---|
To: | Lista Postgres ES <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | PROBLEMA CON REGLA |
Date: | 2009-10-23 13:20:51 |
Message-ID: | c1d7f0f90910230620h5493a36em4066cdca99e4303a@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Muy Buenos Dias, tengo un problema de urgencia, tengo unas tablas
particionadas, pero la regla en UPDATE no me funciona no me actualiza la
tabla, y no se que hacer.
CREATE OR REPLACE RULE transaccion_octubre_update_part AS
ON UPDATE TO "TRANSACCION"
WHERE old."TRAN_FECHA" >= '2009-10-01'::date AND old."TRAN_FECHA" <=
'2009-10-31'::date
DO INSTEAD UPDATE
"TRANSACCION_OCTUBRE" SET "TRAN_ESTADO" = new."TRAN_ESTADO",
"TRAN_PREAPROBADA" = new."TRAN_PREAPROBADA"
WHERE "TRAN_ID" = old."TRAN_ID";
Fabio Hernando Arias Vera
Cel. +57 320 419 2661
Mike Ditka <http://www.brainyquote.com/quotes/authors/m/mike_ditka.html> -
"If God had wanted man to play soccer, he wouldn't have given us arms."
From | Date | Subject | |
---|---|---|---|
Next Message | Fernando Hevia | 2009-10-23 14:12:04 | RE: max-pool-conecction |
Previous Message | Ezequiel - | 2009-10-23 12:29:36 | Re: MODELO ENTIDAD RELACION |