Request a Demo
Home   >   mailing lists

Re: Latest patches break one of our unit-test, related to RLS - Mailing list pgsql-general

From Dominique Devienne
Subject Re: Latest patches break one of our unit-test, related to RLS
Date
Msg-id CAFCRh-9n5RsGoJWXFqmqmOKxfA0WWQCVBt9gSMnyPz3G5DzCvg@mail.gmail.com
Whole thread Raw
In response to Latest patches break one of our unit-test, related to RLS  (Dominique Devienne <ddevienne@gmail.com>)
List pgsql-general
Tree view 
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
fromtoday'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).

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Debugging query performance in postgres
Next
From: Laurenz Albe
Date:
Subject: Re: Latest patches break one of our unit-test, related to RLS