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/5851~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/5851
Choose a head ref
  • 2 commits
  • 1 file changed
  • 2 contributors

Commits on Nov 5, 2025

  1. doc: Improve description of RLS policies applied by command type. 

    On the CREATE POLICY page, the "Policies Applied by Command Type"
table was missing MERGE ... THEN DELETE and some of the policies
applied during INSERT ... ON CONFLICT and MERGE. Fix that, and try to
improve readability by listing the various MERGE cases separately,
rather than together with INSERT/UPDATE/DELETE. Mention COPY ... TO
along with SELECT, since it behaves in the same way. In addition,
document which policy violations cause errors to be thrown, and which
just cause rows to be silently ignored.

A paragraph above states that INSERT ... ON CONFLICT DO UPDATE only
checks the WITH CHECK expressions of INSERT policies for rows appended
to the relation by the INSERT path, which is incorrect - all rows
proposed for insertion are checked, regardless of whether they end up
being inserted. Fix that, and also mention that the same applies to
INSERT ... ON CONFLICT DO NOTHING.

In addition, in various other places on that page, clarify how the
different types of policy are applied to different commands, and
whether or not errors are thrown when policy checks do not pass.

Author: Dean Rasheed <[email protected]>
Reviewed-by: Viktor Holmberg <[email protected]>
Reviewed-by: Jian He <[email protected]>
Discussion: https://postgr.es/m/CAEZATCWqnfeChjK=n1V_dYZT4rt4mnq+ybf9c0qXDYTVMsy8pg@mail.gmail.com
    @deanrasheed
    deanrasheed authored and Commitfest Bot committed Nov 5, 2025
    Configuration menu
    Copy the full SHA
    d6c0cba View commit details
    Browse the repository at this point in the history

  2. [CF 5851] v4 - Docs and tests for RLS policies applied by command type 

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

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

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/CAEZATCUsiVwCHnAcy-H90exNcNNz35t8EF7PJtQvVEfsms_ytQ@mail.gmail.com
Author(s): Dean Rasheed
    Commitfest Bot committed Nov 5, 2025
    Configuration menu
    Copy the full SHA
    1437751 View commit details
    Browse the repository at this point in the history
Loading