duckdb/duckdb-postgres issues and pull requests

#292 - Avoid modifying the path that is shown in duckdb_databases with the secret contents

Pull Request - State: closed - Opened by Mytherin 4 days ago

#291 - Working PostGIS integration by converting Postgres Geometry to WKB_BLOB

Pull Request - State: closed - Opened by Mytherin 4 days ago

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

Pull Request - State: open - Opened by Mytherin 4 days ago - 1 comment

#289 - Remove indentations in COPY queries

Pull Request - State: closed - Opened by Mytherin 5 days ago

#288 - Fix #284: quote uppercase identifiers when shipping queries to Postgres

Pull Request - State: closed - Opened by Mytherin 5 days ago

#287 - Correctly emit PK in DESCRIBE, and support optional/in filters

Pull Request - State: closed - Opened by Mytherin 5 days ago

#286 - Fix #270: print a more descriptive error message when PQgetCopyData returns -1 (no error and no header/data)

Pull Request - State: closed - Opened by Mytherin 5 days ago

#285 - Cannot execute `VACUUM` with `postgres_execute()`

Issue - State: open - Opened by mldisibio 6 days ago

#284 - TRUNCATE / DELETE fails on PostgreSQL tables with uppercase names

Issue - State: closed - Opened by baikal 18 days ago

#283 - Defaults and Constraints not respected in duckdb storage extensions

Issue - State: closed - Opened by hafenkran 22 days ago - 1 comment
Labels: reproduced

#282 - Feature request: Include tempory table schemas when a specific schema is attached

Issue - State: open - Opened by echai58 23 days ago

#281 - Simplify build, move to new extension template, fixup CI, apply patches

Pull Request - State: closed - Opened by Maxxen 25 days ago - 2 comments

#280 - Update year in license file to 2025

Pull Request - State: closed - Opened by szarnyasg 29 days ago

#279 - Can't query geometry column in postgres db

Issue - State: closed - Opened by monkseal 30 days ago - 3 comments

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

Issue - State: open - Opened by kilianc about 1 month ago - 3 comments

#277 - pg_hint_plan does not work with postgres_query

Issue - State: open - Opened by mwisnicki about 1 month ago - 1 comment

#276 - Fixup CI

Pull Request - State: closed - Opened by carlopi about 2 months ago

#275 - apply patches

Pull Request - State: closed - Opened by Maxxen about 2 months ago - 1 comment

#273 - Misleading statement timeout error message

Issue - State: closed - Opened by leticiarina 2 months ago - 2 comments

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

Issue - State: open - Opened by sco-atolcd 3 months ago - 1 comment

#270 - IO Error: buffer_ptr not set in CheckHeader

Issue - State: closed - Opened by cobolbaby 4 months ago - 4 comments

#268 - postgres_conn_str does not support the `options` parameter.

Issue - State: closed - Opened by cobolbaby 4 months ago - 1 comment

#264 - Can't create table with geometry field

Issue - State: open - Opened by fnicastri 5 months ago - 10 comments

#123 - How to speed up queries with DuckDB connected to PostgreSQL DB using postgres_scanner?

Issue - State: open - Opened by sidroopdaska over 1 year ago - 11 comments

#100 - const pages_per_task parameter cause long query times on certain tables

Issue - State: closed - Opened by damian-petta over 1 year ago - 1 comment

#100 - const pages_per_task parameter cause long query times on certain tables

Issue - State: closed - Opened by damian-petta over 1 year ago - 1 comment

#99 - Expose pages_per_task as config parameter in postgres_scan

Pull Request - State: closed - Opened by damian-petta over 1 year ago - 1 comment

#99 - Expose pages_per_task as config parameter in postgres_scan

Pull Request - State: closed - Opened by damian-petta over 1 year ago - 1 comment

#98 - json_array_elements() throwing error when run from pg_scanner

Issue - State: closed - Opened by sudhirkenguva over 1 year ago - 1 comment

#98 - json_array_elements() throwing error when run from pg_scanner

