<entry>The table this trigger is on</entry>

</row>

<row>

<entry><structfield>tgparentid</structfield></entry>

<entry><type>oid</type></entry>

<entry><literal><link linkend="catalog-pg-trigger"><structname>pg_trigger</structname></link>.oid</literal></entry>

<entry>

Parent trigger that this trigger is cloned from, zero if not a clone;

this happens when partitions are created or attached to a partitioned

table.

</entry>

</row>

<row>

<entry><structfield>tgname</structfield></entry>

<entry><type>name</type></entry>

MemoryContextDelete(cxt);

}

/*

* isPartitionTrigger

*Subroutine for CloneRowTriggersToPartition: determine whether

*the given trigger has been cloned from another one.

*

* We use pg_depend as a proxy for this, since we don't have any direct

* evidence. This is an ugly hack to cope with a catalog deficiency.

* Keep away from children. Do not stare with naked eyes. Do not propagate.

*/

static bool

isPartitionTrigger(Oid trigger_oid)

{

Relationpg_depend;

ScanKeyData key[2];

SysScanDesc scan;

HeapTupletup;

boolfound = false;

pg_depend = table_open(DependRelationId, AccessShareLock);

ScanKeyInit(&key[0], Anum_pg_depend_classid,

BTEqualStrategyNumber,

F_OIDEQ,

ObjectIdGetDatum(TriggerRelationId));

ScanKeyInit(&key[1], Anum_pg_depend_objid,

BTEqualStrategyNumber,

F_OIDEQ,

ObjectIdGetDatum(trigger_oid));

scan = systable_beginscan(pg_depend, DependDependerIndexId,

true, NULL, 2, key);

while ((tup = systable_getnext(scan)) != NULL)

{

Form_pg_depend dep = (Form_pg_depend) GETSTRUCT(tup);

if (dep->refclassid == TriggerRelationId)

{

found = true;

break;

}

}

systable_endscan(scan);

table_close(pg_depend, AccessShareLock);

return found;

}

/*

* CloneRowTriggersToPartition

*subroutine for ATExecAttachPartition/DefineRelation to create row

/*

* Internal triggers require careful examination. Ideally, we don't

* clone them.

*

* However, if our parent is a partitioned relation, there might be

* internal triggers that need cloning. In that case, we must skip

* clone it if the trigger on parent depends on another trigger.

* clone them. However, if our parent is itself a partition, there

* might be internal triggers that must not be skipped; for example,

* triggers on our parent that are in turn clones from its parent (our

* grandparent) are marked internal, yet they are to be cloned.

*

* Note we dare not verify that the other trigger belongs to an

* ancestor relation of our parent, because that creates deadlock

* opportunities.

*/

if (trigForm->tgisinternal &&

(!parent->rd_rel->relispartition ||

!isPartitionTrigger(trigForm->oid)))

!OidIsValid(trigForm->tgparentid)))

continue;

/*

values[Anum_pg_trigger_oid-1]=ObjectIdGetDatum(trigoid);

values[Anum_pg_trigger_tgrelid-1]=ObjectIdGetDatum(RelationGetRelid(rel));

values[Anum_pg_trigger_tgparentid-1]=ObjectIdGetDatum(parentTriggerOid);

values[Anum_pg_trigger_tgname-1]=DirectFunctionCall1(namein,

CStringGetDatum(trigname));

values[Anum_pg_trigger_tgfoid-1]=ObjectIdGetDatum(funcoid);

{

Oidoid;/* oid */

Oidtgrelid;/* relation trigger is attached to */

Oidtgparentid;/* OID of parent trigger, if any */

NameDatatgname;/* trigger's name */

Oidtgfoid;/* OID of function to be called */

int16tgtype;/* BEFORE/AFTER/INSTEAD, UPDATE/DELETE/INSERT,

timestamptz_tbl|f

timetz_tbl|f

tmp|f

trigger_parted|t

trigger_parted_p1|t

trigger_parted_p1_1|t

varchar_tbl|f

view_base_table|t

-- restore normal output mode

drop function dump_insert();

drop function dump_update();

drop function dump_delete();

-- Leave around some objects for other tests

create table trigger_parted (a int primary key) partition by list (a);

create function trigger_parted_trigfunc() returns trigger language plpgsql as

$$ begin end; $$;

create trigger aft_row after insert or update on trigger_parted

for each row execute function trigger_parted_trigfunc();

create table trigger_parted_p1 partition of trigger_parted for values in (1)

partition by list (a);

create table trigger_parted_p1_1 partition of trigger_parted_p1 for values in (1);

dropfunction dump_insert();

dropfunction dump_update();

dropfunction dump_delete();

createtabletrigger_parted (aintprimary key) partition by list (a);

createfunctiontrigger_parted_trigfunc() returns trigger language plpgsqlas

$$begin end; $$;

createtriggeraft_row after insertorupdateon trigger_parted

for each row execute function trigger_parted_trigfunc();

createtabletrigger_parted_p1 partition of trigger_parted forvaluesin (1)

partition by list (a);

createtabletrigger_parted_p1_1 partition of trigger_parted_p1 forvaluesin (1);