public inbox for [email protected]  

help / color / mirror / Atom feed

PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints
2+ messages / 2 participants
[nested] [flat]

* PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints
@ 2024-11-19 16:11  Paul Foerster <[email protected]>
  0 siblings, 1 reply; 2+ messages in thread

From: Paul Foerster @ 2024-11-19 16:11 UTC (permalink / raw)
  To: pgsql-general list <[email protected]>

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 when to fix that using the generated add or drop statements.

Do I want/need to do that before or after I exchange the software? And if it is to be done on a particular of the two releases, why is that?

https://www.postgresql.org/docs/15/release-15-9.html
Section E.1.2, changelog entry 5.

Any insight would be highly appreciated. Thanks in advance.

Cheers
Paul





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints
@ 2024-11-19 16:25  Tom Lane <[email protected]>
  parent: Paul Foerster <[email protected]>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2024-11-19 16:25 UTC (permalink / raw)
  To: Paul Foerster <[email protected]>; +Cc: pgsql-general list <[email protected]>

Paul Foerster <[email protected]> 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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2024-11-19 16:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-19 16:11 PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints Paul Foerster <[email protected]>
2024-11-19 16:25 ` Tom Lane <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox