UPDATE g_comuni SET geom = ST_Translate(geom, -0.001187, -0.001223) WHERE cca = '19'

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