Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Paul Foerster <paul(dot)foerster(at)gmail(dot)com>
Cc: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints
Date: 2024-11-19 16:25:02
Message-ID: 3775604.1732033502@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Paul Foerster <paul(dot)foerster(at)gmail(dot)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 statement returns 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-11-19 16:25:14 Re: Re : Credcheck extension
Previous Message Adrian Klaver 2024-11-19 16:17:16 Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints