MIME-Version: 1.0
References: <CAFCRh-8NwJd0jq6P=R3qhHyqU7hw0BTor3W0SvUcii24et+zAw@mail.gmail.com>
 <CANzqJaDbA1v95Dj+x7x_VXkxcfPY7SAMdVX7ADFAeZw8HQ0Diw@mail.gmail.com>
In-Reply-To: <CANzqJaDbA1v95Dj+x7x_VXkxcfPY7SAMdVX7ADFAeZw8HQ0Diw@mail.gmail.com>
From: Dominique Devienne <ddevienne@gmail.com>
Date: Fri, 5 Sep 2025 10:19:04 +0200
Message-ID: <CAFCRh-9n5RsGoJWXFqmqmOKxfA0WWQCVBt9gSMnyPz3G5DzCvg@mail.gmail.com>
Subject: Re: Latest patches break one of our unit-test, related to RLS
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general@postgresql.org
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAFCRh-9n5RsGoJWXFqmqmOKxfA0WWQCVBt9gSMnyPz3G5DzCvg%40mail.gmail.com>
Precedence: bulk

On Fri, Sep 5, 2025 at 1:10=E2=80=AFAM 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 md5=
sum of yesterday's schema dump is different from today's schema dump.  Puzz=
led, I ran "pg_dump --schema-only" twice in a row, but the md5sum was diffe=
rent.
> "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).