postgres_scanner

postgres_scanner copied to clipboard

postgres_scanner causes memory leak

1

### What happens? Hi, not sure if this is interesting for you but I get this by executing the following series of steps on DuckDB 0.9.2 (official version, no changes...

ila

https://www.postgresql.org/about/news/apache-arrow-flight-sql-adapter-for-postgresql-010-2716/ would be interesting to be able to query large quantity of data from postgres with the Apache Arrow Flight SQL protocol wdyt ?

raphaelauv

Request: make compatible with Clickhouse postgres interface

2

### What happens? I've mentioned over Discord but would be great. postgres_attach('host=localhost port=9005 dbname=default connect_timeout=10 user=default password=donthackmeplease'); Error: IO Error: Unable to query Postgres: ERROR: Query execution failed. DB::Exception: Table...

alanpaulkwan

duckdb can't insert due to constraint, but also there is no constraint (there is one)

1

### What happens? I have a table in postgres that I want to use duckdb to insert into. I have a unique constraint on the table that uses multiple columns...

NFeruch

### 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 *...

wonb168

I am performing calculations in DuckDB and then writing the results back to Greenplum. Since the rows are dynamic and the number of columns changes daily, I need to rebuild...

wonb168

### What happens? I have a simple parquet file with two columns (types - bigint and varchar[] -in postgres, INT64 and BYTE_ARRAY in parquet) When I try to write the...

arpit94

### What happens? src/postgres_scanner.cpp lstate.sql = StringUtil::Format( R"( COPY (SELECT %s FROM %s.%s %s) TO STDOUT (FORMAT binary); )", in postgresql 9.2 need to write as: COPY "tablename" TO STDOUT...

yulk

I'm the author of the pg_analytica extension that enables periodic parquet exports for Postgres tables. See: https://github.com/sushrut141/pg_analytica The extension currently relies on the parquet_fdw extension to query the parquet files....

sushrut141

### What happens? connect db or run sql in vscode jupyter notebook is very slow > pip show duckdb Name: duckdb Version: 1.0.0 Summary: DuckDB in-process database Home-page: https://www.duckdb.org ...

wangduanduan