| 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:05:25 |
| Message-ID: | 20200206220525.GA31831@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 2020-Feb-06, Alvaro Herrera wrote:
> Also, I think we should patch the documentation like this, because this
> effect is not 100% obvious. (For example, if the partition strategy is
> identical in both referenced and referencing tables, you would wish that
> only the equivalent partition is truncated. However, I doubt this can
> be really implemented.)
And of course, I forgot to attach the file.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| truncate-docs.patch | text/x-diff | 740 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2020-02-06 22:12:48 | Re: BUG #16247: Cast error on integer |
| Previous Message | Alvaro Herrera | 2020-02-06 22:04:21 | Re: FK violation in partitioned table after truncating a referenced partition |