duckdb / duckdb/pg_duckdb

The duckdb.reset_ddb() function should remove all temporary DuckDB tables

Open
#295 0 comments 1 reaction 0 assignees View on GitHub
bug
Dominant language
C++
Stars
3.2k
Forks
204
PR merge metrics
No merged PRs in 30d

Description

In #281 the function `duckdb.reset_ddb()` was added, which recreates the in memory database. This has as a sideeffect that all temporary duckdb tables are lost. We should also remove the matching Postgres tables from the catalog in that case.

This is definitely not a critical bug. The `duckdb.reset_ddb()` function is mostly meant for debugging at this point. But I at least thought we should track that this is an issue. Especially since it's probably not too hard to fix.

Contributor guide

Open the contributing guide

Research direction

Start by reading the implementation of duckdb.reset_ddb() and the context from issue #281. Trace how temporary DuckDB tables are represented in the Postgres catalog. Done means resetting the in-memory database also removes the matching Postgres catalog tables.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp, postgres
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.