| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | Jehan-Guillaume de Rorthais <jgdr(at)dalibo(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Another FK violation when referencing a multi-level partitioned table |
| Date: | 2020-02-06 17:21:55 |
| Message-ID: | 20200206172155.GA27899@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 2020-Feb-06, Michael Paquier wrote:
> On Thu, Feb 06, 2020 at 12:49:48AM +0100, Jehan-Guillaume de Rorthais wrote:
> > Please, find in attachment a proposal patch to fix this FK violation.
>
> Indeed. I would have expected the deletion of the referenced rows to
> happen as in your test. At quick glance, your fix looks right, but I
> need to study more this code. Alvaro, would you like to weigh in as
> the author of f56f8f8?
Sure, I'll have a look at this this afternoon.
Kindly do CC me when mentioning me in messages. I don't read every
mailing list message ...
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dan Hayes | 2020-02-06 17:46:04 | Re: BUG #16245: proj63 from rhel-7 repo depends on sqlite33, but is not available |
| Previous Message | PG Bug reporting form | 2020-02-06 15:13:06 | BUG #16246: Need compatible odbc driver to establish connectivity with SAP BOBJ 4.2 |