On 11/19/24 08:11, Paul Foerster wrote:
Hi,
the PostgreSQL 15.9 release notes instruct to look out for especially detached
partitions with foreign key constraints. I'm in the process of updating our
databases from 15.8 to 15.9 now and found a case where the select statement
returns a constrai
Hi,
the PostgreSQL 15.9 release notes instruct to look out for especially detached
partitions with foreign key constraints. I'm in the process of updating our
databases from 15.8 to 15.9 now and found a case where the select statement
returns a constraint.
The release notes say nothing about w
Hi Alvaro,
> On 19 Nov 2024, at 17:34, Alvaro Herrera wrote:
>
> It doesn't really matter when you do it, because the constraint only
> gets broken by running DETACH with the old server code. You have
> already run the DETACH sometime in the past (that's how the constraint
> got broken), which
Hi Adrian,
> On 19 Nov 2024, at 17:17, Adrian Klaver wrote:
>
> Read this:
>
> https://www.postgresql.org/about/news/out-of-cycle-release-scheduled-for-november-21-2024-2958/
>
> and hold off awhile.
Thanks very much. I will.
Cheers,
Paul
Hi Tom,
> On 19 Nov 2024, at 17:25, Tom Lane wrote:
>
> Generally speaking, our release notes are addressed to someone who's
> already installed the update (or a later one).
Thank you for the advice.
Cheers,
Paul
Hi Paul,
On 2024-Nov-19, Paul Foerster wrote:
> the PostgreSQL 15.9 release notes instruct to look out for especially
> detached partitions with foreign key constraints. I'm in the process
> of updating our databases from 15.8 to 15.9 now and found a case where
> the select statement returns a co
Paul Foerster writes:
> the PostgreSQL 15.9 release notes instruct to look out for especially
> detached partitions with foreign key constraints. I'm in the process of
> updating our databases from 15.8 to 15.9 now and found a case where the
> select statement returns a constraint.
> The relea
