From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Michael Paquier <michael(at)paquier(dot)xyz> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: TRUNCATE tables referenced by FKs on partitioned tables |
Date: | 2018-07-11 22:59:16 |
Message-ID: | 20180711225916.domrlbkmukhrg6jg@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2018-Jul-11, Michael Paquier wrote:
> > alvherre=# truncate table prim, partfk;
> > ERROR: cannot truncate a table referenced in a foreign key constraint
> > DETALLE: Table "partfk" references "prim".
> > SUGERENCIA: Truncate table "partfk" at the same time, or use TRUNCATE ... CASCADE.
>
> Your first and second queries are the same :)
Yeah, C&P failure :-(
Anyway, this patch seems to fix it, and adds what I think is appropriate
test coverage.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Attachment | Content-Type | Size |
---|---|---|
0001-fix-truncate.patch | text/plain | 6.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Mai Peng | 2018-07-11 23:02:30 | Re: ERROR: cannot start subtransactions during a parallel operation |
Previous Message | Mai Peng | 2018-07-11 22:56:34 | Segfault logical replication PG 10.4 |