[10093] ERROR:  invalid byte sequence for encoding "UTF8": 0x00
                  
                  
                  2018-03-01 14:13:34.892 MSK [10093] STATEMENT:  select
                  
                  
                                      pv.id                       as prop_id,
                  
                  
                                      pv.actual_type_id           as prop_actual_type_id,
                  
                  
                                      pv.persisted_type           as prop_persisted_type,
                  
                  
                                      pv.long_value               as prop_long_value,
                  
                  
                                      sv.string_value             as prop_string_value
                  
                  
                                  from
                  
                  
                                      alf_prop_value pv
                  
                  
                                      join alf_prop_string_value sv on (sv.id = pv.long_value and pv.persisted_type = $1)
                  
                  
                                  where
                  
                  
                                      pv.actual_type_id = $2 and
                  
                  
                                      sv.string_end_lower = $3 and
                  
                  
                                      sv.string_crc = $4
                  
                  
                
в стековерфлоу? https://stackoverflow.com/questions/1347646/postgres-error-on-insert-error-invalid-byte-sequence-for-encoding-utf8-0x0
А как обновляли-то? pg_upgrade или dump/restore?
Обсуждают сегодня