Updating geo tables with temp tables

BEGIN;

CREATE TEMP TABLE temp_r_sp (seccion character varying(13), pj character varying(5)) ON COMMIT DROP;

INSERT INTO temp_r_sp
SELECT cme_cod, p.agrparjud
    FROM e_cme e, g_seccio07 s, g_parjud p
    WHERE s.geom && p.geom AND
          ST_CONTAINS(p.geom, ST_CENTROID(s.geom)) AND
          e.cme_cod = s.cseccion;

UPDATE e_cme SET cme_agrparjud = t.pj
    FROM temp_r_sp t WHERE cme_cod = t.seccion;

COMMIT;