Issue - State: closed - Opened by sudhirkenguva over 1 year ago - 1 comment

#97 - Meaning of "read into DuckDB tables"

Issue - State: closed - Opened by rinormaloku over 1 year ago - 3 comments

#97 - Meaning of "read into DuckDB tables"

Issue - State: closed - Opened by rinormaloku over 1 year ago - 3 comments

#96 - PG_ATTACH takes very long to execute

Issue - State: closed - Opened by dberardo-com almost 2 years ago - 1 comment

#96 - PG_ATTACH takes very long to execute

Issue - State: closed - Opened by dberardo-com almost 2 years ago - 1 comment

#95 - Fixes for upcoming Catalog API rework

Pull Request - State: closed - Opened by Mytherin almost 2 years ago

#95 - Fixes for upcoming Catalog API rework

Pull Request - State: closed - Opened by Mytherin almost 2 years ago

#94 - Postgres_scanner does not detect the correct number of dimensions of an array in postgresql

Issue - State: closed - Opened by HackettJP almost 2 years ago - 2 comments

#94 - Postgres_scanner does not detect the correct number of dimensions of an array in postgresql

Issue - State: closed - Opened by HackettJP almost 2 years ago - 2 comments

#93 - Support for array of macaddr

Issue - State: closed - Opened by kamilcglr almost 2 years ago - 2 comments

#93 - Support for array of macaddr

Issue - State: closed - Opened by kamilcglr almost 2 years ago - 2 comments

#92 - Postgres NUMERIC columns - overflowing values when inserting into duckdb's DECIMAL

Issue - State: closed - Opened by jhrcek almost 2 years ago - 4 comments

#92 - Postgres NUMERIC columns - overflowing values when inserting into duckdb's DECIMAL

Issue - State: closed - Opened by jhrcek almost 2 years ago - 4 comments

#91 - Postgres scanner does not attach partitioned tables

Issue - State: closed - Opened by dpprdan almost 2 years ago - 1 comment

#91 - Postgres scanner does not attach partitioned tables

Issue - State: closed - Opened by dpprdan almost 2 years ago - 1 comment

#90 - postgres_attach() error when connecting to read-only replica

Issue - State: closed - Opened by loicalleyne almost 2 years ago - 4 comments

#90 - postgres_attach() error when connecting to read-only replica

Issue - State: closed - Opened by loicalleyne almost 2 years ago - 4 comments

#89 - seg fault on select or attach to remote postgresql TEXT [] / VARCHAR [] arrays with more than 1 dimension

Issue - State: closed - Opened by HackettJP almost 2 years ago - 1 comment

#89 - seg fault on select or attach to remote postgresql TEXT [] / VARCHAR [] arrays with more than 1 dimension

Issue - State: closed - Opened by HackettJP almost 2 years ago - 1 comment

#88 - [Question / Feature Request] Updating the postgres connection string without re-scanning

Issue - State: closed - Opened by davidgovea almost 2 years ago - 1 comment

#88 - [Question / Feature Request] Updating the postgres connection string without re-scanning

Issue - State: closed - Opened by davidgovea almost 2 years ago - 1 comment

#87 - support passing a custom port

Issue - State: closed - Opened by dbist almost 2 years ago - 2 comments

#87 - support passing a custom port

Issue - State: closed - Opened by dbist almost 2 years ago - 2 comments

#86 - Fix enum array support

Pull Request - State: closed - Opened by gpsamson almost 2 years ago - 5 comments

#86 - Fix enum array support

Pull Request - State: closed - Opened by gpsamson almost 2 years ago - 5 comments

#85 - too many clients connected to PostgreSQL when using aggregate function

Issue - State: closed - Opened by SingleLyra almost 2 years ago - 2 comments

#85 - too many clients connected to PostgreSQL when using aggregate function

Issue - State: closed - Opened by SingleLyra almost 2 years ago - 2 comments

#84 - Request: make compatible with Clickhouse postgres interface

Issue - State: open - Opened by alanpaulkwan almost 2 years ago - 2 comments

#84 - Request: make compatible with Clickhouse postgres interface

