Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: cf/5992~1
Choose a base ref
...
head repository: postgresql-cfbot/postgresql
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: cf/5992
Choose a head ref
  • 2 commits
  • 5 files changed
  • 2 contributors

Commits on Sep 20, 2025

  1. Fix ALTER TABLE DROP EXPRESSION with inheritance hierarchy 

    --this works.
DROP TABLE IF EXISTS parent cascade;
CREATE TABLE parent (a int, d INT GENERATED ALWAYS AS (11) STORED);
CREATE TABLE child () INHERITS (parent);
ALTER TABLE parent ALTER COLUMN d DROP EXPRESSION;

-- so the below should also works.
DROP TABLE IF EXISTS parent cascade;
CREATE TABLE parent (a int, d INT GENERATED ALWAYS AS (11) STORED);
CREATE TABLE child () INHERITS (parent);
CREATE TABLE grandchild () INHERITS (child);
ALTER TABLE parent ALTER COLUMN d DROP EXPRESSION;

discussion: https://postgr.es/m/
    @jianhe-fun
    jianhe-fun authored and Commitfest Bot committed Sep 20, 2025
    Configuration menu
    Copy the full SHA
    b40f852 View commit details
    Browse the repository at this point in the history

  2. [CF 5992] v3 - Fix ALTER TABLE DROP EXPRESSION with ONLY option 

    This branch was automatically generated by a robot using patches from an
email thread registered at:

https://commitfest.postgresql.org/patch/5992

The branch will be overwritten each time a new patch version is posted to
the thread, and also periodically to check for bitrot caused by changes
on the master branch.

Patch(es): https://www.postgresql.org/message-id/CALdSSPigTFDUAsEmGtt3RdXYpbzWFpDcmwKasuxNDdXswDf19A@mail.gmail.com
Author(s): Jian He
    Commitfest Bot committed Sep 20, 2025
    Configuration menu
    Copy the full SHA
    7013f9b View commit details
    Browse the repository at this point in the history
Loading