Re: pgsql: Create foreign key triggers in partitioned tables too

2022-01-10 Thread Amit Langote
On Thu, Jan 6, 2022 at 7:46 AM Tom Lane wrote: > Alvaro Herrera writes: > > This also changes what tgisinternal means in some cases. Currently, > > it means either that the trigger is an internal implementation object > > of a foreign key constraint, or a "child" trigger on a partition > > clone

Re: pgsql: Create foreign key triggers in partitioned tables too

2022-01-05 Thread Tom Lane
Alvaro Herrera writes: > This also changes what tgisinternal means in some cases. Currently, > it means either that the trigger is an internal implementation object > of a foreign key constraint, or a "child" trigger on a partition > cloned from the trigger on the parent. This commit changes it

pgsql: Create foreign key triggers in partitioned tables too

2022-01-05 Thread Alvaro Herrera
Create foreign key triggers in partitioned tables too While user-defined triggers defined on a partitioned table have a catalog definition for both it and its partitions, internal triggers used by foreign keys defined on partitioned tables only have a catalog definition for its partitions. This c