Issue - State: open - Opened by alanpaulkwan almost 2 years ago - 2 comments

#83 - Safe unique ptr

Pull Request - State: closed - Opened by Tishj almost 2 years ago

#83 - Safe unique ptr

Pull Request - State: closed - Opened by Tishj almost 2 years ago

#82 - postgres_attach fails with SQL syntax error when postgres contains table with column of type "array of enum"

Issue - State: closed - Opened by jhrcek almost 2 years ago - 7 comments

#82 - postgres_attach fails with SQL syntax error when postgres contains table with column of type "array of enum"

Issue - State: closed - Opened by jhrcek almost 2 years ago - 7 comments

#81 - Support for querying views

Issue - State: closed - Opened by justbldwn almost 2 years ago - 8 comments

#81 - Support for querying views

Issue - State: closed - Opened by justbldwn almost 2 years ago - 8 comments

#80 - IO Error: Unable to read binary COPY data from Postgres:

Issue - State: closed - Opened by vimota almost 2 years ago - 3 comments

#80 - IO Error: Unable to read binary COPY data from Postgres:

Issue - State: closed - Opened by vimota almost 2 years ago - 3 comments

#79 - Binder Error: table "postgres_scan" has duplicate column name

Issue - State: closed - Opened by frafra almost 2 years ago - 4 comments

#79 - Binder Error: table "postgres_scan" has duplicate column name

Issue - State: closed - Opened by frafra almost 2 years ago - 4 comments

#78 - [Feature Request] Add possibility to run "low level" queries directly via psql driver

Issue - State: closed - Opened by dberardo-com almost 2 years ago - 2 comments

#78 - [Feature Request] Add possibility to run "low level" queries directly via psql driver

Issue - State: closed - Opened by dberardo-com almost 2 years ago - 2 comments

#77 - PostgreSQL array dimension detection fails for empty arrays

Issue - State: closed - Opened by hannes almost 2 years ago

#77 - PostgreSQL array dimension detection fails for empty arrays

Issue - State: closed - Opened by hannes almost 2 years ago

#76 - IO Error: Unsupported Postgres type daterange

Issue - State: closed - Opened by MondeSinxi about 2 years ago

#76 - IO Error: Unsupported Postgres type daterange

Issue - State: closed - Opened by MondeSinxi about 2 years ago

#75 - Simple connection to duckdb with postgres fails. Unsupported Postgres type ltree

Issue - State: closed - Opened by jerryheir about 2 years ago - 2 comments

#75 - Simple connection to duckdb with postgres fails. Unsupported Postgres type ltree

Issue - State: closed - Opened by jerryheir about 2 years ago - 2 comments

#74 - Connecting with `CALL postgres_attach` loads tables, but displays error

Issue - State: closed - Opened by MarkusSagen about 2 years ago - 1 comment

#74 - Connecting with `CALL postgres_attach` loads tables, but displays error

Issue - State: closed - Opened by MarkusSagen about 2 years ago - 1 comment

#73 - Write functionality

Issue - State: closed - Opened by adriangb about 2 years ago - 4 comments

#73 - Write functionality

Issue - State: closed - Opened by adriangb about 2 years ago - 4 comments

#72 - DuckDB postgres_attach potentially leaving connections open

Issue - State: closed - Opened by vimota about 2 years ago - 2 comments

#72 - DuckDB postgres_attach potentially leaving connections open

Issue - State: closed - Opened by vimota about 2 years ago - 2 comments

#71 - PostgreSQL User Defined Data Types not supported

Issue - State: closed - Opened by hilam about 2 years ago - 1 comment

#71 - PostgreSQL User Defined Data Types not supported

Issue - State: closed - Opened by hilam about 2 years ago - 1 comment

#70 - Fix selecting numeric

Pull Request - State: closed - Opened by papparapa about 2 years ago - 2 comments

#70 - Fix selecting numeric

Pull Request - State: closed - Opened by papparapa about 2 years ago - 2 comments

GitHub / duckdb/duckdb-postgres issues and pull requests