canonical / canonical/postgresql-k8s-operator

Investigate if window functions need a change of ownership when rerelating and, if so, add code to do so

Open
#778 1 comment 0 reactions 0 assignees View on GitHub
bug
Dominant language
Python
Stars
15
Forks
33
Avg merge
1d 14h
Merged PRs (30d)
37

Description

Related to https://github.com/canonical/postgresql-k8s-operator/issues/772

PR https://github.com/canonical/postgresql-k8s-operator/pull/773 adds logic to change the ownership of procedures and aggregates, but not for window functions. This issue is to investigate if ownership needs changing and add logic to the lib, if so.

Contributor guide

Open the contributing guide

Research direction

Start by reviewing related issue 772 and PR 773, then inspect the existing lib logic for changing procedure and aggregate ownership. Determine from the PostgreSQL behavior whether window functions also require ownership changes when rerelating. Done means recording that determination and adding the corresponding library logic if required.

Written by the indexing model from the issue text.

Assessment

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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.