29/04/2015 10:21:54 ***** ERROR DE SISTEMA: ***** ADMINISTRADOR ***** CLASE->covensol_release MÉTODO->covensol_release_INS_01_2014 ERROR->Invalid query: ERROR: no existe el lenguaje «plpgsql» HINT: Usar CREATE LANGUAGE para instalar el lenguaje en la base de datos. Whole query: create or replace function reset_sequencia(tabla text,campo text) returns varchar as $$ declare reg record; reg2 record; seq text; begin seq = tabla || '_' || campo || '_seq'; EXECUTE 'SELECT (COALESCE((SELECT '||campo||' FROM '||tabla||' ORDER BY '||campo||' DESC LIMIT 1),0)) AS valor' INTO reg; if reg.valor=0 then reg.valor = 1; end if; SELECT setval(seq,reg.valor) into reg2; return reg.valor; end; $$ LANGUAGE 'plpgsql' VOLATILE STRICT SECURITY DEFINER;