postgres_scanner

postgres_scanner copied to clipboard

When I write the following code in DuckDB: CREATE SECRET ps ( TYPE postgres, HOST '${ip}', PORT ${port}, DATABASE ${dbname}, USER '${user}', PASSWORD '${password}' ); ATTACH 'dbname=${dbname}' AS gp (TYPE...

PlumJade

Hi, we are trying to use duckdb with the postgres extension in aws ecs fargate. But got the following error: `Failed to download extension "postgres_scanner" at URL "http://extensions.duckdb.org/v1.2.0/linux_amd64_musl/postgres_scanner.duckdb_extension.gz" (HTTP 403)...

xuanziranhan

### What happens? I need to build v1.2.0 duckdb postgres extension because our environment is air tight and we need to install from source (cannot download the built binaries). After...

saul-data

Fix #272: no longer treat main schema as a special schema

1

Fix #272 Also bump DuckDB to include https://github.com/duckdb/duckdb/pull/15966 - which enables this change.

Mytherin

pg_hint_plan does not work with postgres_query

1

### What happens? I'm trying to use https://github.com/ossc-db/pg_hint_plan extension that enables query hinting via embedded comments. Unfortunately it looks like comments do not reach the server and hints don't work....

mwisnicki

"There are no UNIQUE/PRIMARY KEY Indexes that refer to this table" when inserting into a PG table with a unique constraint.

3

### What happens? Inserting into a postgres table with a conflict or replace statement does not work as it appears duckdb does not fetch the indexes or schema correctly? ###...

kilianc

Unwanted rows modified when using UPDATE on partitioned table : CTID are not unique in partitioned tables

1

### What happens? When Duckdb updates a Postgres partitioned table, it will also update rows that are not wanted. After a bit of digging, i found that currently, ctid are...

sco-atolcd

After attaching to a postgres database, the statement: `CALL postgres_execute('pg', 'VACUUM my_schema.my_table');` fails with ``` Invalid Error: Failed to execute query "BEGIN TRANSACTION ISOLATION LEVEL REPEATABLE READ; VACUUM my_schema.my_table": ERROR:...

mldisibio

Is it possible to add support for accessing temporary tables when the SCHEMA parameter is used in ATTACH? https://github.com/duckdb/duckdb-postgres/pull/259 is very nice to limit to attaching a single schema, but...

echai58

### What happens? Memory usage keeps increasing as the process progresses. It seems that the results from PostgreSQL queries are not being released or cleaned up properly. ### To Reproduce...

vineetver