CREATE OR REPLACE FUNCTION replicamueble() RETURNS TRIGGER AS $trigger_replicamueble$
BEGIN
RAISE NOTICE 'Insertando en tabla mueble...';
INSERT INTO mueblereplica values (NEW.nombre, NEW.precio);
RETURN NEW;
END;
$trigger_replicamueble$ LANGUAGE plpgsql;
CREATE TRIGGER trigger_repmueble
AFTER INSERT ON mueble
FOR EACH ROW EXECUTE PROCEDURE replicamueble();
BEGIN
RAISE NOTICE 'Insertando en tabla mueble...';
INSERT INTO mueblereplica values (NEW.nombre, NEW.precio);
RETURN NEW;
END;
$trigger_replicamueble$ LANGUAGE plpgsql;
CREATE TRIGGER trigger_repmueble
AFTER INSERT ON mueble
FOR EACH ROW EXECUTE PROCEDURE replicamueble();
No hay comentarios.:
Publicar un comentario