estas poniendo asi:
EXECUTE 'SELECT count(SF.nro_base) as cantidadFamilia, SF.nro_base
    FROM SocioFamiliar as SF
    GROUP BY SF.nro_base'
    INTO familiaresTemp;

poner asi

EXECUTE 'SELECT count(SF.nro_base) as cantidadFamilia, SF.nro_base
INTO TEMPORARY familiaresTemp
    FROM SocioFamiliar as SF
    GROUP BY SF.nro_base'   ;

-
/*
## Emanuel CALVO FRANCO. ##
          ~-~- 3m4nuek ~-~-
*/
--
TIP 5: ¿Has leído nuestro extenso FAQ?
         http://www.postgresql.org/docs/faqs.FAQ.html

Responder a