[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?
Обсуждают сегодня