postgres_scanner

postgres_scanner copied to clipboard

when write back to GP locked by Postgres scanner

2

### What happens? I am writing functions in PL/Python in Greenplum (GP) with three main steps: 1. Using DuckDB to read GP tables. 2. Calculating a result table, "rst," in...

wonb168

how to speed up write data to greenplum

1

I use duckdb to query greenplum, and after a series of calculations, I write the results back to greenplum. However, the write-back speed is very slow. Is there any way...

wonb168

### What happens? I tried to truncate a large table with both psycopg and duckdb_postgres_scanner. Psycopg is truncating table instantly. Duckdb postgres scanner takes long time than psycopg (about 20-30...

arunksoman

Parallel COPY to Postgres ?

3

### What happens? Hello, I tried to do a parallel import in Postgres. I wonder if postgres_scanner allows this ? ### To Reproduce I tried : ``` ATTACH 'user=postgres host=/var/run/postgresql...

anayrat

Support R for Windows

1

### What happens? What would it take to build binaries that can be used in R for Windows? The spatial extension seems to work already: https://github.com/duckdb/duckdb-r/issues/23#issuecomment-1985276933 This extension can be...

krlmlr

Please add support for AWS Redshift (based on PostgreSQL 8.0.2)

12

### What happens? When I try to use the postgres extension with AWS Redshift I get an error message: ``` Error: Invalid Error: Failed to execute query "SELECT CURRENT_SETTING('server_version'), (SELECT...

CedricYauLBD

When I use postgres_scan an exception occurs: permission denied for table

4

### What happens? I am using Quickdb 0.9.2. In my SQL script, I call the postgres_scan command. I specify the correct data for the connection: host, port, user, and so...

k0rsakov

`INSERT INTO [...] ON CONFLICT` unique constraint not found

4

### What happens? `INSERT INTO [...] ON CONFLICT` does not find unique/primary key constraint for a referenced conflict target in an attached Postgres DB. Hence, the Upsert does not occur....

dpprdan

Error copying postgres DB to duckdb using build 0.9.3.dev2938 when using the new ATTACH functionality

1

### What happens? According to the documentation database copying should be available when using dev version of DuckDB but I get the following error when trying to copy a postgres...

taupirho

INSERT ... RETURNING clause returns error when inserting into Postgres table

1

### What happens? When attempting to insert into a Postgres table and return the auto-generated ID for use in indexing, the following error is thrown: ``` Binder Error: RETURNING clause...

tjdammann