postgres_scanner
postgres_scanner copied to clipboard
duckdb
### What happens? In a transaction, when calling a procedure (via `postgres_execute`) after retrieving from a table there is the following error: ``` duckdb.duckdb.Error: Failed to execute query "CALL test()":...
I want to copy some data to a temporary table in postgres. When I do this using the duckdb api, the resulting table is not available directly: ``` CALL postgres_execute('postgres_db',...
my sql: ``` update gp.tenant_peacebird_biz.rst_ra_sku_org_detail a set compute_status='0' from tmp_distinct_order_id b where a.skc_order_id=b.skc_order_id and a.day_date = '2024-04-29' and a.is_deleted = '0'; ``` raise error: ``` ERROR: duckdb.duckdb.Error: Failed to execute...
### What happens? I'm trying to download and install the extension locally. When I load the extension, I get an incompatible metadata error message, even though I think I used...
### What happens? When connecting to our production database, which has hundreds of schemas, each with over a hundred tables, using the new ATTACH command takes much longer than the...
I took inspiration from https://duckdb.org/2022/09/30/postgres-scanner.html and setup a connection between DuckDB and our Supabase project. Simple queries, like the one listed below, take an average of 40s to complete. I...
The full table copy operation performed by the DuckDB PostgreSQL extension on partitioned tables, such as ``` SELECT * FROM pg.sch.tb a left join b on a.x=b.x where a.dt=current_date ```...
In the table query we get both tables, views, materialized views, partitioned tables and foreign tables. The views are then stored in the catalog as a TableCatalogEntry, which confuses `duckdb_tables()`...
### What happens? When I insert a result of a join containing some particular column configuration from duckdb to postgres, it ends in data not making it through to the...
### What happens? I calculate in duckdb , and then write back to gp, for example: ``` create table gp.public.test as select * from rst ``` this way, the table...