Re: pgsql: Fix FK checks of TRUNCATE involving partitioned tables

2018-07-14 Thread Alvaro Herrera
On 2018-Jul-14, Michael Paquier wrote: > On Thu, Jul 12, 2018 at 04:26:17PM +, Alvaro Herrera wrote: > > Fix FK checks of TRUNCATE involving partitioned tables > > > > Author: Álvaro Herrera > > Reviewed-by: Michael Paquiër > > Discussion: > > https://postgr.es/m/20180711000624.zmeizicibxe

Re: pgsql: Fix FK checks of TRUNCATE involving partitioned tables

2018-07-14 Thread Michael Paquier
On Thu, Jul 12, 2018 at 04:26:17PM +, Alvaro Herrera wrote: > Fix FK checks of TRUNCATE involving partitioned tables > > Author: Álvaro Herrera > Reviewed-by: Michael Paquiër > Discussion: https://postgr.es/m/20180711000624.zmeizicibxeehhsg@alvherre.pgsql Just a note, using 'ë' in the first

pgsql: Fix FK checks of TRUNCATE involving partitioned tables

2018-07-12 Thread Alvaro Herrera
Fix FK checks of TRUNCATE involving partitioned tables When truncating a table that is referenced by foreign keys in partitioned tables, the check to ensure the referencing table are also truncated spuriously failed. This is because it was relying on relhastriggers as a proxy for the table having

pgsql: Fix FK checks of TRUNCATE involving partitioned tables

2018-07-12 Thread Alvaro Herrera
Fix FK checks of TRUNCATE involving partitioned tables When truncating a table that is referenced by foreign keys in partitioned tables, the check to ensure the referencing table are also truncated spuriously failed. This is because it was relying on relhastriggers as a proxy for the table having