Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
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/5768~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/5768
Choose a head ref
  • 2 commits
  • 10 files changed
  • 2 contributors

Commits on May 31, 2025

  1. ALTER DOMAIN ADD NOT NULL NOT VALID 

    we have NOT NULL NO VALID for table constraints, we can make domain have NOT
VALID not-null constraint too.

ALTER DOMAIN SET NOT NULL works similarly to its ALTER TABLE counterpart.  It
validates an existing invalid NOT NULL constraint and updates
pg_constraint.convalidated to true.

ALTER DOMAIN ADD NOT NULL will add a new, valid not-null constraint.  If the
domain already has an NOT VALID not-null constraint, the command will result in
an error.
If domain already have VALID not-null, add a NOT VALID is no-op.

\dD changes:
for domain's not null not valid constraint: now column "Nullable" will display as
"not null not valid".
domain valid not-null constraint works as before.

discussed: https://postgr.es/m/CACJufxGcABLgmH951SJkkihK+FW8KR3=odBhXEVCF9atQbur2Q@mail.gmail.com
    @jianhe-fun
    jianhe-fun authored and Commitfest Bot committed May 31, 2025
    Configuration menu
    Copy the full SHA
    bdb5cd4 View commit details
    Browse the repository at this point in the history

  2. [CF 5768] v2 - ALTER DOMAIN ADD NOT NULL NOT VALID 

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

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

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/CACJufxGBHDu8yOC-Gd7QpptBaB-AnRWWqeyZkBu9WLqvh3vrKQ@mail.gmail.com
Author(s): Jian He
    Commitfest Bot committed May 31, 2025
    Configuration menu
    Copy the full SHA
    ccd60e1 View commit details
    Browse the repository at this point in the history
Loading