public inbox for [email protected]
help / color / mirror / Atom feedRe: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints
2+ messages / 2 participants
[nested] [flat]
* Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints
@ 2024-11-19 16:17 Adrian Klaver <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Adrian Klaver @ 2024-11-19 16:17 UTC (permalink / raw)
To: Paul Foerster <[email protected]>; pgsql-general list <[email protected]>
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 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.
Read this:
https://www.postgresql.org/about/news/out-of-cycle-release-scheduled-for-november-21-2024-2958/
and hold off awhile.
>
> Cheers
> Paul
>
--
Adrian Klaver
[email protected]
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints
@ 2024-11-19 19:08 Paul Foerster <[email protected]>
parent: Adrian Klaver <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Paul Foerster @ 2024-11-19 19:08 UTC (permalink / raw)
To: Adrian Klaver <[email protected]>; +Cc: pgsql-general list <[email protected]>
Hi Adrian,
> On 19 Nov 2024, at 17:17, Adrian Klaver <[email protected]> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-11-19 19:08 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:17 Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints Adrian Klaver <[email protected]>
2024-11-19 19:08 ` Paul Foerster <[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