Re: FK violation in partitioned table after truncating a referenced partition

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: FK violation in partitioned table after truncating a referenced partition
Date: 2020-02-06 22:04:21
Message-ID: 20200206220421.GA31713@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2020-Feb-06, Alvaro Herrera wrote:

> I do wonder how do other RDBMSs behave.

I think this is relevant,
https://docs.oracle.com/database/121/VLDBG/GUID-FEAAC43A-1066-4697-8474-863181FE4F38.htm
but offers no useful guidance.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Alvaro Herrera 2020-02-06 22:05:25 Re: FK violation in partitioned table after truncating a referenced partition
Previous Message Alvaro Herrera 2020-02-06 22:00:05 Re: FK violation in partitioned table after truncating a referenced partition