search

duckdb / postgres_scanner

MIT License
194 stars 35 forks source link

duckdb.duckdb.Error: Failed to copy data: ERROR: invalid byte sequence for encoding "UTF8": 0x00 #228

Open wonb168 opened 1 month ago

wonb168 commented 1 month ago

What happens?

The error occurs when writing a DuckDB table to Greenplum. invalid byte sequence for encoding "UTF8": 0x00

To Reproduce

sql=f"""
insert into gp.tenant_{tenant}_adm.{tb}
select * from tmp_rst
;"""
exesql(sql)

OS:

mac14

PostgreSQL Version:

6.12.1(gp,pg:9.4)

DuckDB Version:

0.10.1

DuckDB Client:

python

Full Name:

wang cz

Affiliation:

Linezone

Have you tried this on the latest main branch?

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?