Horton

Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION

Paul Foerster <paul.foerster@gmail.com>

View thread View on postgr.es
From: Paul Foerster <paul.foerster@gmail.com>
To: Adrian Klaver <adrian.klaver@aklaver.com>
Cc: pgsql-general list <pgsql-general@lists.postgresql.org>
Date: 2024-11-26T19:02:33Z
Lists: pgsql-general 
Hi Adrian,

> On 26 Nov 2024, at 17:56, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
> 
> Did you commit the statements?

Yes. I have autocommit on, the psql default.

> Are you using concurrent sessions to do this?

No. I do this in one session. 1. select, 2. drop, 3. add, 4. select.

> When you run the query again do you get the same two statements?

Yes. I can repeat the above 4 steps as much as I want. The result remains the same. I would have expected to have an empty result doing the final repeated select, but it shows exactly the same output.

Cheers,
Paul

Commits

  1. Fix broken-FK-detection query in release notes