Re: BUG #18159: Database Integrity Concerns: Missing FK Constraint - Mailing list pgsql-bugs

From Laurenz Albe
Subject Re: BUG #18159: Database Integrity Concerns: Missing FK Constraint
Date
Msg-id 606b3a0f175d7cfcc497c5e377094a1af459ef34.camel@cybertec.at
Whole thread Raw
In response to BUG #18159: Database Integrity Concerns: Missing FK Constraint  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
On Mon, 2023-10-16 at 20:26 +0000, PG Bug reporting form wrote:
> Is there a possibility that during the vacuum process, FK constraints might
> be dropped and recreated for restructuring?

No, that cannot happen.

You must have lost your foreign key constraints some other way (somebody ran
ALTER TABLE).  There is no indication that this is a PostgreSQL bug.

Yours,
Laurenz Albe



pgsql-bugs by date:

Previous
From: "Callahan, Drew"
Date:
Subject: Re: BUG #18155: Logical Apply Worker Timeout During TableSync Causes Either Stuckness or Data Loss
Next
From: Amit Kapila
Date:
Subject: Re: BUG #18155: Logical Apply Worker Timeout During TableSync Causes Either Stuckness or Data Loss