Horton

Re: Latest patches break one of our unit-test, related to RLS

Dominique Devienne <ddevienne@gmail.com>

View thread View on postgr.es
From: Dominique Devienne <ddevienne@gmail.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general@postgresql.org
Date: 2025-09-05T08:19:04Z
Lists: pgsql-general 
On Fri, Sep 5, 2025 at 1:10 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
> Dumb question: did you read the release notes?

Well, now I have. Carefully. Nothing stands out.
There's RLS mentioned, but for indexing only.
So no smoking gun. We'll have to investigate... :(

> In our case, 17.6 "pg_dump --schema-only" broke in the sense that the md5sum of yesterday's schema dump is different from today's schema dump.  Puzzled, I ran "pg_dump --schema-only" twice in a row, but the md5sum was different.
> "diff" showed why.  Searching the release notes showed me what changed.

Thanks for the heads up.
We don't depend on pg_dump at all.
We have our own COPY BINARY based custom backup/restore
to semi-structured SQLite DBs (part relational, part per-row COPY blobs).

Commits

  1. Amend recent fix for SIMILAR TO regex conversion.

  2. Fix conversion of SIMILAR TO regexes for character classes