26/07/2022 01:22:27  *****  ERROR DE SISTEMA:   *****  ADMINISTRADOR  *****  CLASE->covensol_release MÉTODO->covensol_release_SNO_29_2022 ERROR->Invalid query: ERROR:  cannot alter type of a column used by a view or rule
DETAIL:  rule _RETURN on view datos_carnet depends on column "codasicar"
Whole query: 
						  
						  DROP VIEW public.calculo_personaltabulador;
						  DROP VIEW public.calculo_personal;

						  
						  ALTER TABLE sno_asignacioncargo ALTER COLUMN codasicar TYPE character varying(10);
						  UPDATE sno_asignacioncargo SET codasicar=trim(codasicar);
						  ALTER TABLE sno_hasignacioncargo ALTER COLUMN codasicar TYPE character varying(10);
						  UPDATE sno_hasignacioncargo SET codasicar=trim(codasicar);
						  ALTER TABLE sno_thasignacioncargo ALTER COLUMN codasicar TYPE character varying(10);
						  UPDATE sno_thasignacioncargo SET codasicar=trim(codasicar);
						  ALTER TABLE sno_personalnomina ALTER COLUMN codasicar TYPE character varying(10);
						  UPDATE sno_personalnomina SET codasicar=trim(codasicar);
						  ALTER TABLE sno_hpersonalnomina ALTER COLUMN codasicar TYPE character varying(10);
						  UPDATE sno_hpersonalnomina SET codasicar=trim(codasicar);
						  ALTER TABLE sno_thpersonalnomina ALTER COLUMN codasicar TYPE character varying(10);
						  UPDATE sno_thpersonalnomina SET codasicar=trim(codasicar);
						  						  
						  ALTER TABLE sno_tabulador ALTER COLUMN codtab TYPE character varying(20);
						  UPDATE sno_tabulador SET codtab=trim(codtab);
						  ALTER TABLE sno_htabulador ALTER COLUMN codtab TYPE character varying(20);
						  UPDATE sno_htabulador SET codtab=trim(codtab);
						  ALTER TABLE sno_thtabulador ALTER COLUMN codtab TYPE character varying(20);
						  UPDATE sno_thtabulador SET codtab=trim(codtab);
						  						  
						  ALTER TABLE sno_grado ALTER COLUMN codtab TYPE character varying(20);
						  UPDATE sno_grado SET codtab=trim(codtab);
						  ALTER TABLE sno_grado ALTER COLUMN codgra TYPE character varying(15);
						  UPDATE sno_grado SET codgra=trim(codgra);
						  ALTER TABLE sno_grado ALTER COLUMN codpas TYPE character varying(15);
						  UPDATE sno_grado SET codpas=trim(codpas);
						  
						  ALTER TABLE sno_hgrado ALTER COLUMN codtab TYPE character varying(20);
						  UPDATE sno_hgrado SET codtab=trim(codtab);
						  ALTER TABLE sno_hgrado ALTER COLUMN codgra TYPE character varying(15);
						  UPDATE sno_hgrado SET codgra=trim(codgra);
						  ALTER TABLE sno_hgrado ALTER COLUMN codpas TYPE character varying(15);
						  UPDATE sno_hgrado SET codpas=trim(codpas);
						  
						  ALTER TABLE sno_thgrado ALTER COLUMN codtab TYPE character varying(20);
						  UPDATE sno_thgrado SET codtab=trim(codtab);
						  ALTER TABLE sno_thgrado ALTER COLUMN codgra TYPE character varying(15);
						  UPDATE sno_thgrado SET codgra=trim(codgra);
						  ALTER TABLE sno_thgrado ALTER COLUMN codpas TYPE character varying(15);
						  UPDATE sno_thgrado SET codpas=trim(codpas);
						  						  
						  ALTER TABLE sno_personalnomina ALTER COLUMN codtab TYPE character varying(20);
						  UPDATE sno_personalnomina SET codtab=trim(codtab);
						  ALTER TABLE sno_personalnomina ALTER COLUMN codgra TYPE character varying(15);
						  UPDATE sno_personalnomina SET codgra=trim(codgra);
						  ALTER TABLE sno_personalnomina ALTER COLUMN codpas TYPE character varying(15);
						  UPDATE sno_personalnomina SET codpas=trim(codpas);
						  
						  ALTER TABLE sno_hpersonalnomina ALTER COLUMN codtab TYPE character varying(20);
						  UPDATE sno_hpersonalnomina SET codtab=trim(codtab);
						  ALTER TABLE sno_hpersonalnomina ALTER COLUMN codgra TYPE character varying(15);
						  UPDATE sno_hpersonalnomina SET codgra=trim(codgra);
						  ALTER TABLE sno_hpersonalnomina ALTER COLUMN codpas TYPE character varying(15);
						  UPDATE sno_hpersonalnomina SET codpas=trim(codpas);
						  
						  ALTER TABLE sno_thpersonalnomina ALTER COLUMN codtab TYPE character varying(20);
						  UPDATE sno_thpersonalnomina SET codtab=trim(codtab);
						  ALTER TABLE sno_thpersonalnomina ALTER COLUMN codgra TYPE character varying(15);
						  UPDATE sno_thpersonalnomina SET codgra=trim(codgra);
						  ALTER TABLE sno_thpersonalnomina ALTER COLUMN codpas TYPE character varying(15);
						  UPDATE sno_thpersonalnomina SET codpas=trim(codpas);
						  
						  ALTER TABLE sno_clasificacionobrero ALTER COLUMN grado TYPE character varying(4);
						  UPDATE sno_clasificacionobrero SET grado=trim(grado);
						  ALTER TABLE sno_hclasificacionobrero ALTER COLUMN grado TYPE character varying(4);
						  UPDATE sno_hclasificacionobrero SET grado=trim(grado);
						  ALTER TABLE sno_thclasificacionobrero ALTER COLUMN grado TYPE character varying(4);
						  UPDATE sno_thclasificacionobrero SET grado=trim(grado);
						  						  
						  ALTER TABLE sno_personalnomina ALTER COLUMN grado TYPE character varying(4);
						  UPDATE sno_personalnomina SET grado=trim(grado);
						  ALTER TABLE sno_hpersonalnomina ALTER COLUMN grado TYPE character varying(4);
						  UPDATE sno_hpersonalnomina SET grado=trim(grado);
						  ALTER TABLE sno_thpersonalnomina ALTER COLUMN grado TYPE character varying(4);
						  UPDATE sno_thpersonalnomina SET grado=trim(grado);
						  
						  
						CREATE OR REPLACE VIEW public.calculo_personal AS 
						 SELECT sno_personalnomina.codemp,
							sno_personalnomina.codnom,
							sno_personalnomina.codper,
							sno_personalnomina.sueper,
							sno_personalnomina.sueproper,
							sno_personalnomina.horper,
							sno_personalnomina.staper,
							sno_personalnomina.fecculcontr,
							sno_personal.nivacaper,
							sno_personal.fecingper,
							sno_personal.cedper,
							sno_personal.nomper,
							sno_personal.apeper,
							sno_personal.sexper,
							sno_personal.numhijper,
							sno_personal.anoservpreper,
							sno_personal.fecnacper,
							sno_personal.fecingadmpubper,
							sno_personalnomina.codtabvac,
							sno_personal.cajahoper,
							sno_personal.porcajahoper,
							sno_personalpension.suebasper,
							sno_personalpension.priespper,
							sno_personalpension.pritraper,
							sno_personalpension.priproper,
							sno_personalpension.prianoserper,
							sno_personalpension.pridesper,
							sno_personalpension.porpenper,
							sno_personalpension.prinoascper,
							sno_personalpension.monpenper,
							sno_personalpension.subtotper,
							sno_personalnomina.codded,
							sno_personalnomina.codtipper,
							sno_personalnomina.codcladoc,
							sno_personalnomina.codescdoc,
							sno_personalnomina.fecingper AS fecingnom,
							( SELECT sno_fideicomiso.capantcom
								   FROM sno_fideicomiso
								  WHERE sno_fideicomiso.codemp = sno_personal.codemp AND sno_fideicomiso.codper = sno_personal.codper) AS capantcom,
							( SELECT sno_personalpension_1.tipjub
								   FROM sno_personalpension sno_personalpension_1
								  WHERE sno_personalpension_1.codemp = sno_personalnomina.codemp AND sno_personalpension_1.codper = sno_personalnomina.codper AND sno_personalpension_1.codnom = sno_personalnomina.codnom) AS tipjub,
							( SELECT sno_clasificacionobrero.suemin
								   FROM sno_clasificacionobrero
								  WHERE sno_clasificacionobrero.codemp = sno_personalnomina.codemp AND sno_clasificacionobrero.grado = sno_personalnomina.grado) AS suemingra
						   FROM sno_personalnomina
							 LEFT JOIN sno_personalpension ON sno_personalnomina.codemp = sno_personalpension.codemp AND sno_personalnomina.codnom = sno_personalpension.codnom AND sno_personalnomina.codper = sno_personalpension.codper
							 JOIN sno_personal ON sno_personalnomina.codemp = sno_personal.codemp AND sno_personalnomina.codper = sno_personal.codper;

						ALTER TABLE public.calculo_personal
						  OWNER TO postgres;
						  
						CREATE OR REPLACE VIEW public.calculo_personaltabulador AS 
						 SELECT sno_personalnomina.codemp,
							sno_personalnomina.codnom,
							sno_personalnomina.codper,
							sno_personalnomina.codtab,
							sno_personalnomina.codgra,
							sno_personalnomina.codpas,
							sno_grado.monsalgra,
							sno_grado.moncomgra,
							( SELECT sum(
										CASE
											WHEN sno_primagrado.monpri IS NULL THEN 0::double precision
											ELSE sno_primagrado.monpri
										END) AS sum
								   FROM sno_primagrado
								  WHERE sno_primagrado.codemp = sno_grado.codemp AND sno_primagrado.codtab = sno_grado.codtab AND sno_primagrado.codpas = sno_grado.codpas AND sno_primagrado.codgra = sno_grado.codgra
								  GROUP BY sno_primagrado.codemp, sno_primagrado.codtab, sno_primagrado.codpas, sno_primagrado.codgra) AS monto_primas
						   FROM sno_personalnomina,
							sno_grado
						  WHERE sno_personalnomina.codemp = sno_grado.codemp AND sno_personalnomina.codnom = sno_grado.codnom AND sno_personalnomina.codtab = sno_grado.codtab AND sno_personalnomina.codgra = sno_grado.codgra AND sno_personalnomina.codpas = sno_grado.codpas;

						ALTER TABLE public.calculo_personaltabulador
						  OWNER TO postgres;