alter table tmp_pcmn add pcm_val2 numeric(25);
update tmp_pcmn set pcm_val2=pcm_val::numeric(25);
alter table centralized drop constraint "$2";
alter table jrnx drop constraint "$1";
alter table tmp_pcmn drop pcm_val;
alter table tmp_pcmn RENAME pcm_val2 to pcm_val;
alter table tmp_pcmn add constraint pk_1 primary key (pcm_val);
alter table jrnx add constraint "$1" foreign key (j_poste) references tmp_pcmn(pcm_val);
alter table centralized add constraint "$2" foreign key (c_poste) references tmp_pcmn(pcm_val);