Can't fetch data from Redshift - 1.4.0

[fernandostahelin]

What happens?

Hey, I was trying to use the extension to fetch data from a Redshift cluster and got this error.

Invalid Error:
Failed to prepare COPY "COPY (SELECT "dim_date_id", "dt", "year", "month_name", "month_nbr_of_year", "week_nbr_of_month", "week_nbr_of_year", "day_name", "day_nbr_of_year", "day_nbr_of_month", "day_nbr_of_week", "institution_id" FROM "data_mart"."dim_date" ) TO STDOUT (FORMAT "binary");": ERROR:  syntax error at or near "(" in context "COPY (", at line 1

When executing the COPY duckdb generated, this error pops out

Catalog Error:
Copy Function with name binary does not exist!
Did you mean "parquet"?

Other commands such as DESCRIBE or SHOW ALL TABLES work.

To Reproduce

ATTACH 'postgres://u:pass@....' AS db (TYPE POSTGRES, READ_ONLY)

Replace with existing table

select * from db.public.information_schema;

OS:

MacOS

PostgreSQL Version:

PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.122914

DuckDB Version:

1.4.0

DuckDB Client:

CLI

Full Name:

Fernando Stahelin

Affiliation:

Civitas learning

Have you tried this on the latest main branch?

• I agree

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

• I agree

[fernandostahelin]

Was able to make it work by setting

SET pg_use_text_protocol = TRUE;