duckdb/pg_duckdb

Make ALTER TABLE ... SET SCHEMA work for duckdb tables

Open

#781 opened on May 9, 2025

View on GitHub
 (4 comments) (0 reactions) (2 assignees)C++ (183 forks)github user discovery
MotherDuckgood first issue

Repository metrics

Stars
 (3,125 stars)
PR merge metrics
 (PR metrics pending)

Description

Description

A few things to consider here:

  1. Altering schemas within the same default motherduck database
  2. Altering schemas within a single non-default (aka ddb$) motherduck database
  3. Altering schemas across motherduck databases

Related to #780 and #766

Contributor guide

Research direction
Study the current ALTER TABLE implementation in pg duckdb to understand how table schema changes are handled. Examine related issues #780 and #766 for context and required changes. Focus on the DuckDB catalog operations for schema alteration.
Tech stack
cpp
Domain
database
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
3
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-2 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
C++PostgreSQLDuckDB
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
35