Re: BUG #18159: Database Integrity Concerns: Missing FK Constraint

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: rootcause000(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18159: Database Integrity Concerns: Missing FK Constraint
Date: 2023-10-17 01:09:47
Message-ID: 606b3a0f175d7cfcc497c5e377094a1af459ef34.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Amit Kapila 2023-10-17 04:20:52 Re: BUG #18155: Logical Apply Worker Timeout During TableSync Causes Either Stuckness or Data Loss
Previous Message Callahan, Drew 2023-10-16 23:16:31 Re: BUG #18155: Logical Apply Worker Timeout During TableSync Causes Either Stuckness or Data Loss