| From: | Dominique Devienne <ddevienne(at)gmail(dot)com> |
|---|---|
| To: | Ron Johnson <ronljohnsonjr(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Latest patches break one of our unit-test, related to RLS |
| Date: | 2025-09-05 08:19:04 |
| Message-ID: | CAFCRh-9n5RsGoJWXFqmqmOKxfA0WWQCVBt9gSMnyPz3G5DzCvg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Sep 5, 2025 at 1:10 AM Ron Johnson <ronljohnsonjr(at)gmail(dot)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).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-09-05 12:19:00 | Re: Latest patches break one of our unit-test, related to RLS |
| Previous Message | Ron Johnson | 2025-09-04 23:21:07 | Re: Debugging query performance in postgres |