apache / apache/cloudberry

Feature Request: Support ALTER STORAGE SERVER ... OWNER TO ... and COMMENT ON STORAGE SERVER

Open
#1,299 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
1.4k
Forks
247
Avg merge
4d 3h
Merged PRs (30d)
39

Description

In the current version of Cloudberry, it is not possible to modify the owner of a `STORAGE SERVER` object or add a descriptive comment to it after it has been created. The corresponding DDL commands, `ALTER STORAGE SERVER ... OWNER TO ...` and `COMMENT ON STORAGE SERVER ...`, are not supported and result in a syntax error.

This limitation creates a gap in the database's object management capabilities. For most other database objects (like tables, functions, etc.), it is standard practice to allow modification of ownership and comments, which is crucial for database administration, security, and documentation.

Contributor guide

Open the contributing guide

Research direction

Start by tracing the parser and object-management paths for ALTER STORAGE SERVER ... OWNER TO ... and COMMENT ON STORAGE SERVER ..., since no implementation files or tests are named. Done means both statements parse successfully after creation and correctly update the storage server owner and comment, with coverage for each command.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, sql
Domain
databases
Issue type
Feature
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
38/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.