what happen in this error"ERROR: invalid byte sequence for encoding "UTF8": 0x00"

[sangli00]

@laurenz maybe oracle table encoding is error.
how to fixed this problem.thanks.

[laurenz]

This is the same problem as #114: while a null byte is allowed in a character string in Oracle, it is not allowed in PostgreSQL. You might want to fix the data on the Oracle side.

[sangli00]

if I can't permission modify oracle data,so this problem is not fix?
maybe invalid character

[laurenz]

There's no way to allow a zero character in PostgreSQL, and oracle_fdw does not have any provisions for modifying the data it gets from Oracle.

Is the zero byte in the character string in the Oracle database intentional?
If not, maybe they would even be interested in fixing it; zero bytes in strings cause all sort of trouble.

[sangli00]

ERROR: no primary key column specified for foreign Oracle table

old release is can't PK ?why need PK column?

[laurenz]

For UPDATE or DELETE. See the description of the key option in the README.

[volkmarbuehringer]

use select translate( column, chr(0),' ' )

in select to convert the invalid byte sequenzes in oracle to something else in oracle
(during selection or update the tables in oracle to remove them )

pg gives you the column names and the invalid codes

before loading into pg I have to do a lot of updates, because the oracledb is infested with this crap,
especially email data