duckdblabs/postgres_scanner

Issues

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

  #78 opened 2 years ago by dberardo-com
  2

• Support for querying views

  #81 opened 2 years ago by justbldwn
  8

• postgres_attach() error when connecting to read-only replica

  #90 opened 2 years ago by loicalleyne
  4

• DuckDB postgres_attach potentially leaving connections open

  #72 opened 2 years ago by vimota
  2

• current_timestamp wrong when export to csv

  #64 opened 2 years ago by wonb168
  1

• ctid cause scan partition sub-table failure

  #60 opened 2 years ago by wonb168
  1

• can't scan partitional son table

  #58 opened 2 years ago by wonb168
  2

• Meaning of "read into DuckDB tables"

  #97 opened 2 years ago by rinormaloku
  3

• Postgres scanner does not attach partitioned tables

  #91 opened 2 years ago by dpprdan
  1

• Special handling for timestamp and timestamptz 'infinity'

  #102 opened 2 years ago by Loreith
  2

• PG_ATTACH takes very long to execute

  #96 opened 2 years ago by dberardo-com
  1

• Postgres_scanner does not detect the correct number of dimensions of an array in postgresql

  #94 opened 2 years ago by HackettJP
  2

• Support for array of macaddr

  #93 opened 2 years ago by kamilcglr
  2

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

  #92 opened 2 years ago by jhrcek
  4

• too many clients connected to PostgreSQL when using aggregate function

  #85 opened 2 years ago by SingleLyra
  2

• Binder Error: table "postgres_scan" has duplicate column name

  #79 opened 2 years ago by frafra
  4

• Write functionality

  #73 opened 2 years ago by adriangb
  4

• Floating point exception (core dumped)

  #69 opened 2 years ago by davetapley
  3

• Filtering by char column doesn't work correctly in Postgres_scanner

  #68 opened 2 years ago by osawyerr
  1

• const pages_per_task parameter cause long query times on certain tables

  #100 opened 2 years ago by damian-petta
  1

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

  #82 opened 2 years ago by jhrcek
  7

• Views do not have "ctid"

  #101 opened 2 years ago by frafra
  1

• json_array_elements() throwing error when run from pg_scanner

  #98 opened 2 years ago by sudhirkenguva
  1

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

  #89 opened 3 years ago by HackettJP
  1

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

  #88 opened 3 years ago by davidgovea
  1

• support passing a custom port

  #87 opened 3 years ago by dbist
  2

• Request: make compatible with Clickhouse postgres interface

  #84 opened 3 years ago by alanpaulkwan
  2

• IO Error: Unable to read binary COPY data from Postgres:

  #80 opened 3 years ago by vimota
  3

• IO Error: Unsupported Postgres type tsvector

  #45 opened 3 years ago by vimota-pinched
  5

• Simple connection to duckdb with postgres fails. Unsupported Postgres type ltree

  #75 opened 3 years ago by jerryheir
  2

• IO Error: Unsupported Postgres type daterange

  #76 opened 3 years ago by MondeSinxi
  0

• PostgreSQL array dimension detection fails for empty arrays

  #77 opened 3 years ago by hannes
  0

• Postgres Scanner support of Table Dee/Dum

  #65 opened 3 years ago by benjiman
  1

• PostgreSQL User Defined Data Types not supported

  #71 opened 3 years ago by hilam
  1

• postgres_scan error with enums with multiple schemas

  #63 opened 3 years ago by akornienko
  0

• Do not return the column instead of raising an exception

  #57 opened 3 years ago by marwanhazemblnk
  0

• Connecting with `CALL postgres_attach` loads tables, but displays error

  #74 opened 3 years ago by MarkusSagen
  1

• Indefinite hang with Python module

  #67 opened 3 years ago by davetapley
  1

• Unsupported Postgres type jsonb

  #62 opened 3 years ago by akornienko
  2

• why scan partition table error?

  #56 opened 3 years ago by wonb168
  2

• postgres_scan can scan partiton table?and more, can scan a sql query?

  #55 opened 3 years ago by wonb168
  1

• pgconfigure: line 9: ./configure: No such file or directory

  #52 opened 3 years ago by wonb168
  2

• InvalidInputException: Invalid Input Error: malformed JSON

  #53 opened 3 years ago by wonb168
  1

• can scan postgre's function?

  #41 opened 3 years ago by wonb168
  1

• postgres_scanner.duckdb_extension: undefined symbol: _ZN6duckdb28SimpleNamedParameterFunction8ToStringEv

  #44 opened 3 years ago by wonb168
  9

• INTERNAL Error: Assertion triggered in file "/root/postgres_scanner/duckdb/src/common/types/vector.cpp" on line 1371: vector.GetType().InternalType() == PhysicalType::VARCHAR

  #49 opened 3 years ago by wonb168
  1

• CMake Error during compiling

  #50 opened 3 years ago by SingleLyra
  1

• memory corruption

  #47 opened 3 years ago by wonb168
  7

• how to build pip package？

  #40 opened 3 years ago by wonb168
  1

• How to load only some of the tables from PostgreSQL?

  #39 opened 3 years ago by SingleLyra
  4