Postgresでvalue too long for type characterのエラーで更新出来なかった場合はtrimする
UPDATE A SET code = to_char(seq, '00000000000000') ↓ ERROR: value too long for type character(14) UPDATE A SET code = trim(to_char(seq, '00000000000000')) ↓ OK
UPDATE A SET code = to_char(seq, '00000000000000') ↓ ERROR: value too long for type character(14) UPDATE A SET code = trim(to_char(seq, '00000000000000')) ↓ OK