Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints - Mailing list pgsql-general

From Tom Lane
Subject Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints
Date
Msg-id 3775604.1732033502@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints  (Paul Foerster <paul.foerster@gmail.com>)
Responses Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints
List pgsql-general
Paul Foerster <paul.foerster@gmail.com> 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
statementreturns a constraint. 

> The release notes say nothing about when to fix that using the generated add or drop statements.

Generally speaking, our release notes are addressed to someone who's
already installed the update (or a later one).

            regards, tom lane



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints
Next
From: Adrian Klaver
Date:
Subject: Re: Re : Credcheck extension