PostgreSQL Source Code git master
Loading...
Searching...
No Matches
trigger.c
Go to the documentation of this file.
1/*-------------------------------------------------------------------------
2 *
3 * trigger.c
4 * PostgreSQL TRIGGERs support code.
5 *
6 * Portions Copyright (c) 1996-2026, PostgreSQL Global Development Group
7 * Portions Copyright (c) 1994, Regents of the University of California
8 *
9 * IDENTIFICATION
10 * src/backend/commands/trigger.c
11 *
12 *-------------------------------------------------------------------------
13 */
14#include "postgres.h"
15
16#include "access/genam.h"
17#include "access/htup_details.h"
18#include "access/relation.h"
19#include "access/sysattr.h"
20#include "access/table.h"
21#include "access/tableam.h"
22#include "access/tupconvert.h"
23#include "access/xact.h"
24#include "catalog/catalog.h"
25#include "catalog/dependency.h"
26#include "catalog/indexing.h"
28#include "catalog/partition.h"
30#include "catalog/pg_inherits.h"
31#include "catalog/pg_proc.h"
32#include "catalog/pg_trigger.h"
33#include "catalog/pg_type.h"
34#include "commands/trigger.h"
35#include "executor/executor.h"
36#include "executor/instrument.h"
37#include "miscadmin.h"
38#include "nodes/bitmapset.h"
39#include "nodes/makefuncs.h"
40#include "optimizer/optimizer.h"
41#include "parser/parse_clause.h"
43#include "parser/parse_func.h"
46#include "pgstat.h"
49#include "storage/lmgr.h"
50#include "utils/acl.h"
51#include "utils/builtins.h"
52#include "utils/fmgroids.h"
53#include "utils/guc_hooks.h"
54#include "utils/inval.h"
55#include "utils/lsyscache.h"
56#include "utils/memutils.h"
57#include "utils/plancache.h"
58#include "utils/rel.h"
59#include "utils/snapmgr.h"
60#include "utils/syscache.h"
61#include "utils/tuplestore.h"
62
63
64/* GUC variables */
66
67/* How many levels deep into trigger execution are we? */
68static int MyTriggerDepth = 0;
69
70/* Local function prototypes */
72 HeapTuple trigtup, const char *newname,
73 const char *expected_name);
75 Oid parentTriggerOid, const char *newname,
76 const char *expected_name);
77static void SetTriggerFlags(TriggerDesc *trigdesc, Trigger *trigger);
78static bool GetTupleForTrigger(EState *estate,
79 EPQState *epqstate,
81 ItemPointer tid,
82 LockTupleMode lockmode,
84 bool do_epq_recheck,
88static bool TriggerEnabled(EState *estate, ResultRelInfo *relinfo,
93 int tgindx,
94 FmgrInfo *finfo,
100 int event, bool row_trigger,
103 TransitionCaptureState *transition_capture,
105static void AfterTriggerEnlargeQueryState(void);
106static bool before_stmt_triggers_fired(Oid relid, CmdType cmdType);
108
109
110/*
111 * Create a trigger. Returns the address of the created trigger.
112 *
113 * queryString is the source text of the CREATE TRIGGER command.
114 * This must be supplied if a whenClause is specified, else it can be NULL.
115 *
116 * relOid, if nonzero, is the relation on which the trigger should be
117 * created. If zero, the name provided in the statement will be looked up.
118 *
119 * refRelOid, if nonzero, is the relation to which the constraint trigger
120 * refers. If zero, the constraint relation name provided in the statement
121 * will be looked up as needed.
122 *
123 * constraintOid, if nonzero, says that this trigger is being created
124 * internally to implement that constraint. A suitable pg_depend entry will
125 * be made to link the trigger to that constraint. constraintOid is zero when
126 * executing a user-entered CREATE TRIGGER command. (For CREATE CONSTRAINT
127 * TRIGGER, we build a pg_constraint entry internally.)
128 *
129 * indexOid, if nonzero, is the OID of an index associated with the constraint.
130 * We do nothing with this except store it into pg_trigger.tgconstrindid;
131 * but when creating a trigger for a deferrable unique constraint on a
132 * partitioned table, its children are looked up. Note we don't cope with
133 * invalid indexes in that case.
134 *
135 * funcoid, if nonzero, is the OID of the function to invoke. When this is
136 * given, stmt->funcname is ignored.
137 *
138 * parentTriggerOid, if nonzero, is a trigger that begets this one; so that
139 * if that trigger is dropped, this one should be too. There are two cases
140 * when a nonzero value is passed for this: 1) when this function recurses to
141 * create the trigger on partitions, 2) when creating child foreign key
142 * triggers; see CreateFKCheckTrigger() and createForeignKeyActionTriggers().
143 *
144 * If whenClause is passed, it is an already-transformed expression for
145 * WHEN. In this case, we ignore any that may come in stmt->whenClause.
146 *
147 * If isInternal is true then this is an internally-generated trigger.
148 * This argument sets the tgisinternal field of the pg_trigger entry, and
149 * if true causes us to modify the given trigger name to ensure uniqueness.
150 *
151 * When isInternal is not true we require ACL_TRIGGER permissions on the
152 * relation, as well as ACL_EXECUTE on the trigger function. For internal
153 * triggers the caller must apply any required permission checks.
154 *
155 * When called on partitioned tables, this function recurses to create the
156 * trigger on all the partitions, except if isInternal is true, in which
157 * case caller is expected to execute recursion on its own. in_partition
158 * indicates such a recursive call; outside callers should pass "false"
159 * (but see CloneRowTriggersToPartition).
160 */
162CreateTrigger(const CreateTrigStmt *stmt, const char *queryString,
163 Oid relOid, Oid refRelOid, Oid constraintOid, Oid indexOid,
164 Oid funcoid, Oid parentTriggerOid, Node *whenClause,
165 bool isInternal, bool in_partition)
166{
167 return
168 CreateTriggerFiringOn(stmt, queryString, relOid, refRelOid,
169 constraintOid, indexOid, funcoid,
170 parentTriggerOid, whenClause, isInternal,
172}
173
174/*
175 * Like the above; additionally the firing condition
176 * (always/origin/replica/disabled) can be specified.
177 */
179CreateTriggerFiringOn(const CreateTrigStmt *stmt, const char *queryString,
182 Node *whenClause, bool isInternal, bool in_partition,
184{
185 int16 tgtype;
186 int ncolumns;
187 int16 *columns;
188 int2vector *tgattr;
190 char *qual;
192 bool nulls[Natts_pg_trigger];
193 Relation rel;
197 HeapTuple tuple = NULL;
201 char *trigname;
205 char *oldtablename = NULL;
206 char *newtablename = NULL;
208 bool trigger_exists = false;
210 bool existing_isInternal = false;
211 bool existing_isClone = false;
212
213 if (OidIsValid(relOid))
214 rel = table_open(relOid, ShareRowExclusiveLock);
215 else
216 rel = table_openrv(stmt->relation, ShareRowExclusiveLock);
217
218 /*
219 * Triggers must be on tables or views, and there are additional
220 * relation-type-specific restrictions.
221 */
222 if (rel->rd_rel->relkind == RELKIND_RELATION)
223 {
224 /* Tables can't have INSTEAD OF triggers */
225 if (stmt->timing != TRIGGER_TYPE_BEFORE &&
226 stmt->timing != TRIGGER_TYPE_AFTER)
229 errmsg("\"%s\" is a table",
231 errdetail("Tables cannot have INSTEAD OF triggers.")));
232 }
233 else if (rel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE)
234 {
235 /* Partitioned tables can't have INSTEAD OF triggers */
236 if (stmt->timing != TRIGGER_TYPE_BEFORE &&
237 stmt->timing != TRIGGER_TYPE_AFTER)
240 errmsg("\"%s\" is a table",
242 errdetail("Tables cannot have INSTEAD OF triggers.")));
243
244 /*
245 * FOR EACH ROW triggers have further restrictions
246 */
247 if (stmt->row)
248 {
249 /*
250 * Disallow use of transition tables.
251 *
252 * Note that we have another restriction about transition tables
253 * in partitions; search for 'has_superclass' below for an
254 * explanation. The check here is just to protect from the fact
255 * that if we allowed it here, the creation would succeed for a
256 * partitioned table with no partitions, but would be blocked by
257 * the other restriction when the first partition was created,
258 * which is very unfriendly behavior.
259 */
260 if (stmt->transitionRels != NIL)
263 errmsg("\"%s\" is a partitioned table",
265 errdetail("ROW triggers with transition tables are not supported on partitioned tables.")));
266 }
267 }
268 else if (rel->rd_rel->relkind == RELKIND_VIEW)
269 {
270 /*
271 * Views can have INSTEAD OF triggers (which we check below are
272 * row-level), or statement-level BEFORE/AFTER triggers.
273 */
274 if (stmt->timing != TRIGGER_TYPE_INSTEAD && stmt->row)
277 errmsg("\"%s\" is a view",
279 errdetail("Views cannot have row-level BEFORE or AFTER triggers.")));
280 /* Disallow TRUNCATE triggers on VIEWs */
281 if (TRIGGER_FOR_TRUNCATE(stmt->events))
284 errmsg("\"%s\" is a view",
286 errdetail("Views cannot have TRUNCATE triggers.")));
287 }
288 else if (rel->rd_rel->relkind == RELKIND_FOREIGN_TABLE)
289 {
290 if (stmt->timing != TRIGGER_TYPE_BEFORE &&
291 stmt->timing != TRIGGER_TYPE_AFTER)
294 errmsg("\"%s\" is a foreign table",
296 errdetail("Foreign tables cannot have INSTEAD OF triggers.")));
297
298 /*
299 * We disallow constraint triggers to protect the assumption that
300 * triggers on FKs can't be deferred. See notes with AfterTriggers
301 * data structures, below.
302 */
303 if (stmt->isconstraint)
306 errmsg("\"%s\" is a foreign table",
308 errdetail("Foreign tables cannot have constraint triggers.")));
309 }
310 else
313 errmsg("relation \"%s\" cannot have triggers",
316
320 errmsg("permission denied: \"%s\" is a system catalog",
322
323 if (stmt->isconstraint)
324 {
325 /*
326 * We must take a lock on the target relation to protect against
327 * concurrent drop. It's not clear that AccessShareLock is strong
328 * enough, but we certainly need at least that much... otherwise, we
329 * might end up creating a pg_constraint entry referencing a
330 * nonexistent table.
331 */
333 {
336 }
337 else if (stmt->constrrel != NULL)
339 false);
340 }
341
342 /* permission checks */
343 if (!isInternal)
344 {
347 if (aclresult != ACLCHECK_OK)
350
352 {
355 if (aclresult != ACLCHECK_OK)
358 }
359 }
360
361 /*
362 * When called on a partitioned table to create a FOR EACH ROW trigger
363 * that's not internal, we create one trigger for each partition, too.
364 *
365 * For that, we'd better hold lock on all of them ahead of time.
366 */
367 partition_recurse = !isInternal && stmt->row &&
368 rel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE;
372
373 /* Compute tgtype */
374 TRIGGER_CLEAR_TYPE(tgtype);
375 if (stmt->row)
376 TRIGGER_SETT_ROW(tgtype);
377 tgtype |= stmt->timing;
378 tgtype |= stmt->events;
379
380 /* Disallow ROW-level TRUNCATE triggers */
381 if (TRIGGER_FOR_ROW(tgtype) && TRIGGER_FOR_TRUNCATE(tgtype))
384 errmsg("TRUNCATE FOR EACH ROW triggers are not supported")));
385
386 /* INSTEAD triggers must be row-level, and can't have WHEN or columns */
387 if (TRIGGER_FOR_INSTEAD(tgtype))
388 {
389 if (!TRIGGER_FOR_ROW(tgtype))
392 errmsg("INSTEAD OF triggers must be FOR EACH ROW")));
393 if (stmt->whenClause)
396 errmsg("INSTEAD OF triggers cannot have WHEN conditions")));
397 if (stmt->columns != NIL)
400 errmsg("INSTEAD OF triggers cannot have column lists")));
401 }
402
403 /*
404 * We don't yet support naming ROW transition variables, but the parser
405 * recognizes the syntax so we can give a nicer message here.
406 *
407 * Per standard, REFERENCING TABLE names are only allowed on AFTER
408 * triggers. Per standard, REFERENCING ROW names are not allowed with FOR
409 * EACH STATEMENT. Per standard, each OLD/NEW, ROW/TABLE permutation is
410 * only allowed once. Per standard, OLD may not be specified when
411 * creating a trigger only for INSERT, and NEW may not be specified when
412 * creating a trigger only for DELETE.
413 *
414 * Notice that the standard allows an AFTER ... FOR EACH ROW trigger to
415 * reference both ROW and TABLE transition data.
416 */
417 if (stmt->transitionRels != NIL)
418 {
419 List *varList = stmt->transitionRels;
420 ListCell *lc;
421
422 foreach(lc, varList)
423 {
425
426 if (!(tt->isTable))
429 errmsg("ROW variable naming in the REFERENCING clause is not supported"),
430 errhint("Use OLD TABLE or NEW TABLE for naming transition tables.")));
431
432 /*
433 * Because of the above test, we omit further ROW-related testing
434 * below. If we later allow naming OLD and NEW ROW variables,
435 * adjustments will be needed below.
436 */
437
438 if (rel->rd_rel->relkind == RELKIND_FOREIGN_TABLE)
441 errmsg("\"%s\" is a foreign table",
443 errdetail("Triggers on foreign tables cannot have transition tables.")));
444
445 if (rel->rd_rel->relkind == RELKIND_VIEW)
448 errmsg("\"%s\" is a view",
450 errdetail("Triggers on views cannot have transition tables.")));
451
452 /*
453 * We currently don't allow row-level triggers with transition
454 * tables on partition or inheritance children. Such triggers
455 * would somehow need to see tuples converted to the format of the
456 * table they're attached to, and it's not clear which subset of
457 * tuples each child should see. See also the prohibitions in
458 * ATExecAttachPartition() and ATExecAddInherit().
459 */
460 if (TRIGGER_FOR_ROW(tgtype) && has_superclass(rel->rd_id))
461 {
462 /* Use appropriate error message. */
463 if (rel->rd_rel->relispartition)
466 errmsg("ROW triggers with transition tables are not supported on partitions")));
467 else
470 errmsg("ROW triggers with transition tables are not supported on inheritance children")));
471 }
472
473 if (stmt->timing != TRIGGER_TYPE_AFTER)
476 errmsg("transition table name can only be specified for an AFTER trigger")));
477
478 if (TRIGGER_FOR_TRUNCATE(tgtype))
481 errmsg("TRUNCATE triggers with transition tables are not supported")));
482
483 /*
484 * We currently don't allow multi-event triggers ("INSERT OR
485 * UPDATE") with transition tables, because it's not clear how to
486 * handle INSERT ... ON CONFLICT statements which can fire both
487 * INSERT and UPDATE triggers. We show the inserted tuples to
488 * INSERT triggers and the updated tuples to UPDATE triggers, but
489 * it's not yet clear what INSERT OR UPDATE trigger should see.
490 * This restriction could be lifted if we can decide on the right
491 * semantics in a later release.
492 */
493 if (((TRIGGER_FOR_INSERT(tgtype) ? 1 : 0) +
494 (TRIGGER_FOR_UPDATE(tgtype) ? 1 : 0) +
495 (TRIGGER_FOR_DELETE(tgtype) ? 1 : 0)) != 1)
498 errmsg("transition tables cannot be specified for triggers with more than one event")));
499
500 /*
501 * We currently don't allow column-specific triggers with
502 * transition tables. Per spec, that seems to require
503 * accumulating separate transition tables for each combination of
504 * columns, which is a lot of work for a rather marginal feature.
505 */
506 if (stmt->columns != NIL)
509 errmsg("transition tables cannot be specified for triggers with column lists")));
510
511 /*
512 * We disallow constraint triggers with transition tables, to
513 * protect the assumption that such triggers can't be deferred.
514 * See notes with AfterTriggers data structures, below.
515 *
516 * Currently this is enforced by the grammar, so just Assert here.
517 */
518 Assert(!stmt->isconstraint);
519
520 if (tt->isNew)
521 {
522 if (!(TRIGGER_FOR_INSERT(tgtype) ||
523 TRIGGER_FOR_UPDATE(tgtype)))
526 errmsg("NEW TABLE can only be specified for an INSERT or UPDATE trigger")));
527
528 if (newtablename != NULL)
531 errmsg("NEW TABLE cannot be specified multiple times")));
532
533 newtablename = tt->name;
534 }
535 else
536 {
537 if (!(TRIGGER_FOR_DELETE(tgtype) ||
538 TRIGGER_FOR_UPDATE(tgtype)))
541 errmsg("OLD TABLE can only be specified for a DELETE or UPDATE trigger")));
542
543 if (oldtablename != NULL)
546 errmsg("OLD TABLE cannot be specified multiple times")));
547
548 oldtablename = tt->name;
549 }
550 }
551
552 if (newtablename != NULL && oldtablename != NULL &&
556 errmsg("OLD TABLE name and NEW TABLE name cannot be the same")));
557 }
558
559 /*
560 * Parse the WHEN clause, if any and we weren't passed an already
561 * transformed one.
562 *
563 * Note that as a side effect, we fill whenRtable when parsing. If we got
564 * an already parsed clause, this does not occur, which is what we want --
565 * no point in adding redundant dependencies below.
566 */
567 if (!whenClause && stmt->whenClause)
568 {
569 ParseState *pstate;
571 List *varList;
572 ListCell *lc;
573
574 /* Set up a pstate to parse with */
575 pstate = make_parsestate(NULL);
576 pstate->p_sourcetext = queryString;
577
578 /*
579 * Set up nsitems for OLD and NEW references.
580 *
581 * 'OLD' must always have varno equal to 1 and 'NEW' equal to 2.
582 */
585 makeAlias("old", NIL),
586 false, false);
587 addNSItemToQuery(pstate, nsitem, false, true, true);
590 makeAlias("new", NIL),
591 false, false);
592 addNSItemToQuery(pstate, nsitem, false, true, true);
593
594 /* Transform expression. Copy to be sure we don't modify original */
595 whenClause = transformWhereClause(pstate,
596 copyObject(stmt->whenClause),
598 "WHEN");
599 /* we have to fix its collations too */
600 assign_expr_collations(pstate, whenClause);
601
602 /*
603 * Check for disallowed references to OLD/NEW.
604 *
605 * NB: pull_var_clause is okay here only because we don't allow
606 * subselects in WHEN clauses; it would fail to examine the contents
607 * of subselects.
608 */
609 varList = pull_var_clause(whenClause, 0);
610 foreach(lc, varList)
611 {
612 Var *var = (Var *) lfirst(lc);
613
614 switch (var->varno)
615 {
616 case PRS2_OLD_VARNO:
617 if (!TRIGGER_FOR_ROW(tgtype))
620 errmsg("statement trigger's WHEN condition cannot reference column values"),
621 parser_errposition(pstate, var->location)));
622 if (TRIGGER_FOR_INSERT(tgtype))
625 errmsg("INSERT trigger's WHEN condition cannot reference OLD values"),
626 parser_errposition(pstate, var->location)));
627 /* system columns are okay here */
628 break;
629 case PRS2_NEW_VARNO:
630 if (!TRIGGER_FOR_ROW(tgtype))
633 errmsg("statement trigger's WHEN condition cannot reference column values"),
634 parser_errposition(pstate, var->location)));
635 if (TRIGGER_FOR_DELETE(tgtype))
638 errmsg("DELETE trigger's WHEN condition cannot reference NEW values"),
639 parser_errposition(pstate, var->location)));
640 if (var->varattno < 0 && TRIGGER_FOR_BEFORE(tgtype))
643 errmsg("BEFORE trigger's WHEN condition cannot reference NEW system columns"),
644 parser_errposition(pstate, var->location)));
645 if (TRIGGER_FOR_BEFORE(tgtype) &&
646 var->varattno == 0 &&
647 RelationGetDescr(rel)->constr &&
648 (RelationGetDescr(rel)->constr->has_generated_stored ||
649 RelationGetDescr(rel)->constr->has_generated_virtual))
652 errmsg("BEFORE trigger's WHEN condition cannot reference NEW generated columns"),
653 errdetail("A whole-row reference is used and the table contains generated columns."),
654 parser_errposition(pstate, var->location)));
655 if (TRIGGER_FOR_BEFORE(tgtype) &&
656 var->varattno > 0 &&
657 TupleDescAttr(RelationGetDescr(rel), var->varattno - 1)->attgenerated)
660 errmsg("BEFORE trigger's WHEN condition cannot reference NEW generated columns"),
661 errdetail("Column \"%s\" is a generated column.",
662 NameStr(TupleDescAttr(RelationGetDescr(rel), var->varattno - 1)->attname)),
663 parser_errposition(pstate, var->location)));
664 break;
665 default:
666 /* can't happen without add_missing_from, so just elog */
667 elog(ERROR, "trigger WHEN condition cannot contain references to other relations");
668 break;
669 }
670 }
671
672 /* we'll need the rtable for recordDependencyOnExpr */
673 whenRtable = pstate->p_rtable;
674
675 qual = nodeToString(whenClause);
676
677 free_parsestate(pstate);
678 }
679 else if (!whenClause)
680 {
681 whenClause = NULL;
682 whenRtable = NIL;
683 qual = NULL;
684 }
685 else
686 {
687 qual = nodeToString(whenClause);
688 whenRtable = NIL;
689 }
690
691 /*
692 * Find and validate the trigger function.
693 */
694 if (!OidIsValid(funcoid))
695 funcoid = LookupFuncName(stmt->funcname, 0, NULL, false);
696 if (!isInternal)
697 {
699 if (aclresult != ACLCHECK_OK)
701 NameListToString(stmt->funcname));
702 }
704 if (funcrettype != TRIGGEROID)
707 errmsg("function %s must return type %s",
708 NameListToString(stmt->funcname), "trigger")));
709
710 /*
711 * Scan pg_trigger to see if there is already a trigger of the same name.
712 * Skip this for internally generated triggers, since we'll modify the
713 * name to be unique below.
714 *
715 * NOTE that this is cool only because we have ShareRowExclusiveLock on
716 * the relation, so the trigger set won't be changing underneath us.
717 */
719 if (!isInternal)
720 {
723
724 ScanKeyInit(&skeys[0],
728
729 ScanKeyInit(&skeys[1],
732 CStringGetDatum(stmt->trigname));
733
735 NULL, 2, skeys);
736
737 /* There should be at most one matching tuple */
739 {
741
742 trigoid = oldtrigger->oid;
743 existing_constraint_oid = oldtrigger->tgconstraint;
744 existing_isInternal = oldtrigger->tgisinternal;
746 trigger_exists = true;
747 /* copy the tuple to use in CatalogTupleUpdate() */
748 tuple = heap_copytuple(tuple);
749 }
751 }
752
753 if (!trigger_exists)
754 {
755 /* Generate the OID for the new trigger. */
758 }
759 else
760 {
761 /*
762 * If OR REPLACE was specified, we'll replace the old trigger;
763 * otherwise complain about the duplicate name.
764 */
765 if (!stmt->replace)
768 errmsg("trigger \"%s\" for relation \"%s\" already exists",
769 stmt->trigname, RelationGetRelationName(rel))));
770
771 /*
772 * An internal trigger or a child trigger (isClone) cannot be replaced
773 * by a user-defined trigger. However, skip this test when
774 * in_partition, because then we're recursing from a partitioned table
775 * and the check was made at the parent level.
776 */
781 errmsg("trigger \"%s\" for relation \"%s\" is an internal or a child trigger",
782 stmt->trigname, RelationGetRelationName(rel))));
783
784 /*
785 * It is not allowed to replace with a constraint trigger; gram.y
786 * should have enforced this already.
787 */
788 Assert(!stmt->isconstraint);
789
790 /*
791 * It is not allowed to replace an existing constraint trigger,
792 * either. (The reason for these restrictions is partly that it seems
793 * difficult to deal with pending trigger events in such cases, and
794 * partly that the command might imply changing the constraint's
795 * properties as well, which doesn't seem nice.)
796 */
800 errmsg("trigger \"%s\" for relation \"%s\" is a constraint trigger",
801 stmt->trigname, RelationGetRelationName(rel))));
802 }
803
804 /*
805 * If it's a user-entered CREATE CONSTRAINT TRIGGER command, make a
806 * corresponding pg_constraint entry.
807 */
808 if (stmt->isconstraint && !OidIsValid(constraintOid))
809 {
810 /* Internal callers should have made their own constraints */
815 stmt->deferrable,
816 stmt->initdeferred,
817 true, /* Is Enforced */
818 true,
819 InvalidOid, /* no parent */
820 RelationGetRelid(rel),
821 NULL, /* no conkey */
822 0,
823 0,
824 InvalidOid, /* no domain */
825 InvalidOid, /* no index */
826 InvalidOid, /* no foreign key */
827 NULL,
828 NULL,
829 NULL,
830 NULL,
831 0,
832 ' ',
833 ' ',
834 NULL,
835 0,
836 ' ',
837 NULL, /* no exclusion */
838 NULL, /* no check constraint */
839 NULL,
840 true, /* islocal */
841 0, /* inhcount */
842 true, /* noinherit */
843 false, /* conperiod */
844 isInternal); /* is_internal */
845 }
846
847 /*
848 * If trigger is internally generated, modify the provided trigger name to
849 * ensure uniqueness by appending the trigger OID. (Callers will usually
850 * supply a simple constant trigger name in these cases.)
851 */
852 if (isInternal)
853 {
855 "%s_%u", stmt->trigname, trigoid);
856 trigname = internaltrigname;
857 }
858 else
859 {
860 /* user-defined trigger; use the specified trigger name as-is */
861 trigname = stmt->trigname;
862 }
863
864 /*
865 * Build the new pg_trigger tuple.
866 */
867 memset(nulls, false, sizeof(nulls));
868
873 CStringGetDatum(trigname));
883
884 if (stmt->args)
885 {
886 ListCell *le;
887 char *args;
888 int16 nargs = list_length(stmt->args);
889 int len = 0;
890
891 foreach(le, stmt->args)
892 {
893 char *ar = strVal(lfirst(le));
894
895 len += strlen(ar) + 4;
896 for (; *ar; ar++)
897 {
898 if (*ar == '\\')
899 len++;
900 }
901 }
902 args = (char *) palloc(len + 1);
903 args[0] = '\0';
904 foreach(le, stmt->args)
905 {
906 char *s = strVal(lfirst(le));
907 char *d = args + strlen(args);
908
909 while (*s)
910 {
911 if (*s == '\\')
912 *d++ = '\\';
913 *d++ = *s++;
914 }
915 strcpy(d, "\\000");
916 }
919 CStringGetDatum(args));
920 }
921 else
922 {
925 CStringGetDatum(""));
926 }
927
928 /* build column number array if it's a column-specific trigger */
929 ncolumns = list_length(stmt->columns);
930 if (ncolumns == 0)
931 columns = NULL;
932 else
933 {
934 ListCell *cell;
935 int i = 0;
936
937 columns = (int16 *) palloc(ncolumns * sizeof(int16));
938 foreach(cell, stmt->columns)
939 {
940 char *name = strVal(lfirst(cell));
942 int j;
943
944 /* Lookup column name. System columns are not allowed */
945 attnum = attnameAttNum(rel, name, false);
949 errmsg("column \"%s\" of relation \"%s\" does not exist",
951
952 /* Check for duplicates */
953 for (j = i - 1; j >= 0; j--)
954 {
955 if (columns[j] == attnum)
958 errmsg("column \"%s\" specified more than once",
959 name)));
960 }
961
962 columns[i++] = attnum;
963 }
964 }
965 tgattr = buildint2vector(columns, ncolumns);
967
968 /* set tgqual if trigger has WHEN clause */
969 if (qual)
971 else
972 nulls[Anum_pg_trigger_tgqual - 1] = true;
973
974 if (oldtablename)
977 else
978 nulls[Anum_pg_trigger_tgoldtable - 1] = true;
979 if (newtablename)
982 else
983 nulls[Anum_pg_trigger_tgnewtable - 1] = true;
984
985 /*
986 * Insert or replace tuple in pg_trigger.
987 */
988 if (!trigger_exists)
989 {
990 tuple = heap_form_tuple(tgrel->rd_att, values, nulls);
992 }
993 else
994 {
996
997 newtup = heap_form_tuple(tgrel->rd_att, values, nulls);
1000 }
1001
1002 heap_freetuple(tuple); /* free either original or new tuple */
1004
1008 if (oldtablename)
1010 if (newtablename)
1012
1013 /*
1014 * Update relation's pg_class entry; if necessary; and if not, send an SI
1015 * message to make other backends (and this one) rebuild relcache entries.
1016 */
1020 if (!HeapTupleIsValid(tuple))
1021 elog(ERROR, "cache lookup failed for relation %u",
1022 RelationGetRelid(rel));
1023 if (!((Form_pg_class) GETSTRUCT(tuple))->relhastriggers)
1024 {
1025 ((Form_pg_class) GETSTRUCT(tuple))->relhastriggers = true;
1026
1027 CatalogTupleUpdate(pgrel, &tuple->t_self, tuple);
1028
1030 }
1031 else
1033
1034 heap_freetuple(tuple);
1036
1037 /*
1038 * If we're replacing a trigger, flush all the old dependencies before
1039 * recording new ones.
1040 */
1041 if (trigger_exists)
1043
1044 /*
1045 * Record dependencies for trigger. Always place a normal dependency on
1046 * the function.
1047 */
1048 myself.classId = TriggerRelationId;
1049 myself.objectId = trigoid;
1050 myself.objectSubId = 0;
1051
1053 referenced.objectId = funcoid;
1054 referenced.objectSubId = 0;
1056
1058 {
1059 /*
1060 * Internally-generated trigger for a constraint, so make it an
1061 * internal dependency of the constraint. We can skip depending on
1062 * the relation(s), as there'll be an indirect dependency via the
1063 * constraint.
1064 */
1066 referenced.objectId = constraintOid;
1067 referenced.objectSubId = 0;
1069 }
1070 else
1071 {
1072 /*
1073 * User CREATE TRIGGER, so place dependencies. We make trigger be
1074 * auto-dropped if its relation is dropped or if the FK relation is
1075 * dropped. (Auto drop is compatible with our pre-7.3 behavior.)
1076 */
1078 referenced.objectId = RelationGetRelid(rel);
1079 referenced.objectSubId = 0;
1081
1083 {
1085 referenced.objectId = constrrelid;
1086 referenced.objectSubId = 0;
1088 }
1089 /* Not possible to have an index dependency in this case */
1090 Assert(!OidIsValid(indexOid));
1091
1092 /*
1093 * If it's a user-specified constraint trigger, make the constraint
1094 * internally dependent on the trigger instead of vice versa.
1095 */
1097 {
1099 referenced.objectId = constraintOid;
1100 referenced.objectSubId = 0;
1102 }
1103
1104 /*
1105 * If it's a partition trigger, create the partition dependencies.
1106 */
1108 {
1113 }
1114 }
1115
1116 /* If column-specific trigger, add normal dependencies on columns */
1117 if (columns != NULL)
1118 {
1119 int i;
1120
1122 referenced.objectId = RelationGetRelid(rel);
1123 for (i = 0; i < ncolumns; i++)
1124 {
1125 referenced.objectSubId = columns[i];
1127 }
1128 }
1129
1130 /*
1131 * If it has a WHEN clause, add dependencies on objects mentioned in the
1132 * expression (eg, functions, as well as any columns used).
1133 */
1134 if (whenRtable != NIL)
1137
1138 /* Post creation hook for new trigger */
1140 isInternal);
1141
1142 /*
1143 * Lastly, create the trigger on child relations, if needed.
1144 */
1146 {
1147 PartitionDesc partdesc = RelationGetPartitionDesc(rel, true);
1148 int i;
1151
1153 "part trig clone",
1155
1156 /*
1157 * We don't currently expect to be called with a valid indexOid. If
1158 * that ever changes then we'll need to write code here to find the
1159 * corresponding child index.
1160 */
1161 Assert(!OidIsValid(indexOid));
1162
1164
1165 /* Iterate to create the trigger on each existing partition */
1166 for (i = 0; i < partdesc->nparts; i++)
1167 {
1170 Node *qual;
1171
1173
1174 /*
1175 * Initialize our fabricated parse node by copying the original
1176 * one, then resetting fields that we pass separately.
1177 */
1179 childStmt->funcname = NIL;
1180 childStmt->whenClause = NULL;
1181
1182 /* If there is a WHEN clause, create a modified copy of it */
1183 qual = copyObject(whenClause);
1184 qual = (Node *)
1186 childTbl, rel);
1187 qual = (Node *)
1189 childTbl, rel);
1190
1191 CreateTriggerFiringOn(childStmt, queryString,
1192 partdesc->oids[i], refRelOid,
1194 funcoid, trigoid, qual,
1196
1198
1200 }
1201
1204 }
1205
1206 /* Keep lock on target rel until end of xact */
1207 table_close(rel, NoLock);
1208
1209 return myself;
1210}
1211
1212/*
1213 * TriggerSetParentTrigger
1214 * Set a partition's trigger as child of its parent trigger,
1215 * or remove the linkage if parentTrigId is InvalidOid.
1216 *
1217 * This updates the constraint's pg_trigger row to show it as inherited, and
1218 * adds PARTITION dependencies to prevent the trigger from being deleted
1219 * on its own. Alternatively, reverse that.
1220 */
1221void
1226{
1228 ScanKeyData skey[1];
1230 HeapTuple tuple,
1231 newtup;
1234
1235 /*
1236 * Find the trigger to delete.
1237 */
1238 ScanKeyInit(&skey[0],
1242
1244 NULL, 1, skey);
1245
1246 tuple = systable_getnext(tgscan);
1247 if (!HeapTupleIsValid(tuple))
1248 elog(ERROR, "could not find tuple for trigger %u", childTrigId);
1249 newtup = heap_copytuple(tuple);
1252 {
1253 /* don't allow setting parent for a constraint that already has one */
1254 if (OidIsValid(trigForm->tgparentid))
1255 elog(ERROR, "trigger %u already has a parent trigger",
1256 childTrigId);
1257
1258 trigForm->tgparentid = parentTrigId;
1259
1261
1263
1266
1269 }
1270 else
1271 {
1272 trigForm->tgparentid = InvalidOid;
1273
1275
1282 }
1283
1286}
1287
1288
1289/*
1290 * Guts of trigger deletion.
1291 */
1292void
1294{
1297 ScanKeyData skey[1];
1298 HeapTuple tup;
1299 Oid relid;
1300 Relation rel;
1301
1303
1304 /*
1305 * Find the trigger to delete.
1306 */
1307 ScanKeyInit(&skey[0],
1310 ObjectIdGetDatum(trigOid));
1311
1313 NULL, 1, skey);
1314
1316 if (!HeapTupleIsValid(tup))
1317 elog(ERROR, "could not find tuple for trigger %u", trigOid);
1318
1319 /*
1320 * Open and exclusive-lock the relation the trigger belongs to.
1321 */
1322 relid = ((Form_pg_trigger) GETSTRUCT(tup))->tgrelid;
1323
1324 rel = table_open(relid, AccessExclusiveLock);
1325
1326 if (rel->rd_rel->relkind != RELKIND_RELATION &&
1327 rel->rd_rel->relkind != RELKIND_VIEW &&
1328 rel->rd_rel->relkind != RELKIND_FOREIGN_TABLE &&
1329 rel->rd_rel->relkind != RELKIND_PARTITIONED_TABLE)
1330 ereport(ERROR,
1332 errmsg("relation \"%s\" cannot have triggers",
1334 errdetail_relkind_not_supported(rel->rd_rel->relkind)));
1335
1337 ereport(ERROR,
1339 errmsg("permission denied: \"%s\" is a system catalog",
1341
1342 /*
1343 * Delete the pg_trigger tuple.
1344 */
1345 CatalogTupleDelete(tgrel, &tup->t_self);
1346
1349
1350 /*
1351 * We do not bother to try to determine whether any other triggers remain,
1352 * which would be needed in order to decide whether it's safe to clear the
1353 * relation's relhastriggers. (In any case, there might be a concurrent
1354 * process adding new triggers.) Instead, just force a relcache inval to
1355 * make other backends (and this one too!) rebuild their relcache entries.
1356 * There's no great harm in leaving relhastriggers true even if there are
1357 * no triggers left.
1358 */
1360
1361 /* Keep lock on trigger's rel until end of xact */
1362 table_close(rel, NoLock);
1363}
1364
1365/*
1366 * get_trigger_oid - Look up a trigger by name to find its OID.
1367 *
1368 * If missing_ok is false, throw an error if trigger not found. If
1369 * true, just return InvalidOid.
1370 */
1371Oid
1372get_trigger_oid(Oid relid, const char *trigname, bool missing_ok)
1373{
1375 ScanKeyData skey[2];
1377 HeapTuple tup;
1378 Oid oid;
1379
1380 /*
1381 * Find the trigger, verify permissions, set up object address
1382 */
1384
1385 ScanKeyInit(&skey[0],
1388 ObjectIdGetDatum(relid));
1389 ScanKeyInit(&skey[1],
1392 CStringGetDatum(trigname));
1393
1395 NULL, 2, skey);
1396
1398
1399 if (!HeapTupleIsValid(tup))
1400 {
1401 if (!missing_ok)
1402 ereport(ERROR,
1404 errmsg("trigger \"%s\" for table \"%s\" does not exist",
1405 trigname, get_rel_name(relid))));
1406 oid = InvalidOid;
1407 }
1408 else
1409 {
1410 oid = ((Form_pg_trigger) GETSTRUCT(tup))->oid;
1411 }
1412
1415 return oid;
1416}
1417
1418/*
1419 * Perform permissions and integrity checks before acquiring a relation lock.
1420 */
1421static void
1423 void *arg)
1424{
1425 HeapTuple tuple;
1427
1428 tuple = SearchSysCache1(RELOID, ObjectIdGetDatum(relid));
1429 if (!HeapTupleIsValid(tuple))
1430 return; /* concurrently dropped */
1431 form = (Form_pg_class) GETSTRUCT(tuple);
1432
1433 /* only tables and views can have triggers */
1434 if (form->relkind != RELKIND_RELATION && form->relkind != RELKIND_VIEW &&
1435 form->relkind != RELKIND_FOREIGN_TABLE &&
1436 form->relkind != RELKIND_PARTITIONED_TABLE)
1437 ereport(ERROR,
1439 errmsg("relation \"%s\" cannot have triggers",
1440 rv->relname),
1442
1443 /* you must own the table to rename one of its triggers */
1446 if (!allowSystemTableMods && IsSystemClass(relid, form))
1447 ereport(ERROR,
1449 errmsg("permission denied: \"%s\" is a system catalog",
1450 rv->relname)));
1451
1452 ReleaseSysCache(tuple);
1453}
1454
1455/*
1456 * renametrig - changes the name of a trigger on a relation
1457 *
1458 * trigger name is changed in trigger catalog.
1459 * No record of the previous name is kept.
1460 *
1461 * get proper relrelation from relation catalog (if not arg)
1462 * scan trigger catalog
1463 * for name conflict (within rel)
1464 * for original trigger (if not arg)
1465 * modify tgname in trigger tuple
1466 * update row in catalog
1467 */
1470{
1471 Oid tgoid;
1474 HeapTuple tuple;
1476 ScanKeyData key[2];
1477 Oid relid;
1478 ObjectAddress address;
1479
1480 /*
1481 * Look up name, check permissions, and acquire lock (which we will NOT
1482 * release until end of transaction).
1483 */
1485 0,
1487 NULL);
1488
1489 /* Have lock already, so just need to build relcache entry. */
1490 targetrel = relation_open(relid, NoLock);
1491
1492 /*
1493 * On partitioned tables, this operation recurses to partitions. Lock all
1494 * tables upfront.
1495 */
1496 if (targetrel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE)
1498
1500
1501 /*
1502 * Search for the trigger to modify.
1503 */
1504 ScanKeyInit(&key[0],
1507 ObjectIdGetDatum(relid));
1508 ScanKeyInit(&key[1],
1511 PointerGetDatum(stmt->subname));
1513 NULL, 2, key);
1515 {
1517
1519 tgoid = trigform->oid;
1520
1521 /*
1522 * If the trigger descends from a trigger on a parent partitioned
1523 * table, reject the rename. We don't allow a trigger in a partition
1524 * to differ in name from that of its parent: that would lead to an
1525 * inconsistency that pg_dump would not reproduce.
1526 */
1527 if (OidIsValid(trigform->tgparentid))
1528 ereport(ERROR,
1530 errmsg("cannot rename trigger \"%s\" on table \"%s\"",
1532 errhint("Rename the trigger on the partitioned table \"%s\" instead.",
1533 get_rel_name(get_partition_parent(relid, false))));
1534
1535
1536 /* Rename the trigger on this relation ... */
1537 renametrig_internal(tgrel, targetrel, tuple, stmt->newname,
1538 stmt->subname);
1539
1540 /* ... and if it is partitioned, recurse to its partitions */
1541 if (targetrel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE)
1542 {
1544
1545 for (int i = 0; i < partdesc->nparts; i++)
1546 {
1547 Oid partitionId = partdesc->oids[i];
1548
1550 stmt->newname, stmt->subname);
1551 }
1552 }
1553 }
1554 else
1555 {
1556 ereport(ERROR,
1558 errmsg("trigger \"%s\" for table \"%s\" does not exist",
1560 }
1561
1562 ObjectAddressSet(address, TriggerRelationId, tgoid);
1563
1565
1567
1568 /*
1569 * Close rel, but keep exclusive lock!
1570 */
1572
1573 return address;
1574}
1575
1576/*
1577 * Subroutine for renametrig -- perform the actual work of renaming one
1578 * trigger on one table.
1579 *
1580 * If the trigger has a name different from the expected one, raise a
1581 * NOTICE about it.
1582 */
1583static void
1585 const char *newname, const char *expected_name)
1586{
1587 HeapTuple tuple;
1589 ScanKeyData key[2];
1591
1592 /* If the trigger already has the new name, nothing to do. */
1594 if (strcmp(NameStr(tgform->tgname), newname) == 0)
1595 return;
1596
1597 /*
1598 * Before actually trying the rename, search for triggers with the same
1599 * name. The update would fail with an ugly message in that case, and it
1600 * is better to throw a nicer error.
1601 */
1602 ScanKeyInit(&key[0],
1606 ScanKeyInit(&key[1],
1609 PointerGetDatum(newname));
1611 NULL, 2, key);
1613 ereport(ERROR,
1615 errmsg("trigger \"%s\" for relation \"%s\" already exists",
1618
1619 /*
1620 * The target name is free; update the existing pg_trigger tuple with it.
1621 */
1622 tuple = heap_copytuple(trigtup); /* need a modifiable copy */
1623 tgform = (Form_pg_trigger) GETSTRUCT(tuple);
1624
1625 /*
1626 * If the trigger has a name different from what we expected, let the user
1627 * know. (We can proceed anyway, since we must have reached here following
1628 * a tgparentid link.)
1629 */
1630 if (strcmp(NameStr(tgform->tgname), expected_name) != 0)
1632 errmsg("renamed trigger \"%s\" on relation \"%s\"",
1633 NameStr(tgform->tgname),
1635
1636 namestrcpy(&tgform->tgname, newname);
1637
1638 CatalogTupleUpdate(tgrel, &tuple->t_self, tuple);
1639
1641
1642 /*
1643 * Invalidate relation's relcache entry so that other backends (and this
1644 * one too!) are sent SI message to make them rebuild relcache entries.
1645 * (Ideally this should happen automatically...)
1646 */
1648}
1649
1650/*
1651 * Subroutine for renametrig -- Helper for recursing to partitions when
1652 * renaming triggers on a partitioned table.
1653 */
1654static void
1656 const char *newname, const char *expected_name)
1657{
1659 ScanKeyData key;
1660 HeapTuple tuple;
1661
1662 /*
1663 * Given a relation and the OID of a trigger on parent relation, find the
1664 * corresponding trigger in the child and rename that trigger to the given
1665 * name.
1666 */
1667 ScanKeyInit(&key,
1672 NULL, 1, &key);
1673 while (HeapTupleIsValid(tuple = systable_getnext(tgscan)))
1674 {
1677
1678 if (tgform->tgparentid != parentTriggerOid)
1679 continue; /* not our trigger */
1680
1682
1683 /* Rename the trigger on this partition */
1685
1686 /* And if this relation is partitioned, recurse to its partitions */
1687 if (partitionRel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE)
1688 {
1690 true);
1691
1692 for (int i = 0; i < partdesc->nparts; i++)
1693 {
1694 Oid partoid = partdesc->oids[i];
1695
1696 renametrig_partition(tgrel, partoid, tgform->oid, newname,
1697 NameStr(tgform->tgname));
1698 }
1699 }
1701
1702 /* There should be at most one matching tuple */
1703 break;
1704 }
1706}
1707
1708/*
1709 * EnableDisableTrigger()
1710 *
1711 * Called by ALTER TABLE ENABLE/DISABLE [ REPLICA | ALWAYS ] TRIGGER
1712 * to change 'tgenabled' field for the specified trigger(s)
1713 *
1714 * rel: relation to process (caller must hold suitable lock on it)
1715 * tgname: name of trigger to process, or NULL to scan all triggers
1716 * tgparent: if not zero, process only triggers with this tgparentid
1717 * fires_when: new value for tgenabled field. In addition to generic
1718 * enablement/disablement, this also defines when the trigger
1719 * should be fired in session replication roles.
1720 * skip_system: if true, skip "system" triggers (constraint triggers)
1721 * recurse: if true, recurse to partitions
1722 *
1723 * Caller should have checked permissions for the table; here we also
1724 * enforce that superuser privilege is required to alter the state of
1725 * system triggers
1726 */
1727void
1729 char fires_when, bool skip_system, bool recurse,
1730 LOCKMODE lockmode)
1731{
1733 int nkeys;
1734 ScanKeyData keys[2];
1736 HeapTuple tuple;
1737 bool found;
1738 bool changed;
1739
1740 /* Scan the relevant entries in pg_triggers */
1742
1743 ScanKeyInit(&keys[0],
1747 if (tgname)
1748 {
1749 ScanKeyInit(&keys[1],
1752 CStringGetDatum(tgname));
1753 nkeys = 2;
1754 }
1755 else
1756 nkeys = 1;
1757
1759 NULL, nkeys, keys);
1760
1761 found = changed = false;
1762
1763 while (HeapTupleIsValid(tuple = systable_getnext(tgscan)))
1764 {
1766
1767 if (OidIsValid(tgparent) && tgparent != oldtrig->tgparentid)
1768 continue;
1769
1770 if (oldtrig->tgisinternal)
1771 {
1772 /* system trigger ... ok to process? */
1773 if (skip_system)
1774 continue;
1775 if (!superuser())
1776 ereport(ERROR,
1778 errmsg("permission denied: \"%s\" is a system trigger",
1779 NameStr(oldtrig->tgname))));
1780 }
1781
1782 found = true;
1783
1784 if (oldtrig->tgenabled != fires_when)
1785 {
1786 /* need to change this one ... make a copy to scribble on */
1789
1790 newtrig->tgenabled = fires_when;
1791
1793
1795
1796 changed = true;
1797 }
1798
1799 /*
1800 * When altering FOR EACH ROW triggers on a partitioned table, do the
1801 * same on the partitions as well, unless ONLY is specified.
1802 *
1803 * Note that we recurse even if we didn't change the trigger above,
1804 * because the partitions' copy of the trigger may have a different
1805 * value of tgenabled than the parent's trigger and thus might need to
1806 * be changed.
1807 */
1808 if (recurse &&
1809 rel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE &&
1810 (TRIGGER_FOR_ROW(oldtrig->tgtype)))
1811 {
1812 PartitionDesc partdesc = RelationGetPartitionDesc(rel, true);
1813 int i;
1814
1815 for (i = 0; i < partdesc->nparts; i++)
1816 {
1817 Relation part;
1818
1819 part = relation_open(partdesc->oids[i], lockmode);
1820 /* Match on child triggers' tgparentid, not their name */
1822 fires_when, skip_system, recurse,
1823 lockmode);
1824 table_close(part, NoLock); /* keep lock till commit */
1825 }
1826 }
1827
1829 oldtrig->oid, 0);
1830 }
1831
1833
1835
1836 if (tgname && !found)
1837 ereport(ERROR,
1839 errmsg("trigger \"%s\" for table \"%s\" does not exist",
1840 tgname, RelationGetRelationName(rel))));
1841
1842 /*
1843 * If we changed anything, broadcast a SI inval message to force each
1844 * backend (including our own!) to rebuild relation's relcache entry.
1845 * Otherwise they will fail to apply the change promptly.
1846 */
1847 if (changed)
1849}
1850
1851
1852/*
1853 * Build trigger data to attach to the given relcache entry.
1854 *
1855 * Note that trigger data attached to a relcache entry must be stored in
1856 * CacheMemoryContext to ensure it survives as long as the relcache entry.
1857 * But we should be running in a less long-lived working context. To avoid
1858 * leaking cache memory if this routine fails partway through, we build a
1859 * temporary TriggerDesc in working memory and then copy the completed
1860 * structure into cache memory.
1861 */
1862void
1864{
1865 TriggerDesc *trigdesc;
1866 int numtrigs;
1867 int maxtrigs;
1868 Trigger *triggers;
1872 HeapTuple htup;
1874 int i;
1875
1876 /*
1877 * Allocate a working array to hold the triggers (the array is extended if
1878 * necessary)
1879 */
1880 maxtrigs = 16;
1881 triggers = (Trigger *) palloc(maxtrigs * sizeof(Trigger));
1882 numtrigs = 0;
1883
1884 /*
1885 * Note: since we scan the triggers using TriggerRelidNameIndexId, we will
1886 * be reading the triggers in name order, except possibly during
1887 * emergency-recovery operations (ie, IgnoreSystemIndexes). This in turn
1888 * ensures that triggers will be fired in name order.
1889 */
1894
1897 NULL, 1, &skey);
1898
1900 {
1902 Trigger *build;
1903 Datum datum;
1904 bool isnull;
1905
1906 if (numtrigs >= maxtrigs)
1907 {
1908 maxtrigs *= 2;
1909 triggers = (Trigger *) repalloc(triggers, maxtrigs * sizeof(Trigger));
1910 }
1911 build = &(triggers[numtrigs]);
1912
1913 build->tgoid = pg_trigger->oid;
1915 NameGetDatum(&pg_trigger->tgname)));
1916 build->tgfoid = pg_trigger->tgfoid;
1917 build->tgtype = pg_trigger->tgtype;
1918 build->tgenabled = pg_trigger->tgenabled;
1919 build->tgisinternal = pg_trigger->tgisinternal;
1920 build->tgisclone = OidIsValid(pg_trigger->tgparentid);
1921 build->tgconstrrelid = pg_trigger->tgconstrrelid;
1922 build->tgconstrindid = pg_trigger->tgconstrindid;
1923 build->tgconstraint = pg_trigger->tgconstraint;
1924 build->tgdeferrable = pg_trigger->tgdeferrable;
1925 build->tginitdeferred = pg_trigger->tginitdeferred;
1926 build->tgnargs = pg_trigger->tgnargs;
1927 /* tgattr is first var-width field, so OK to access directly */
1928 build->tgnattr = pg_trigger->tgattr.dim1;
1929 if (build->tgnattr > 0)
1930 {
1931 build->tgattr = (int16 *) palloc(build->tgnattr * sizeof(int16));
1932 memcpy(build->tgattr, &(pg_trigger->tgattr.values),
1933 build->tgnattr * sizeof(int16));
1934 }
1935 else
1936 build->tgattr = NULL;
1937 if (build->tgnargs > 0)
1938 {
1939 bytea *val;
1940 char *p;
1941
1944 tgrel->rd_att, &isnull));
1945 if (isnull)
1946 elog(ERROR, "tgargs is null in trigger for relation \"%s\"",
1947 RelationGetRelationName(relation));
1948 p = (char *) VARDATA_ANY(val);
1949 build->tgargs = (char **) palloc(build->tgnargs * sizeof(char *));
1950 for (i = 0; i < build->tgnargs; i++)
1951 {
1952 build->tgargs[i] = pstrdup(p);
1953 p += strlen(p) + 1;
1954 }
1955 }
1956 else
1957 build->tgargs = NULL;
1958
1960 tgrel->rd_att, &isnull);
1961 if (!isnull)
1962 build->tgoldtable =
1964 else
1965 build->tgoldtable = NULL;
1966
1968 tgrel->rd_att, &isnull);
1969 if (!isnull)
1970 build->tgnewtable =
1972 else
1973 build->tgnewtable = NULL;
1974
1975 datum = fastgetattr(htup, Anum_pg_trigger_tgqual,
1976 tgrel->rd_att, &isnull);
1977 if (!isnull)
1978 build->tgqual = TextDatumGetCString(datum);
1979 else
1980 build->tgqual = NULL;
1981
1982 numtrigs++;
1983 }
1984
1987
1988 /* There might not be any triggers */
1989 if (numtrigs == 0)
1990 {
1991 pfree(triggers);
1992 return;
1993 }
1994
1995 /* Build trigdesc */
1996 trigdesc = palloc0_object(TriggerDesc);
1997 trigdesc->triggers = triggers;
1998 trigdesc->numtriggers = numtrigs;
1999 for (i = 0; i < numtrigs; i++)
2000 SetTriggerFlags(trigdesc, &(triggers[i]));
2001
2002 /* Copy completed trigdesc into cache storage */
2004 relation->trigdesc = CopyTriggerDesc(trigdesc);
2006
2007 /* Release working memory */
2008 FreeTriggerDesc(trigdesc);
2009}
2010
2011/*
2012 * Update the TriggerDesc's hint flags to include the specified trigger
2013 */
2014static void
2016{
2017 int16 tgtype = trigger->tgtype;
2018
2019 trigdesc->trig_insert_before_row |=
2022 trigdesc->trig_insert_after_row |=
2025 trigdesc->trig_insert_instead_row |=
2028 trigdesc->trig_insert_before_statement |=
2031 trigdesc->trig_insert_after_statement |=
2034 trigdesc->trig_update_before_row |=
2037 trigdesc->trig_update_after_row |=
2040 trigdesc->trig_update_instead_row |=
2043 trigdesc->trig_update_before_statement |=
2046 trigdesc->trig_update_after_statement |=
2049 trigdesc->trig_delete_before_row |=
2052 trigdesc->trig_delete_after_row |=
2055 trigdesc->trig_delete_instead_row |=
2058 trigdesc->trig_delete_before_statement |=
2061 trigdesc->trig_delete_after_statement |=
2064 /* there are no row-level truncate triggers */
2071
2072 trigdesc->trig_insert_new_table |=
2073 (TRIGGER_FOR_INSERT(tgtype) &&
2075 trigdesc->trig_update_old_table |=
2076 (TRIGGER_FOR_UPDATE(tgtype) &&
2078 trigdesc->trig_update_new_table |=
2079 (TRIGGER_FOR_UPDATE(tgtype) &&
2081 trigdesc->trig_delete_old_table |=
2082 (TRIGGER_FOR_DELETE(tgtype) &&
2084}
2085
2086/*
2087 * Copy a TriggerDesc data structure.
2088 *
2089 * The copy is allocated in the current memory context.
2090 */
2093{
2096 int i;
2097
2098 if (trigdesc == NULL || trigdesc->numtriggers <= 0)
2099 return NULL;
2100
2102 memcpy(newdesc, trigdesc, sizeof(TriggerDesc));
2103
2104 trigger = (Trigger *) palloc(trigdesc->numtriggers * sizeof(Trigger));
2105 memcpy(trigger, trigdesc->triggers,
2106 trigdesc->numtriggers * sizeof(Trigger));
2107 newdesc->triggers = trigger;
2108
2109 for (i = 0; i < trigdesc->numtriggers; i++)
2110 {
2111 trigger->tgname = pstrdup(trigger->tgname);
2112 if (trigger->tgnattr > 0)
2113 {
2114 int16 *newattr;
2115
2116 newattr = (int16 *) palloc(trigger->tgnattr * sizeof(int16));
2117 memcpy(newattr, trigger->tgattr,
2118 trigger->tgnattr * sizeof(int16));
2119 trigger->tgattr = newattr;
2120 }
2121 if (trigger->tgnargs > 0)
2122 {
2123 char **newargs;
2124 int16 j;
2125
2126 newargs = (char **) palloc(trigger->tgnargs * sizeof(char *));
2127 for (j = 0; j < trigger->tgnargs; j++)
2128 newargs[j] = pstrdup(trigger->tgargs[j]);
2129 trigger->tgargs = newargs;
2130 }
2131 if (trigger->tgqual)
2132 trigger->tgqual = pstrdup(trigger->tgqual);
2133 if (trigger->tgoldtable)
2134 trigger->tgoldtable = pstrdup(trigger->tgoldtable);
2135 if (trigger->tgnewtable)
2136 trigger->tgnewtable = pstrdup(trigger->tgnewtable);
2137 trigger++;
2138 }
2139
2140 return newdesc;
2141}
2142
2143/*
2144 * Free a TriggerDesc data structure.
2145 */
2146void
2148{
2150 int i;
2151
2152 if (trigdesc == NULL)
2153 return;
2154
2155 trigger = trigdesc->triggers;
2156 for (i = 0; i < trigdesc->numtriggers; i++)
2157 {
2158 pfree(trigger->tgname);
2159 if (trigger->tgnattr > 0)
2160 pfree(trigger->tgattr);
2161 if (trigger->tgnargs > 0)
2162 {
2163 while (--(trigger->tgnargs) >= 0)
2164 pfree(trigger->tgargs[trigger->tgnargs]);
2165 pfree(trigger->tgargs);
2166 }
2167 if (trigger->tgqual)
2168 pfree(trigger->tgqual);
2169 if (trigger->tgoldtable)
2170 pfree(trigger->tgoldtable);
2171 if (trigger->tgnewtable)
2172 pfree(trigger->tgnewtable);
2173 trigger++;
2174 }
2175 pfree(trigdesc->triggers);
2176 pfree(trigdesc);
2177}
2178
2179/*
2180 * Compare two TriggerDesc structures for logical equality.
2181 */
2182#ifdef NOT_USED
2183bool
2185{
2186 int i,
2187 j;
2188
2189 /*
2190 * We need not examine the hint flags, just the trigger array itself; if
2191 * we have the same triggers with the same types, the flags should match.
2192 *
2193 * As of 7.3 we assume trigger set ordering is significant in the
2194 * comparison; so we just compare corresponding slots of the two sets.
2195 *
2196 * Note: comparing the stringToNode forms of the WHEN clauses means that
2197 * parse column locations will affect the result. This is okay as long as
2198 * this function is only used for detecting exact equality, as for example
2199 * in checking for staleness of a cache entry.
2200 */
2201 if (trigdesc1 != NULL)
2202 {
2203 if (trigdesc2 == NULL)
2204 return false;
2205 if (trigdesc1->numtriggers != trigdesc2->numtriggers)
2206 return false;
2207 for (i = 0; i < trigdesc1->numtriggers; i++)
2208 {
2209 Trigger *trig1 = trigdesc1->triggers + i;
2210 Trigger *trig2 = trigdesc2->triggers + i;
2211
2212 if (trig1->tgoid != trig2->tgoid)
2213 return false;
2214 if (strcmp(trig1->tgname, trig2->tgname) != 0)
2215 return false;
2216 if (trig1->tgfoid != trig2->tgfoid)
2217 return false;
2218 if (trig1->tgtype != trig2->tgtype)
2219 return false;
2220 if (trig1->tgenabled != trig2->tgenabled)
2221 return false;
2222 if (trig1->tgisinternal != trig2->tgisinternal)
2223 return false;
2224 if (trig1->tgisclone != trig2->tgisclone)
2225 return false;
2226 if (trig1->tgconstrrelid != trig2->tgconstrrelid)
2227 return false;
2228 if (trig1->tgconstrindid != trig2->tgconstrindid)
2229 return false;
2230 if (trig1->tgconstraint != trig2->tgconstraint)
2231 return false;
2232 if (trig1->tgdeferrable != trig2->tgdeferrable)
2233 return false;
2234 if (trig1->tginitdeferred != trig2->tginitdeferred)
2235 return false;
2236 if (trig1->tgnargs != trig2->tgnargs)
2237 return false;
2238 if (trig1->tgnattr != trig2->tgnattr)
2239 return false;
2240 if (trig1->tgnattr > 0 &&
2241 memcmp(trig1->tgattr, trig2->tgattr,
2242 trig1->tgnattr * sizeof(int16)) != 0)
2243 return false;
2244 for (j = 0; j < trig1->tgnargs; j++)
2245 if (strcmp(trig1->tgargs[j], trig2->tgargs[j]) != 0)
2246 return false;
2247 if (trig1->tgqual == NULL && trig2->tgqual == NULL)
2248 /* ok */ ;
2249 else if (trig1->tgqual == NULL || trig2->tgqual == NULL)
2250 return false;
2251 else if (strcmp(trig1->tgqual, trig2->tgqual) != 0)
2252 return false;
2253 if (trig1->tgoldtable == NULL && trig2->tgoldtable == NULL)
2254 /* ok */ ;
2255 else if (trig1->tgoldtable == NULL || trig2->tgoldtable == NULL)
2256 return false;
2257 else if (strcmp(trig1->tgoldtable, trig2->tgoldtable) != 0)
2258 return false;
2259 if (trig1->tgnewtable == NULL && trig2->tgnewtable == NULL)
2260 /* ok */ ;
2261 else if (trig1->tgnewtable == NULL || trig2->tgnewtable == NULL)
2262 return false;
2263 else if (strcmp(trig1->tgnewtable, trig2->tgnewtable) != 0)
2264 return false;
2265 }
2266 }
2267 else if (trigdesc2 != NULL)
2268 return false;
2269 return true;
2270}
2271#endif /* NOT_USED */
2272
2273/*
2274 * Check if there is a row-level trigger with transition tables that prevents
2275 * a table from becoming an inheritance child or partition. Return the name
2276 * of the first such incompatible trigger, or NULL if there is none.
2277 */
2278const char *
2280{
2281 if (trigdesc != NULL)
2282 {
2283 int i;
2284
2285 for (i = 0; i < trigdesc->numtriggers; ++i)
2286 {
2287 Trigger *trigger = &trigdesc->triggers[i];
2288
2289 if (!TRIGGER_FOR_ROW(trigger->tgtype))
2290 continue;
2291 if (trigger->tgoldtable != NULL || trigger->tgnewtable != NULL)
2292 return trigger->tgname;
2293 }
2294 }
2295
2296 return NULL;
2297}
2298
2299/*
2300 * Call a trigger function.
2301 *
2302 * trigdata: trigger descriptor.
2303 * tgindx: trigger's index in finfo and instr arrays.
2304 * finfo: array of cached trigger function call information.
2305 * instr: optional array of EXPLAIN ANALYZE instrumentation state.
2306 * per_tuple_context: memory context to execute the function in.
2307 *
2308 * Returns the tuple (or NULL) as returned by the function.
2309 */
2310static HeapTuple
2312 int tgindx,
2313 FmgrInfo *finfo,
2316{
2317 LOCAL_FCINFO(fcinfo, 0);
2319 Datum result;
2321
2322 /*
2323 * Protect against code paths that may fail to initialize transition table
2324 * info.
2325 */
2327 TRIGGER_FIRED_BY_UPDATE(trigdata->tg_event) ||
2328 TRIGGER_FIRED_BY_DELETE(trigdata->tg_event)) &&
2329 TRIGGER_FIRED_AFTER(trigdata->tg_event) &&
2330 !(trigdata->tg_event & AFTER_TRIGGER_DEFERRABLE) &&
2331 !(trigdata->tg_event & AFTER_TRIGGER_INITDEFERRED)) ||
2332 (trigdata->tg_oldtable == NULL && trigdata->tg_newtable == NULL));
2333
2334 finfo += tgindx;
2335
2336 /*
2337 * We cache fmgr lookup info, to avoid making the lookup again on each
2338 * call.
2339 */
2340 if (finfo->fn_oid == InvalidOid)
2341 fmgr_info(trigdata->tg_trigger->tgfoid, finfo);
2342
2343 Assert(finfo->fn_oid == trigdata->tg_trigger->tgfoid);
2344
2345 /*
2346 * If doing EXPLAIN ANALYZE, start charging time to this trigger.
2347 */
2348 if (instr)
2349 InstrStartTrigger(instr + tgindx);
2350
2351 /*
2352 * Do the function evaluation in the per-tuple memory context, so that
2353 * leaked memory will be reclaimed once per tuple. Note in particular that
2354 * any new tuple created by the trigger function will live till the end of
2355 * the tuple cycle.
2356 */
2358
2359 /*
2360 * Call the function, passing no arguments but setting a context.
2361 */
2362 InitFunctionCallInfoData(*fcinfo, finfo, 0,
2363 InvalidOid, (Node *) trigdata, NULL);
2364
2366
2368 PG_TRY();
2369 {
2370 result = FunctionCallInvoke(fcinfo);
2371 }
2372 PG_FINALLY();
2373 {
2375 }
2376 PG_END_TRY();
2377
2379
2381
2382 /*
2383 * Trigger protocol allows function to return a null pointer, but NOT to
2384 * set the isnull result flag.
2385 */
2386 if (fcinfo->isnull)
2387 ereport(ERROR,
2389 errmsg("trigger function %u returned null value",
2390 fcinfo->flinfo->fn_oid)));
2391
2392 /*
2393 * If doing EXPLAIN ANALYZE, stop charging time to this trigger, and count
2394 * the firing of the trigger.
2395 */
2396 if (instr)
2397 InstrStopTrigger(instr + tgindx, 1);
2398
2400}
2401
2402void
2404{
2405 TriggerDesc *trigdesc;
2406 int i;
2408
2409 trigdesc = relinfo->ri_TrigDesc;
2410
2411 if (trigdesc == NULL)
2412 return;
2413 if (!trigdesc->trig_insert_before_statement)
2414 return;
2415
2416 /* no-op if we already fired BS triggers in this context */
2418 CMD_INSERT))
2419 return;
2420
2424 LocTriggerData.tg_relation = relinfo->ri_RelationDesc;
2425 for (i = 0; i < trigdesc->numtriggers; i++)
2426 {
2427 Trigger *trigger = &trigdesc->triggers[i];
2428 HeapTuple newtuple;
2429
2430 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
2434 continue;
2435 if (!TriggerEnabled(estate, relinfo, trigger, LocTriggerData.tg_event,
2436 NULL, NULL, NULL))
2437 continue;
2438
2439 LocTriggerData.tg_trigger = trigger;
2441 i,
2442 relinfo->ri_TrigFunctions,
2443 relinfo->ri_TrigInstrument,
2444 GetPerTupleMemoryContext(estate));
2445
2446 if (newtuple)
2447 ereport(ERROR,
2449 errmsg("BEFORE STATEMENT trigger cannot return a value")));
2450 }
2451}
2452
2453void
2455 TransitionCaptureState *transition_capture)
2456{
2457 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
2458
2459 if (trigdesc && trigdesc->trig_insert_after_statement)
2462 false, NULL, NULL, NIL, NULL, transition_capture,
2463 false);
2464}
2465
2466bool
2468 TupleTableSlot *slot)
2469{
2470 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
2471 HeapTuple newtuple = NULL;
2472 bool should_free;
2474 int i;
2475
2480 LocTriggerData.tg_relation = relinfo->ri_RelationDesc;
2481 for (i = 0; i < trigdesc->numtriggers; i++)
2482 {
2483 Trigger *trigger = &trigdesc->triggers[i];
2484 HeapTuple oldtuple;
2485
2486 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
2490 continue;
2491 if (!TriggerEnabled(estate, relinfo, trigger, LocTriggerData.tg_event,
2492 NULL, NULL, slot))
2493 continue;
2494
2495 if (!newtuple)
2496 newtuple = ExecFetchSlotHeapTuple(slot, true, &should_free);
2497
2498 LocTriggerData.tg_trigslot = slot;
2499 LocTriggerData.tg_trigtuple = oldtuple = newtuple;
2500 LocTriggerData.tg_trigger = trigger;
2502 i,
2503 relinfo->ri_TrigFunctions,
2504 relinfo->ri_TrigInstrument,
2505 GetPerTupleMemoryContext(estate));
2506 if (newtuple == NULL)
2507 {
2508 if (should_free)
2509 heap_freetuple(oldtuple);
2510 return false; /* "do nothing" */
2511 }
2512 else if (newtuple != oldtuple)
2513 {
2514 newtuple = check_modified_virtual_generated(RelationGetDescr(relinfo->ri_RelationDesc), newtuple);
2515
2516 ExecForceStoreHeapTuple(newtuple, slot, false);
2517
2518 /*
2519 * After a tuple in a partition goes through a trigger, the user
2520 * could have changed the partition key enough that the tuple no
2521 * longer fits the partition. Verify that.
2522 */
2523 if (trigger->tgisclone &&
2524 !ExecPartitionCheck(relinfo, slot, estate, false))
2525 ereport(ERROR,
2527 errmsg("moving row to another partition during a BEFORE FOR EACH ROW trigger is not supported"),
2528 errdetail("Before executing trigger \"%s\", the row was to be in partition \"%s.%s\".",
2529 trigger->tgname,
2531 RelationGetRelationName(relinfo->ri_RelationDesc))));
2532
2533 if (should_free)
2534 heap_freetuple(oldtuple);
2535
2536 /* signal tuple should be re-fetched if used */
2537 newtuple = NULL;
2538 }
2539 }
2540
2541 return true;
2542}
2543
2544void
2547 TransitionCaptureState *transition_capture)
2548{
2549 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
2550
2551 if (relinfo->ri_FdwRoutine && transition_capture &&
2552 transition_capture->tcs_insert_new_table)
2553 {
2554 Assert(relinfo->ri_RootResultRelInfo);
2555 ereport(ERROR,
2557 errmsg("cannot collect transition tuples from child foreign tables")));
2558 }
2559
2560 if ((trigdesc && trigdesc->trig_insert_after_row) ||
2561 (transition_capture && transition_capture->tcs_insert_new_table))
2564 true, NULL, slot,
2566 transition_capture,
2567 false);
2568}
2569
2570bool
2572 TupleTableSlot *slot)
2573{
2574 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
2575 HeapTuple newtuple = NULL;
2576 bool should_free;
2578 int i;
2579
2584 LocTriggerData.tg_relation = relinfo->ri_RelationDesc;
2585 for (i = 0; i < trigdesc->numtriggers; i++)
2586 {
2587 Trigger *trigger = &trigdesc->triggers[i];
2588 HeapTuple oldtuple;
2589
2590 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
2594 continue;
2595 if (!TriggerEnabled(estate, relinfo, trigger, LocTriggerData.tg_event,
2596 NULL, NULL, slot))
2597 continue;
2598
2599 if (!newtuple)
2600 newtuple = ExecFetchSlotHeapTuple(slot, true, &should_free);
2601
2602 LocTriggerData.tg_trigslot = slot;
2603 LocTriggerData.tg_trigtuple = oldtuple = newtuple;
2604 LocTriggerData.tg_trigger = trigger;
2606 i,
2607 relinfo->ri_TrigFunctions,
2608 relinfo->ri_TrigInstrument,
2609 GetPerTupleMemoryContext(estate));
2610 if (newtuple == NULL)
2611 {
2612 if (should_free)
2613 heap_freetuple(oldtuple);
2614 return false; /* "do nothing" */
2615 }
2616 else if (newtuple != oldtuple)
2617 {
2618 ExecForceStoreHeapTuple(newtuple, slot, false);
2619
2620 if (should_free)
2621 heap_freetuple(oldtuple);
2622
2623 /* signal tuple should be re-fetched if used */
2624 newtuple = NULL;
2625 }
2626 }
2627
2628 return true;
2629}
2630
2631void
2633{
2634 TriggerDesc *trigdesc;
2635 int i;
2637
2638 trigdesc = relinfo->ri_TrigDesc;
2639
2640 if (trigdesc == NULL)
2641 return;
2642 if (!trigdesc->trig_delete_before_statement)
2643 return;
2644
2645 /* no-op if we already fired BS triggers in this context */
2647 CMD_DELETE))
2648 return;
2649
2653 LocTriggerData.tg_relation = relinfo->ri_RelationDesc;
2654 for (i = 0; i < trigdesc->numtriggers; i++)
2655 {
2656 Trigger *trigger = &trigdesc->triggers[i];
2657 HeapTuple newtuple;
2658
2659 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
2663 continue;
2664 if (!TriggerEnabled(estate, relinfo, trigger, LocTriggerData.tg_event,
2665 NULL, NULL, NULL))
2666 continue;
2667
2668 LocTriggerData.tg_trigger = trigger;
2670 i,
2671 relinfo->ri_TrigFunctions,
2672 relinfo->ri_TrigInstrument,
2673 GetPerTupleMemoryContext(estate));
2674
2675 if (newtuple)
2676 ereport(ERROR,
2678 errmsg("BEFORE STATEMENT trigger cannot return a value")));
2679 }
2680}
2681
2682void
2684 TransitionCaptureState *transition_capture)
2685{
2686 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
2687
2688 if (trigdesc && trigdesc->trig_delete_after_statement)
2691 false, NULL, NULL, NIL, NULL, transition_capture,
2692 false);
2693}
2694
2695/*
2696 * Execute BEFORE ROW DELETE triggers.
2697 *
2698 * True indicates caller can proceed with the delete. False indicates caller
2699 * need to suppress the delete and additionally if requested, we need to pass
2700 * back the concurrently updated tuple if any.
2701 */
2702bool
2709 TM_FailureData *tmfd,
2710 bool is_merge_delete)
2711{
2713 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
2714 bool result = true;
2717 bool should_free = false;
2718 int i;
2719
2721 if (fdw_trigtuple == NULL)
2722 {
2724
2725 /*
2726 * Get a copy of the on-disk tuple we are planning to delete. In
2727 * general, if the tuple has been concurrently updated, we should
2728 * recheck it using EPQ. However, if this is a MERGE DELETE action,
2729 * we skip this EPQ recheck and leave it to the caller (it must do
2730 * additional rechecking, and might end up executing a different
2731 * action entirely).
2732 */
2733 if (!GetTupleForTrigger(estate, epqstate, relinfo, tupleid,
2735 &epqslot_candidate, tmresult, tmfd))
2736 return false;
2737
2738 /*
2739 * If the tuple was concurrently updated and the caller of this
2740 * function requested for the updated tuple, skip the trigger
2741 * execution.
2742 */
2743 if (epqslot_candidate != NULL && epqslot != NULL)
2744 {
2746 return false;
2747 }
2748
2750 }
2751 else
2752 {
2754 ExecForceStoreHeapTuple(trigtuple, slot, false);
2755 }
2756
2761 LocTriggerData.tg_relation = relinfo->ri_RelationDesc;
2762 for (i = 0; i < trigdesc->numtriggers; i++)
2763 {
2764 HeapTuple newtuple;
2765 Trigger *trigger = &trigdesc->triggers[i];
2766
2767 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
2771 continue;
2772 if (!TriggerEnabled(estate, relinfo, trigger, LocTriggerData.tg_event,
2773 NULL, slot, NULL))
2774 continue;
2775
2776 LocTriggerData.tg_trigslot = slot;
2777 LocTriggerData.tg_trigtuple = trigtuple;
2778 LocTriggerData.tg_trigger = trigger;
2780 i,
2781 relinfo->ri_TrigFunctions,
2782 relinfo->ri_TrigInstrument,
2783 GetPerTupleMemoryContext(estate));
2784 if (newtuple == NULL)
2785 {
2786 result = false; /* tell caller to suppress delete */
2787 break;
2788 }
2789 if (newtuple != trigtuple)
2790 heap_freetuple(newtuple);
2791 }
2792 if (should_free)
2794
2795 return result;
2796}
2797
2798/*
2799 * Note: is_crosspart_update must be true if the DELETE is being performed
2800 * as part of a cross-partition update.
2801 */
2802void
2807 TransitionCaptureState *transition_capture,
2809{
2810 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
2811
2812 if (relinfo->ri_FdwRoutine && transition_capture &&
2813 transition_capture->tcs_delete_old_table)
2814 {
2815 Assert(relinfo->ri_RootResultRelInfo);
2816 ereport(ERROR,
2818 errmsg("cannot collect transition tuples from child foreign tables")));
2819 }
2820
2821 if ((trigdesc && trigdesc->trig_delete_after_row) ||
2822 (transition_capture && transition_capture->tcs_delete_old_table))
2823 {
2825
2827 if (fdw_trigtuple == NULL)
2828 GetTupleForTrigger(estate,
2829 NULL,
2830 relinfo,
2831 tupleid,
2833 slot,
2834 false,
2835 NULL,
2836 NULL,
2837 NULL);
2838 else
2840
2843 true, slot, NULL, NIL, NULL,
2844 transition_capture,
2846 }
2847}
2848
2849bool
2852{
2853 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
2856 int i;
2857
2862 LocTriggerData.tg_relation = relinfo->ri_RelationDesc;
2863
2864 ExecForceStoreHeapTuple(trigtuple, slot, false);
2865
2866 for (i = 0; i < trigdesc->numtriggers; i++)
2867 {
2869 Trigger *trigger = &trigdesc->triggers[i];
2870
2871 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
2875 continue;
2876 if (!TriggerEnabled(estate, relinfo, trigger, LocTriggerData.tg_event,
2877 NULL, slot, NULL))
2878 continue;
2879
2880 LocTriggerData.tg_trigslot = slot;
2881 LocTriggerData.tg_trigtuple = trigtuple;
2882 LocTriggerData.tg_trigger = trigger;
2884 i,
2885 relinfo->ri_TrigFunctions,
2886 relinfo->ri_TrigInstrument,
2887 GetPerTupleMemoryContext(estate));
2888 if (rettuple == NULL)
2889 return false; /* Delete was suppressed */
2890 if (rettuple != trigtuple)
2892 }
2893 return true;
2894}
2895
2896void
2898{
2899 TriggerDesc *trigdesc;
2900 int i;
2902 Bitmapset *updatedCols;
2903
2904 trigdesc = relinfo->ri_TrigDesc;
2905
2906 if (trigdesc == NULL)
2907 return;
2908 if (!trigdesc->trig_update_before_statement)
2909 return;
2910
2911 /* no-op if we already fired BS triggers in this context */
2913 CMD_UPDATE))
2914 return;
2915
2916 /* statement-level triggers operate on the parent table */
2917 Assert(relinfo->ri_RootResultRelInfo == NULL);
2918
2919 updatedCols = ExecGetAllUpdatedCols(relinfo, estate);
2920
2924 LocTriggerData.tg_relation = relinfo->ri_RelationDesc;
2925 LocTriggerData.tg_updatedcols = updatedCols;
2926 for (i = 0; i < trigdesc->numtriggers; i++)
2927 {
2928 Trigger *trigger = &trigdesc->triggers[i];
2929 HeapTuple newtuple;
2930
2931 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
2935 continue;
2936 if (!TriggerEnabled(estate, relinfo, trigger, LocTriggerData.tg_event,
2937 updatedCols, NULL, NULL))
2938 continue;
2939
2940 LocTriggerData.tg_trigger = trigger;
2942 i,
2943 relinfo->ri_TrigFunctions,
2944 relinfo->ri_TrigInstrument,
2945 GetPerTupleMemoryContext(estate));
2946
2947 if (newtuple)
2948 ereport(ERROR,
2950 errmsg("BEFORE STATEMENT trigger cannot return a value")));
2951 }
2952}
2953
2954void
2956 TransitionCaptureState *transition_capture)
2957{
2958 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
2959
2960 /* statement-level triggers operate on the parent table */
2961 Assert(relinfo->ri_RootResultRelInfo == NULL);
2962
2963 if (trigdesc && trigdesc->trig_update_after_statement)
2966 false, NULL, NULL, NIL,
2968 transition_capture,
2969 false);
2970}
2971
2972bool
2979 TM_FailureData *tmfd,
2980 bool is_merge_update)
2981{
2982 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
2984 HeapTuple newtuple = NULL;
2986 bool should_free_trig = false;
2987 bool should_free_new = false;
2989 int i;
2990 Bitmapset *updatedCols;
2991 LockTupleMode lockmode;
2992
2993 /* Determine lock mode to use */
2994 lockmode = ExecUpdateLockMode(estate, relinfo);
2995
2997 if (fdw_trigtuple == NULL)
2998 {
3000
3001 /*
3002 * Get a copy of the on-disk tuple we are planning to update. In
3003 * general, if the tuple has been concurrently updated, we should
3004 * recheck it using EPQ. However, if this is a MERGE UPDATE action,
3005 * we skip this EPQ recheck and leave it to the caller (it must do
3006 * additional rechecking, and might end up executing a different
3007 * action entirely).
3008 */
3009 if (!GetTupleForTrigger(estate, epqstate, relinfo, tupleid,
3010 lockmode, oldslot, !is_merge_update,
3011 &epqslot_candidate, tmresult, tmfd))
3012 return false; /* cancel the update action */
3013
3014 /*
3015 * In READ COMMITTED isolation level it's possible that target tuple
3016 * was changed due to concurrent update. In that case we have a raw
3017 * subplan output tuple in epqslot_candidate, and need to form a new
3018 * insertable tuple using ExecGetUpdateNewTuple to replace the one we
3019 * received in newslot. Neither we nor our callers have any further
3020 * interest in the passed-in tuple, so it's okay to overwrite newslot
3021 * with the newer data.
3022 */
3023 if (epqslot_candidate != NULL)
3024 {
3026
3028 oldslot);
3029
3030 /*
3031 * Typically, the caller's newslot was also generated by
3032 * ExecGetUpdateNewTuple, so that epqslot_clean will be the same
3033 * slot and copying is not needed. But do the right thing if it
3034 * isn't.
3035 */
3038
3039 /*
3040 * At this point newslot contains a virtual tuple that may
3041 * reference some fields of oldslot's tuple in some disk buffer.
3042 * If that tuple is in a different page than the original target
3043 * tuple, then our only pin on that buffer is oldslot's, and we're
3044 * about to release it. Hence we'd better materialize newslot to
3045 * ensure it doesn't contain references into an unpinned buffer.
3046 * (We'd materialize it below anyway, but too late for safety.)
3047 */
3049 }
3050
3051 /*
3052 * Here we convert oldslot to a materialized slot holding trigtuple.
3053 * Neither slot passed to the triggers will hold any buffer pin.
3054 */
3056 }
3057 else
3058 {
3059 /* Put the FDW-supplied tuple into oldslot to unify the cases */
3062 }
3063
3068 LocTriggerData.tg_relation = relinfo->ri_RelationDesc;
3069 updatedCols = ExecGetAllUpdatedCols(relinfo, estate);
3070 LocTriggerData.tg_updatedcols = updatedCols;
3071 for (i = 0; i < trigdesc->numtriggers; i++)
3072 {
3073 Trigger *trigger = &trigdesc->triggers[i];
3074 HeapTuple oldtuple;
3075
3076 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
3080 continue;
3081 if (!TriggerEnabled(estate, relinfo, trigger, LocTriggerData.tg_event,
3082 updatedCols, oldslot, newslot))
3083 continue;
3084
3085 if (!newtuple)
3087
3088 LocTriggerData.tg_trigslot = oldslot;
3089 LocTriggerData.tg_trigtuple = trigtuple;
3090 LocTriggerData.tg_newtuple = oldtuple = newtuple;
3091 LocTriggerData.tg_newslot = newslot;
3092 LocTriggerData.tg_trigger = trigger;
3094 i,
3095 relinfo->ri_TrigFunctions,
3096 relinfo->ri_TrigInstrument,
3097 GetPerTupleMemoryContext(estate));
3098
3099 if (newtuple == NULL)
3100 {
3101 if (should_free_trig)
3103 if (should_free_new)
3104 heap_freetuple(oldtuple);
3105 return false; /* "do nothing" */
3106 }
3107 else if (newtuple != oldtuple)
3108 {
3109 newtuple = check_modified_virtual_generated(RelationGetDescr(relinfo->ri_RelationDesc), newtuple);
3110
3111 ExecForceStoreHeapTuple(newtuple, newslot, false);
3112
3113 /*
3114 * If the tuple returned by the trigger / being stored, is the old
3115 * row version, and the heap tuple passed to the trigger was
3116 * allocated locally, materialize the slot. Otherwise we might
3117 * free it while still referenced by the slot.
3118 */
3119 if (should_free_trig && newtuple == trigtuple)
3121
3122 if (should_free_new)
3123 heap_freetuple(oldtuple);
3124
3125 /* signal tuple should be re-fetched if used */
3126 newtuple = NULL;
3127 }
3128 }
3129 if (should_free_trig)
3131
3132 return true;
3133}
3134
3135/*
3136 * Note: 'src_partinfo' and 'dst_partinfo', when non-NULL, refer to the source
3137 * and destination partitions, respectively, of a cross-partition update of
3138 * the root partitioned table mentioned in the query, given by 'relinfo'.
3139 * 'tupleid' in that case refers to the ctid of the "old" tuple in the source
3140 * partition, and 'newslot' contains the "new" tuple in the destination
3141 * partition. This interface allows to support the requirements of
3142 * ExecCrossPartitionUpdateForeignKey(); is_crosspart_update must be true in
3143 * that case.
3144 */
3145void
3153 TransitionCaptureState *transition_capture,
3155{
3156 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
3157
3158 if (relinfo->ri_FdwRoutine && transition_capture &&
3159 (transition_capture->tcs_update_old_table ||
3160 transition_capture->tcs_update_new_table))
3161 {
3162 Assert(relinfo->ri_RootResultRelInfo);
3163 ereport(ERROR,
3165 errmsg("cannot collect transition tuples from child foreign tables")));
3166 }
3167
3168 if ((trigdesc && trigdesc->trig_update_after_row) ||
3169 (transition_capture &&
3170 (transition_capture->tcs_update_old_table ||
3171 transition_capture->tcs_update_new_table)))
3172 {
3173 /*
3174 * Note: if the UPDATE is converted into a DELETE+INSERT as part of
3175 * update-partition-key operation, then this function is also called
3176 * separately for DELETE and INSERT to capture transition table rows.
3177 * In such case, either old tuple or new tuple can be NULL.
3178 */
3181
3184
3187
3189 GetTupleForTrigger(estate,
3190 NULL,
3191 tupsrc,
3192 tupleid,
3194 oldslot,
3195 false,
3196 NULL,
3197 NULL,
3198 NULL);
3199 else if (fdw_trigtuple != NULL)
3201 else
3203
3207 true,
3210 transition_capture,
3212 }
3213}
3214
3215bool
3218{
3219 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
3221 HeapTuple newtuple = NULL;
3222 bool should_free;
3224 int i;
3225
3230 LocTriggerData.tg_relation = relinfo->ri_RelationDesc;
3231
3233
3234 for (i = 0; i < trigdesc->numtriggers; i++)
3235 {
3236 Trigger *trigger = &trigdesc->triggers[i];
3237 HeapTuple oldtuple;
3238
3239 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
3243 continue;
3244 if (!TriggerEnabled(estate, relinfo, trigger, LocTriggerData.tg_event,
3245 NULL, oldslot, newslot))
3246 continue;
3247
3248 if (!newtuple)
3249 newtuple = ExecFetchSlotHeapTuple(newslot, true, &should_free);
3250
3251 LocTriggerData.tg_trigslot = oldslot;
3252 LocTriggerData.tg_trigtuple = trigtuple;
3253 LocTriggerData.tg_newslot = newslot;
3254 LocTriggerData.tg_newtuple = oldtuple = newtuple;
3255
3256 LocTriggerData.tg_trigger = trigger;
3258 i,
3259 relinfo->ri_TrigFunctions,
3260 relinfo->ri_TrigInstrument,
3261 GetPerTupleMemoryContext(estate));
3262 if (newtuple == NULL)
3263 {
3264 return false; /* "do nothing" */
3265 }
3266 else if (newtuple != oldtuple)
3267 {
3268 ExecForceStoreHeapTuple(newtuple, newslot, false);
3269
3270 if (should_free)
3271 heap_freetuple(oldtuple);
3272
3273 /* signal tuple should be re-fetched if used */
3274 newtuple = NULL;
3275 }
3276 }
3277
3278 return true;
3279}
3280
3281void
3283{
3284 TriggerDesc *trigdesc;
3285 int i;
3287
3288 trigdesc = relinfo->ri_TrigDesc;
3289
3290 if (trigdesc == NULL)
3291 return;
3292 if (!trigdesc->trig_truncate_before_statement)
3293 return;
3294
3298 LocTriggerData.tg_relation = relinfo->ri_RelationDesc;
3299
3300 for (i = 0; i < trigdesc->numtriggers; i++)
3301 {
3302 Trigger *trigger = &trigdesc->triggers[i];
3303 HeapTuple newtuple;
3304
3305 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
3309 continue;
3310 if (!TriggerEnabled(estate, relinfo, trigger, LocTriggerData.tg_event,
3311 NULL, NULL, NULL))
3312 continue;
3313
3314 LocTriggerData.tg_trigger = trigger;
3316 i,
3317 relinfo->ri_TrigFunctions,
3318 relinfo->ri_TrigInstrument,
3319 GetPerTupleMemoryContext(estate));
3320
3321 if (newtuple)
3322 ereport(ERROR,
3324 errmsg("BEFORE STATEMENT trigger cannot return a value")));
3325 }
3326}
3327
3328void
3330{
3331 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
3332
3333 if (trigdesc && trigdesc->trig_truncate_after_statement)
3335 NULL, NULL,
3337 false, NULL, NULL, NIL, NULL, NULL,
3338 false);
3339}
3340
3341
3342/*
3343 * Fetch tuple into "oldslot", dealing with locking and EPQ if necessary
3344 */
3345static bool
3347 EPQState *epqstate,
3349 ItemPointer tid,
3350 LockTupleMode lockmode,
3352 bool do_epq_recheck,
3356{
3357 Relation relation = relinfo->ri_RelationDesc;
3358
3359 if (epqslot != NULL)
3360 {
3362 TM_FailureData tmfd;
3363 int lockflags = 0;
3364
3365 *epqslot = NULL;
3366
3367 /* caller must pass an epqstate if EvalPlanQual is possible */
3368 Assert(epqstate != NULL);
3369
3370 /*
3371 * lock tuple for update
3372 */
3375 test = table_tuple_lock(relation, tid, estate->es_snapshot, oldslot,
3376 estate->es_output_cid,
3377 lockmode, LockWaitBlock,
3378 lockflags,
3379 &tmfd);
3380
3381 /* Let the caller know about the status of this operation */
3382 if (tmresultp)
3383 *tmresultp = test;
3384 if (tmfdp)
3385 *tmfdp = tmfd;
3386
3387 switch (test)
3388 {
3389 case TM_SelfModified:
3390
3391 /*
3392 * The target tuple was already updated or deleted by the
3393 * current command, or by a later command in the current
3394 * transaction. We ignore the tuple in the former case, and
3395 * throw error in the latter case, for the same reasons
3396 * enumerated in ExecUpdate and ExecDelete in
3397 * nodeModifyTable.c.
3398 */
3399 if (tmfd.cmax != estate->es_output_cid)
3400 ereport(ERROR,
3402 errmsg("tuple to be updated was already modified by an operation triggered by the current command"),
3403 errhint("Consider using an AFTER trigger instead of a BEFORE trigger to propagate changes to other rows.")));
3404
3405 /* treat it as deleted; do not process */
3406 return false;
3407
3408 case TM_Ok:
3409 if (tmfd.traversed)
3410 {
3411 /*
3412 * Recheck the tuple using EPQ, if requested. Otherwise,
3413 * just return that it was concurrently updated.
3414 */
3415 if (do_epq_recheck)
3416 {
3417 *epqslot = EvalPlanQual(epqstate,
3418 relation,
3419 relinfo->ri_RangeTableIndex,
3420 oldslot);
3421
3422 /*
3423 * If PlanQual failed for updated tuple - we must not
3424 * process this tuple!
3425 */
3426 if (TupIsNull(*epqslot))
3427 {
3428 *epqslot = NULL;
3429 return false;
3430 }
3431 }
3432 else
3433 {
3434 if (tmresultp)
3436 return false;
3437 }
3438 }
3439 break;
3440
3441 case TM_Updated:
3443 ereport(ERROR,
3445 errmsg("could not serialize access due to concurrent update")));
3446 elog(ERROR, "unexpected table_tuple_lock status: %u", test);
3447 break;
3448
3449 case TM_Deleted:
3451 ereport(ERROR,
3453 errmsg("could not serialize access due to concurrent delete")));
3454 /* tuple was deleted */
3455 return false;
3456
3457 case TM_Invisible:
3458 elog(ERROR, "attempted to lock invisible tuple");
3459 break;
3460
3461 default:
3462 elog(ERROR, "unrecognized table_tuple_lock status: %u", test);
3463 return false; /* keep compiler quiet */
3464 }
3465 }
3466 else
3467 {
3468 /*
3469 * We expect the tuple to be present, thus very simple error handling
3470 * suffices.
3471 */
3472 if (!table_tuple_fetch_row_version(relation, tid, SnapshotAny,
3473 oldslot))
3474 elog(ERROR, "failed to fetch tuple for trigger");
3475 }
3476
3477 return true;
3478}
3479
3480/*
3481 * Is trigger enabled to fire?
3482 */
3483static bool
3488{
3489 /* Check replication-role-dependent enable state */
3491 {
3492 if (trigger->tgenabled == TRIGGER_FIRES_ON_ORIGIN ||
3493 trigger->tgenabled == TRIGGER_DISABLED)
3494 return false;
3495 }
3496 else /* ORIGIN or LOCAL role */
3497 {
3498 if (trigger->tgenabled == TRIGGER_FIRES_ON_REPLICA ||
3499 trigger->tgenabled == TRIGGER_DISABLED)
3500 return false;
3501 }
3502
3503 /*
3504 * Check for column-specific trigger (only possible for UPDATE, and in
3505 * fact we *must* ignore tgattr for other event types)
3506 */
3507 if (trigger->tgnattr > 0 && TRIGGER_FIRED_BY_UPDATE(event))
3508 {
3509 int i;
3510 bool modified;
3511
3512 modified = false;
3513 for (i = 0; i < trigger->tgnattr; i++)
3514 {
3516 modifiedCols))
3517 {
3518 modified = true;
3519 break;
3520 }
3521 }
3522 if (!modified)
3523 return false;
3524 }
3525
3526 /* Check for WHEN clause */
3527 if (trigger->tgqual)
3528 {
3530 ExprContext *econtext;
3532 int i;
3533
3534 Assert(estate != NULL);
3535
3536 /*
3537 * trigger is an element of relinfo->ri_TrigDesc->triggers[]; find the
3538 * matching element of relinfo->ri_TrigWhenExprs[]
3539 */
3540 i = trigger - relinfo->ri_TrigDesc->triggers;
3541 predicate = &relinfo->ri_TrigWhenExprs[i];
3542
3543 /*
3544 * If first time through for this WHEN expression, build expression
3545 * nodetrees for it. Keep them in the per-query memory context so
3546 * they'll survive throughout the query.
3547 */
3548 if (*predicate == NULL)
3549 {
3550 Node *tgqual;
3551
3553 tgqual = stringToNode(trigger->tgqual);
3554 tgqual = expand_generated_columns_in_expr(tgqual, relinfo->ri_RelationDesc, PRS2_OLD_VARNO);
3555 tgqual = expand_generated_columns_in_expr(tgqual, relinfo->ri_RelationDesc, PRS2_NEW_VARNO);
3556 /* Change references to OLD and NEW to INNER_VAR and OUTER_VAR */
3559 /* ExecPrepareQual wants implicit-AND form */
3560 tgqual = (Node *) make_ands_implicit((Expr *) tgqual);
3561 *predicate = ExecPrepareQual((List *) tgqual, estate);
3563 }
3564
3565 /*
3566 * We will use the EState's per-tuple context for evaluating WHEN
3567 * expressions (creating it if it's not already there).
3568 */
3569 econtext = GetPerTupleExprContext(estate);
3570
3571 /*
3572 * Finally evaluate the expression, making the old and/or new tuples
3573 * available as INNER_VAR/OUTER_VAR respectively.
3574 */
3575 econtext->ecxt_innertuple = oldslot;
3576 econtext->ecxt_outertuple = newslot;
3577 if (!ExecQual(*predicate, econtext))
3578 return false;
3579 }
3580
3581 return true;
3582}
3583
3584
3585/* ----------
3586 * After-trigger stuff
3587 *
3588 * The AfterTriggersData struct holds data about pending AFTER trigger events
3589 * during the current transaction tree. (BEFORE triggers are fired
3590 * immediately so we don't need any persistent state about them.) The struct
3591 * and most of its subsidiary data are kept in TopTransactionContext; however
3592 * some data that can be discarded sooner appears in the CurTransactionContext
3593 * of the relevant subtransaction. Also, the individual event records are
3594 * kept in a separate sub-context of TopTransactionContext. This is done
3595 * mainly so that it's easy to tell from a memory context dump how much space
3596 * is being eaten by trigger events.
3597 *
3598 * Because the list of pending events can grow large, we go to some
3599 * considerable effort to minimize per-event memory consumption. The event
3600 * records are grouped into chunks and common data for similar events in the
3601 * same chunk is only stored once.
3602 *
3603 * XXX We need to be able to save the per-event data in a file if it grows too
3604 * large.
3605 * ----------
3606 */
3607
3608/* Per-trigger SET CONSTRAINT status */
3614
3616
3617/*
3618 * SET CONSTRAINT intra-transaction status.
3619 *
3620 * We make this a single palloc'd object so it can be copied and freed easily.
3621 *
3622 * all_isset and all_isdeferred are used to keep track
3623 * of SET CONSTRAINTS ALL {DEFERRED, IMMEDIATE}.
3624 *
3625 * trigstates[] stores per-trigger tgisdeferred settings.
3626 */
3628{
3631 int numstates; /* number of trigstates[] entries in use */
3632 int numalloc; /* allocated size of trigstates[] */
3635
3637
3638
3639/*
3640 * Per-trigger-event data
3641 *
3642 * The actual per-event data, AfterTriggerEventData, includes DONE/IN_PROGRESS
3643 * status bits, up to two tuple CTIDs, and optionally two OIDs of partitions.
3644 * Each event record also has an associated AfterTriggerSharedData that is
3645 * shared across all instances of similar events within a "chunk".
3646 *
3647 * For row-level triggers, we arrange not to waste storage on unneeded ctid
3648 * fields. Updates of regular tables use two; inserts and deletes of regular
3649 * tables use one; foreign tables always use zero and save the tuple(s) to a
3650 * tuplestore. AFTER_TRIGGER_FDW_FETCH directs AfterTriggerExecute() to
3651 * retrieve a fresh tuple or pair of tuples from that tuplestore, while
3652 * AFTER_TRIGGER_FDW_REUSE directs it to use the most-recently-retrieved
3653 * tuple(s). This permits storing tuples once regardless of the number of
3654 * row-level triggers on a foreign table.
3655 *
3656 * When updates on partitioned tables cause rows to move between partitions,
3657 * the OIDs of both partitions are stored too, so that the tuples can be
3658 * fetched; such entries are marked AFTER_TRIGGER_CP_UPDATE (for "cross-
3659 * partition update").
3660 *
3661 * Note that we need triggers on foreign tables to be fired in exactly the
3662 * order they were queued, so that the tuples come out of the tuplestore in
3663 * the right order. To ensure that, we forbid deferrable (constraint)
3664 * triggers on foreign tables. This also ensures that such triggers do not
3665 * get deferred into outer trigger query levels, meaning that it's okay to
3666 * destroy the tuplestore at the end of the query level.
3667 *
3668 * Statement-level triggers always bear AFTER_TRIGGER_1CTID, though they
3669 * require no ctid field. We lack the flag bit space to neatly represent that
3670 * distinct case, and it seems unlikely to be worth much trouble.
3671 *
3672 * Note: ats_firing_id is initially zero and is set to something else when
3673 * AFTER_TRIGGER_IN_PROGRESS is set. It indicates which trigger firing
3674 * cycle the trigger will be fired in (or was fired in, if DONE is set).
3675 * Although this is mutable state, we can keep it in AfterTriggerSharedData
3676 * because all instances of the same type of event in a given event list will
3677 * be fired at the same time, if they were queued between the same firing
3678 * cycles. So we need only ensure that ats_firing_id is zero when attaching
3679 * a new event to an existing AfterTriggerSharedData record.
3680 */
3682
3683#define AFTER_TRIGGER_OFFSET 0x07FFFFFF /* must be low-order bits */
3684#define AFTER_TRIGGER_DONE 0x80000000
3685#define AFTER_TRIGGER_IN_PROGRESS 0x40000000
3686/* bits describing the size and tuple sources of this event */
3687#define AFTER_TRIGGER_FDW_REUSE 0x00000000
3688#define AFTER_TRIGGER_FDW_FETCH 0x20000000
3689#define AFTER_TRIGGER_1CTID 0x10000000
3690#define AFTER_TRIGGER_2CTID 0x30000000
3691#define AFTER_TRIGGER_CP_UPDATE 0x08000000
3692#define AFTER_TRIGGER_TUP_BITS 0x38000000
3694
3696{
3697 TriggerEvent ats_event; /* event type indicator, see trigger.h */
3698 Oid ats_tgoid; /* the trigger's ID */
3699 Oid ats_relid; /* the relation it's on */
3700 Oid ats_rolid; /* role to execute the trigger */
3701 CommandId ats_firing_id; /* ID for firing cycle */
3702 struct AfterTriggersTableData *ats_table; /* transition table access */
3703 Bitmapset *ats_modifiedcols; /* modified columns */
3705
3707
3709{
3710 TriggerFlags ate_flags; /* status bits and offset to shared data */
3711 ItemPointerData ate_ctid1; /* inserted, deleted, or old updated tuple */
3712 ItemPointerData ate_ctid2; /* new updated tuple */
3713
3714 /*
3715 * During a cross-partition update of a partitioned table, we also store
3716 * the OIDs of source and destination partitions that are needed to fetch
3717 * the old (ctid1) and the new tuple (ctid2) from, respectively.
3718 */
3722
3723/* AfterTriggerEventData, minus ate_src_part, ate_dst_part */
3730
3731/* AfterTriggerEventData, minus ate_*_part and ate_ctid2 */
3733{
3734 TriggerFlags ate_flags; /* status bits and offset to shared data */
3735 ItemPointerData ate_ctid1; /* inserted, deleted, or old updated tuple */
3737
3738/* AfterTriggerEventData, minus ate_*_part, ate_ctid1 and ate_ctid2 */
3740{
3741 TriggerFlags ate_flags; /* status bits and offset to shared data */
3743
3744#define SizeofTriggerEvent(evt) \
3745 (((evt)->ate_flags & AFTER_TRIGGER_TUP_BITS) == AFTER_TRIGGER_CP_UPDATE ? \
3746 sizeof(AfterTriggerEventData) : \
3747 (((evt)->ate_flags & AFTER_TRIGGER_TUP_BITS) == AFTER_TRIGGER_2CTID ? \
3748 sizeof(AfterTriggerEventDataNoOids) : \
3749 (((evt)->ate_flags & AFTER_TRIGGER_TUP_BITS) == AFTER_TRIGGER_1CTID ? \
3750 sizeof(AfterTriggerEventDataOneCtid) : \
3751 sizeof(AfterTriggerEventDataZeroCtids))))
3752
3753#define GetTriggerSharedData(evt) \
3754 ((AfterTriggerShared) ((char *) (evt) + ((evt)->ate_flags & AFTER_TRIGGER_OFFSET)))
3755
3756/*
3757 * To avoid palloc overhead, we keep trigger events in arrays in successively-
3758 * larger chunks (a slightly more sophisticated version of an expansible
3759 * array). The space between CHUNK_DATA_START and freeptr is occupied by
3760 * AfterTriggerEventData records; the space between endfree and endptr is
3761 * occupied by AfterTriggerSharedData records.
3762 */
3764{
3765 struct AfterTriggerEventChunk *next; /* list link */
3766 char *freeptr; /* start of free space in chunk */
3767 char *endfree; /* end of free space in chunk */
3768 char *endptr; /* end of chunk */
3769 /* event data follows here */
3771
3772#define CHUNK_DATA_START(cptr) ((char *) (cptr) + MAXALIGN(sizeof(AfterTriggerEventChunk)))
3773
3774/* A list of events */
3781
3782/* Macros to help in iterating over a list of events */
3783#define for_each_chunk(cptr, evtlist) \
3784 for (cptr = (evtlist).head; cptr != NULL; cptr = cptr->next)
3785#define for_each_event(eptr, cptr) \
3786 for (eptr = (AfterTriggerEvent) CHUNK_DATA_START(cptr); \
3787 (char *) eptr < (cptr)->freeptr; \
3788 eptr = (AfterTriggerEvent) (((char *) eptr) + SizeofTriggerEvent(eptr)))
3789/* Use this if no special per-chunk processing is needed */
3790#define for_each_event_chunk(eptr, cptr, evtlist) \
3791 for_each_chunk(cptr, evtlist) for_each_event(eptr, cptr)
3792
3793/* Macros for iterating from a start point that might not be list start */
3794#define for_each_chunk_from(cptr) \
3795 for (; cptr != NULL; cptr = cptr->next)
3796#define for_each_event_from(eptr, cptr) \
3797 for (; \
3798 (char *) eptr < (cptr)->freeptr; \
3799 eptr = (AfterTriggerEvent) (((char *) eptr) + SizeofTriggerEvent(eptr)))
3800
3801
3802/*
3803 * All per-transaction data for the AFTER TRIGGERS module.
3804 *
3805 * AfterTriggersData has the following fields:
3806 *
3807 * firing_counter is incremented for each call of afterTriggerInvokeEvents.
3808 * We mark firable events with the current firing cycle's ID so that we can
3809 * tell which ones to work on. This ensures sane behavior if a trigger
3810 * function chooses to do SET CONSTRAINTS: the inner SET CONSTRAINTS will
3811 * only fire those events that weren't already scheduled for firing.
3812 *
3813 * state keeps track of the transaction-local effects of SET CONSTRAINTS.
3814 * This is saved and restored across failed subtransactions.
3815 *
3816 * events is the current list of deferred events. This is global across
3817 * all subtransactions of the current transaction. In a subtransaction
3818 * abort, we know that the events added by the subtransaction are at the
3819 * end of the list, so it is relatively easy to discard them. The event
3820 * list chunks themselves are stored in event_cxt.
3821 *
3822 * query_depth is the current depth of nested AfterTriggerBeginQuery calls
3823 * (-1 when the stack is empty).
3824 *
3825 * query_stack[query_depth] is the per-query-level data, including these fields:
3826 *
3827 * events is a list of AFTER trigger events queued by the current query.
3828 * None of these are valid until the matching AfterTriggerEndQuery call
3829 * occurs. At that point we fire immediate-mode triggers, and append any
3830 * deferred events to the main events list.
3831 *
3832 * fdw_tuplestore is a tuplestore containing the foreign-table tuples
3833 * needed by events queued by the current query. (Note: we use just one
3834 * tuplestore even though more than one foreign table might be involved.
3835 * This is okay because tuplestores don't really care what's in the tuples
3836 * they store; but it's possible that someday it'd break.)
3837 *
3838 * tables is a List of AfterTriggersTableData structs for target tables
3839 * of the current query (see below).
3840 *
3841 * maxquerydepth is just the allocated length of query_stack.
3842 *
3843 * trans_stack holds per-subtransaction data, including these fields:
3844 *
3845 * state is NULL or a pointer to a saved copy of the SET CONSTRAINTS
3846 * state data. Each subtransaction level that modifies that state first
3847 * saves a copy, which we use to restore the state if we abort.
3848 *
3849 * events is a copy of the events head/tail pointers,
3850 * which we use to restore those values during subtransaction abort.
3851 *
3852 * query_depth is the subtransaction-start-time value of query_depth,
3853 * which we similarly use to clean up at subtransaction abort.
3854 *
3855 * firing_counter is the subtransaction-start-time value of firing_counter.
3856 * We use this to recognize which deferred triggers were fired (or marked
3857 * for firing) within an aborted subtransaction.
3858 *
3859 * We use GetCurrentTransactionNestLevel() to determine the correct array
3860 * index in trans_stack. maxtransdepth is the number of allocated entries in
3861 * trans_stack. (By not keeping our own stack pointer, we can avoid trouble
3862 * in cases where errors during subxact abort cause multiple invocations
3863 * of AfterTriggerEndSubXact() at the same nesting depth.)
3864 *
3865 * We create an AfterTriggersTableData struct for each target table of the
3866 * current query, and each operation mode (INSERT/UPDATE/DELETE), that has
3867 * either transition tables or statement-level triggers. This is used to
3868 * hold the relevant transition tables, as well as info tracking whether
3869 * we already queued the statement triggers. (We use that info to prevent
3870 * firing the same statement triggers more than once per statement, or really
3871 * once per transition table set.) These structs, along with the transition
3872 * table tuplestores, live in the (sub)transaction's CurTransactionContext.
3873 * That's sufficient lifespan because we don't allow transition tables to be
3874 * used by deferrable triggers, so they only need to survive until
3875 * AfterTriggerEndQuery.
3876 */
3880
3881typedef struct AfterTriggersData
3882{
3883 CommandId firing_counter; /* next firing ID to assign */
3884 SetConstraintState state; /* the active S C state */
3885 AfterTriggerEventList events; /* deferred-event list */
3886 MemoryContext event_cxt; /* memory context for events, if any */
3887
3888 /* per-query-level data: */
3889 AfterTriggersQueryData *query_stack; /* array of structs shown below */
3890 int query_depth; /* current index in above array */
3891 int maxquerydepth; /* allocated len of above array */
3892
3893 /* per-subtransaction-level data: */
3894 AfterTriggersTransData *trans_stack; /* array of structs shown below */
3895 int maxtransdepth; /* allocated len of above array */
3896
3897 List *batch_callbacks; /* List of AfterTriggerCallbackItem */
3899
3901{
3902 AfterTriggerEventList events; /* events pending from this query */
3903 Tuplestorestate *fdw_tuplestore; /* foreign tuples for said events */
3904 List *tables; /* list of AfterTriggersTableData, see below */
3905};
3906
3908{
3909 /* these fields are just for resetting at subtrans abort: */
3910 SetConstraintState state; /* saved S C state, or NULL if not yet saved */
3911 AfterTriggerEventList events; /* saved list pointer */
3912 int query_depth; /* saved query_depth */
3913 CommandId firing_counter; /* saved firing_counter */
3914};
3915
3917{
3918 /* relid + cmdType form the lookup key for these structs: */
3919 Oid relid; /* target table's OID */
3920 CmdType cmdType; /* event type, CMD_INSERT/UPDATE/DELETE */
3921 bool closed; /* true when no longer OK to add tuples */
3922 bool before_trig_done; /* did we already queue BS triggers? */
3923 bool after_trig_done; /* did we already queue AS triggers? */
3924 AfterTriggerEventList after_trig_events; /* if so, saved list pointer */
3925
3926 /* "old" transition table for UPDATE/DELETE, if any */
3928 /* "new" transition table for INSERT/UPDATE, if any */
3930
3931 TupleTableSlot *storeslot; /* for converting to tuplestore's format */
3932};
3933
3934/* Entry in afterTriggers.batch_callbacks */
3940
3942
3943/*
3944 * Incremented before invoking afterTriggerInvokeEvents(). Used by
3945 * AfterTriggerIsActive() to determine whether batch callbacks will fire,
3946 * so that RI trigger functions can take the batched fast path.
3947 */
3949
3950static void AfterTriggerExecute(EState *estate,
3951 AfterTriggerEvent event,
3955 TriggerDesc *trigdesc,
3956 FmgrInfo *finfo,
3962 CmdType cmdType);
3964 TupleDesc tupdesc);
3968 TransitionCaptureState *transition_capture);
3969static void TransitionTableAddTuple(EState *estate,
3970 int event,
3971 TransitionCaptureState *transition_capture,
3973 TupleTableSlot *slot,
3975 Tuplestorestate *tuplestore);
3977static SetConstraintState SetConstraintStateCreate(int numalloc);
3980 Oid tgoid, bool tgisdeferred);
3981static void cancel_prior_stmt_triggers(Oid relid, CmdType cmdType, int tgevent);
3982
3983static void FireAfterTriggerBatchCallbacks(void);
3984
3985/*
3986 * Get the FDW tuplestore for the current trigger query level, creating it
3987 * if necessary.
3988 */
3989static Tuplestorestate *
3991{
3992 Tuplestorestate *ret;
3993
3995 if (ret == NULL)
3996 {
3999
4000 /*
4001 * Make the tuplestore valid until end of subtransaction. We really
4002 * only need it until AfterTriggerEndQuery().
4003 */
4007
4008 ret = tuplestore_begin_heap(false, false, work_mem);
4009
4012
4014 }
4015
4016 return ret;
4017}
4018
4019/* ----------
4020 * afterTriggerCheckState()
4021 *
4022 * Returns true if the trigger event is actually in state DEFERRED.
4023 * ----------
4024 */
4025static bool
4027{
4028 Oid tgoid = evtshared->ats_tgoid;
4030 int i;
4031
4032 /*
4033 * For not-deferrable triggers (i.e. normal AFTER ROW triggers and
4034 * constraints declared NOT DEFERRABLE), the state is always false.
4035 */
4036 if ((evtshared->ats_event & AFTER_TRIGGER_DEFERRABLE) == 0)
4037 return false;
4038
4039 /*
4040 * If constraint state exists, SET CONSTRAINTS might have been executed
4041 * either for this trigger or for all triggers.
4042 */
4043 if (state != NULL)
4044 {
4045 /* Check for SET CONSTRAINTS for this specific trigger. */
4046 for (i = 0; i < state->numstates; i++)
4047 {
4048 if (state->trigstates[i].sct_tgoid == tgoid)
4049 return state->trigstates[i].sct_tgisdeferred;
4050 }
4051
4052 /* Check for SET CONSTRAINTS ALL. */
4053 if (state->all_isset)
4054 return state->all_isdeferred;
4055 }
4056
4057 /*
4058 * Otherwise return the default state for the trigger.
4059 */
4060 return ((evtshared->ats_event & AFTER_TRIGGER_INITDEFERRED) != 0);
4061}
4062
4063/* ----------
4064 * afterTriggerCopyBitmap()
4065 *
4066 * Copy bitmap into AfterTriggerEvents memory context, which is where the after
4067 * trigger events are kept.
4068 * ----------
4069 */
4070static Bitmapset *
4072{
4073 Bitmapset *dst;
4075
4076 if (src == NULL)
4077 return NULL;
4078
4080
4081 dst = bms_copy(src);
4082
4084
4085 return dst;
4086}
4087
4088/* ----------
4089 * afterTriggerAddEvent()
4090 *
4091 * Add a new trigger event to the specified queue.
4092 * The passed-in event data is copied.
4093 * ----------
4094 */
4095static void
4098{
4104
4105 /*
4106 * If empty list or not enough room in the tail chunk, make a new chunk.
4107 * We assume here that a new shared record will always be needed.
4108 */
4109 chunk = events->tail;
4110 if (chunk == NULL ||
4111 chunk->endfree - chunk->freeptr < needed)
4112 {
4114
4115 /* Create event context if we didn't already */
4119 "AfterTriggerEvents",
4121
4122 /*
4123 * Chunk size starts at 1KB and is allowed to increase up to 1MB.
4124 * These numbers are fairly arbitrary, though there is a hard limit at
4125 * AFTER_TRIGGER_OFFSET; else we couldn't link event records to their
4126 * shared records using the available space in ate_flags. Another
4127 * constraint is that if the chunk size gets too huge, the search loop
4128 * below would get slow given a (not too common) usage pattern with
4129 * many distinct event types in a chunk. Therefore, we double the
4130 * preceding chunk size only if there weren't too many shared records
4131 * in the preceding chunk; otherwise we halve it. This gives us some
4132 * ability to adapt to the actual usage pattern of the current query
4133 * while still having large chunk sizes in typical usage. All chunk
4134 * sizes used should be MAXALIGN multiples, to ensure that the shared
4135 * records will be aligned safely.
4136 */
4137#define MIN_CHUNK_SIZE 1024
4138#define MAX_CHUNK_SIZE (1024*1024)
4139
4140#if MAX_CHUNK_SIZE > (AFTER_TRIGGER_OFFSET+1)
4141#error MAX_CHUNK_SIZE must not exceed AFTER_TRIGGER_OFFSET
4142#endif
4143
4144 if (chunk == NULL)
4146 else
4147 {
4148 /* preceding chunk size... */
4149 chunksize = chunk->endptr - (char *) chunk;
4150 /* check number of shared records in preceding chunk */
4151 if ((chunk->endptr - chunk->endfree) <=
4152 (100 * sizeof(AfterTriggerSharedData)))
4153 chunksize *= 2; /* okay, double it */
4154 else
4155 chunksize /= 2; /* too many shared records */
4157 }
4159 chunk->next = NULL;
4160 chunk->freeptr = CHUNK_DATA_START(chunk);
4161 chunk->endptr = chunk->endfree = (char *) chunk + chunksize;
4162 Assert(chunk->endfree - chunk->freeptr >= needed);
4163
4164 if (events->tail == NULL)
4165 {
4166 Assert(events->head == NULL);
4167 events->head = chunk;
4168 }
4169 else
4170 events->tail->next = chunk;
4171 events->tail = chunk;
4172 /* events->tailfree is now out of sync, but we'll fix it below */
4173 }
4174
4175 /*
4176 * Try to locate a matching shared-data record already in the chunk. If
4177 * none, make a new one. The search begins with the most recently added
4178 * record, since newer ones are most likely to match.
4179 */
4180 for (newshared = (AfterTriggerShared) chunk->endfree;
4181 (char *) newshared < chunk->endptr;
4182 newshared++)
4183 {
4184 /* compare fields roughly by probability of them being different */
4185 if (newshared->ats_tgoid == evtshared->ats_tgoid &&
4186 newshared->ats_event == evtshared->ats_event &&
4187 newshared->ats_firing_id == 0 &&
4188 newshared->ats_table == evtshared->ats_table &&
4189 newshared->ats_relid == evtshared->ats_relid &&
4190 newshared->ats_rolid == evtshared->ats_rolid &&
4191 bms_equal(newshared->ats_modifiedcols,
4192 evtshared->ats_modifiedcols))
4193 break;
4194 }
4195 if ((char *) newshared >= chunk->endptr)
4196 {
4197 newshared = ((AfterTriggerShared) chunk->endfree) - 1;
4198 *newshared = *evtshared;
4199 /* now we must make a suitably-long-lived copy of the bitmap */
4200 newshared->ats_modifiedcols = afterTriggerCopyBitmap(evtshared->ats_modifiedcols);
4201 newshared->ats_firing_id = 0; /* just to be sure */
4202 chunk->endfree = (char *) newshared;
4203 }
4204
4205 /* Insert the data */
4206 newevent = (AfterTriggerEvent) chunk->freeptr;
4207 memcpy(newevent, event, eventsize);
4208 /* ... and link the new event to its shared record */
4209 newevent->ate_flags &= ~AFTER_TRIGGER_OFFSET;
4210 newevent->ate_flags |= (char *) newshared - (char *) newevent;
4211
4212 chunk->freeptr += eventsize;
4213 events->tailfree = chunk->freeptr;
4214}
4215
4216/* ----------
4217 * afterTriggerFreeEventList()
4218 *
4219 * Free all the event storage in the given list.
4220 * ----------
4221 */
4222static void
4224{
4226
4227 while ((chunk = events->head) != NULL)
4228 {
4229 events->head = chunk->next;
4230 pfree(chunk);
4231 }
4232 events->tail = NULL;
4233 events->tailfree = NULL;
4234}
4235
4236/* ----------
4237 * afterTriggerRestoreEventList()
4238 *
4239 * Restore an event list to its prior length, removing all the events
4240 * added since it had the value old_events.
4241 * ----------
4242 */
4243static void
4246{
4249
4250 if (old_events->tail == NULL)
4251 {
4252 /* restoring to a completely empty state, so free everything */
4254 }
4255 else
4256 {
4257 *events = *old_events;
4258 /* free any chunks after the last one we want to keep */
4259 for (chunk = events->tail->next; chunk != NULL; chunk = next_chunk)
4260 {
4261 next_chunk = chunk->next;
4262 pfree(chunk);
4263 }
4264 /* and clean up the tail chunk to be the right length */
4265 events->tail->next = NULL;
4266 events->tail->freeptr = events->tailfree;
4267
4268 /*
4269 * We don't make any effort to remove now-unused shared data records.
4270 * They might still be useful, anyway.
4271 */
4272 }
4273}
4274
4275/* ----------
4276 * afterTriggerDeleteHeadEventChunk()
4277 *
4278 * Remove the first chunk of events from the query level's event list.
4279 * Keep any event list pointers elsewhere in the query level's data
4280 * structures in sync.
4281 * ----------
4282 */
4283static void
4285{
4286 AfterTriggerEventChunk *target = qs->events.head;
4287 ListCell *lc;
4288
4289 Assert(target && target->next);
4290
4291 /*
4292 * First, update any pointers in the per-table data, so that they won't be
4293 * dangling. Resetting obsoleted pointers to NULL will make
4294 * cancel_prior_stmt_triggers start from the list head, which is fine.
4295 */
4296 foreach(lc, qs->tables)
4297 {
4299
4300 if (table->after_trig_done &&
4301 table->after_trig_events.tail == target)
4302 {
4303 table->after_trig_events.head = NULL;
4304 table->after_trig_events.tail = NULL;
4305 table->after_trig_events.tailfree = NULL;
4306 }
4307 }
4308
4309 /* Now we can flush the head chunk */
4310 qs->events.head = target->next;
4311 pfree(target);
4312}
4313
4314
4315/* ----------
4316 * AfterTriggerExecute()
4317 *
4318 * Fetch the required tuples back from the heap and fire one
4319 * single trigger function.
4320 *
4321 * Frequently, this will be fired many times in a row for triggers of
4322 * a single relation. Therefore, we cache the open relation and provide
4323 * fmgr lookup cache space at the caller level. (For triggers fired at
4324 * the end of a query, we can even piggyback on the executor's state.)
4325 *
4326 * When fired for a cross-partition update of a partitioned table, the old
4327 * tuple is fetched using 'src_relInfo' (the source leaf partition) and
4328 * the new tuple using 'dst_relInfo' (the destination leaf partition), though
4329 * both are converted into the root partitioned table's format before passing
4330 * to the trigger function.
4331 *
4332 * event: event currently being fired.
4333 * relInfo: result relation for event.
4334 * src_relInfo: source partition of a cross-partition update
4335 * dst_relInfo: its destination partition
4336 * trigdesc: working copy of rel's trigger info.
4337 * finfo: array of fmgr lookup cache entries (one per trigger in trigdesc).
4338 * instr: array of EXPLAIN ANALYZE instrumentation nodes (one per trigger),
4339 * or NULL if no instrumentation is wanted.
4340 * per_tuple_context: memory context to call trigger function in.
4341 * trig_tuple_slot1: scratch slot for tg_trigtuple (foreign tables only)
4342 * trig_tuple_slot2: scratch slot for tg_newtuple (foreign tables only)
4343 * ----------
4344 */
4345static void
4347 AfterTriggerEvent event,
4351 TriggerDesc *trigdesc,
4352 FmgrInfo *finfo, TriggerInstrumentation *instr,
4356{
4357 Relation rel = relInfo->ri_RelationDesc;
4358 Relation src_rel = src_relInfo->ri_RelationDesc;
4359 Relation dst_rel = dst_relInfo->ri_RelationDesc;
4361 Oid tgoid = evtshared->ats_tgoid;
4364 int save_sec_context;
4366 int tgindx;
4367 bool should_free_trig = false;
4368 bool should_free_new = false;
4369
4370 /*
4371 * Locate trigger in trigdesc. It might not be present, and in fact the
4372 * trigdesc could be NULL, if the trigger was dropped since the event was
4373 * queued. In that case, silently do nothing.
4374 */
4375 if (trigdesc == NULL)
4376 return;
4377 for (tgindx = 0; tgindx < trigdesc->numtriggers; tgindx++)
4378 {
4379 if (trigdesc->triggers[tgindx].tgoid == tgoid)
4380 {
4381 LocTriggerData.tg_trigger = &(trigdesc->triggers[tgindx]);
4382 break;
4383 }
4384 }
4385 if (LocTriggerData.tg_trigger == NULL)
4386 return;
4387
4388 /*
4389 * If doing EXPLAIN ANALYZE, start charging time to this trigger. We want
4390 * to include time spent re-fetching tuples in the trigger cost.
4391 */
4392 if (instr)
4393 InstrStartTrigger(instr + tgindx);
4394
4395 /*
4396 * Fetch the required tuple(s).
4397 */
4398 switch (event->ate_flags & AFTER_TRIGGER_TUP_BITS)
4399 {
4401 {
4402 Tuplestorestate *fdw_tuplestore = GetCurrentFDWTuplestore();
4403
4404 if (!tuplestore_gettupleslot(fdw_tuplestore, true, false,
4406 elog(ERROR, "failed to fetch tuple1 for AFTER trigger");
4407
4408 if ((evtshared->ats_event & TRIGGER_EVENT_OPMASK) ==
4410 !tuplestore_gettupleslot(fdw_tuplestore, true, false,
4412 elog(ERROR, "failed to fetch tuple2 for AFTER trigger");
4413 }
4416
4417 /*
4418 * Store tuple in the slot so that tg_trigtuple does not reference
4419 * tuplestore memory. (It is formally possible for the trigger
4420 * function to queue trigger events that add to the same
4421 * tuplestore, which can push other tuples out of memory.) The
4422 * distinction is academic, because we start with a minimal tuple
4423 * that is stored as a heap tuple, constructed in different memory
4424 * context, in the slot anyway.
4425 */
4426 LocTriggerData.tg_trigslot = trig_tuple_slot1;
4427 LocTriggerData.tg_trigtuple =
4429
4430 if ((evtshared->ats_event & TRIGGER_EVENT_OPMASK) ==
4432 {
4433 LocTriggerData.tg_newslot = trig_tuple_slot2;
4434 LocTriggerData.tg_newtuple =
4436 }
4437 else
4438 {
4439 LocTriggerData.tg_newtuple = NULL;
4440 }
4441 break;
4442
4443 default:
4444 if (ItemPointerIsValid(&(event->ate_ctid1)))
4445 {
4447 src_relInfo);
4448
4450 &(event->ate_ctid1),
4452 src_slot))
4453 elog(ERROR, "failed to fetch tuple1 for AFTER trigger");
4454
4455 /*
4456 * Store the tuple fetched from the source partition into the
4457 * target (root partitioned) table slot, converting if needed.
4458 */
4459 if (src_relInfo != relInfo)
4460 {
4462
4463 LocTriggerData.tg_trigslot = ExecGetTriggerOldSlot(estate, relInfo);
4464 if (map)
4465 {
4467 src_slot,
4468 LocTriggerData.tg_trigslot);
4469 }
4470 else
4471 ExecCopySlot(LocTriggerData.tg_trigslot, src_slot);
4472 }
4473 else
4474 LocTriggerData.tg_trigslot = src_slot;
4475 LocTriggerData.tg_trigtuple =
4477 }
4478 else
4479 {
4480 LocTriggerData.tg_trigtuple = NULL;
4481 }
4482
4483 /* don't touch ctid2 if not there */
4485 (event->ate_flags & AFTER_TRIGGER_CP_UPDATE)) &&
4486 ItemPointerIsValid(&(event->ate_ctid2)))
4487 {
4489 dst_relInfo);
4490
4492 &(event->ate_ctid2),
4494 dst_slot))
4495 elog(ERROR, "failed to fetch tuple2 for AFTER trigger");
4496
4497 /*
4498 * Store the tuple fetched from the destination partition into
4499 * the target (root partitioned) table slot, converting if
4500 * needed.
4501 */
4502 if (dst_relInfo != relInfo)
4503 {
4505
4506 LocTriggerData.tg_newslot = ExecGetTriggerNewSlot(estate, relInfo);
4507 if (map)
4508 {
4510 dst_slot,
4511 LocTriggerData.tg_newslot);
4512 }
4513 else
4515 }
4516 else
4517 LocTriggerData.tg_newslot = dst_slot;
4518 LocTriggerData.tg_newtuple =
4520 }
4521 else
4522 {
4523 LocTriggerData.tg_newtuple = NULL;
4524 }
4525 }
4526
4527 /*
4528 * Set up the tuplestore information to let the trigger have access to
4529 * transition tables. When we first make a transition table available to
4530 * a trigger, mark it "closed" so that it cannot change anymore. If any
4531 * additional events of the same type get queued in the current trigger
4532 * query level, they'll go into new transition tables.
4533 */
4534 LocTriggerData.tg_oldtable = LocTriggerData.tg_newtable = NULL;
4535 if (evtshared->ats_table)
4536 {
4537 if (LocTriggerData.tg_trigger->tgoldtable)
4538 {
4539 LocTriggerData.tg_oldtable = evtshared->ats_table->old_tuplestore;
4540 evtshared->ats_table->closed = true;
4541 }
4542
4543 if (LocTriggerData.tg_trigger->tgnewtable)
4544 {
4545 LocTriggerData.tg_newtable = evtshared->ats_table->new_tuplestore;
4546 evtshared->ats_table->closed = true;
4547 }
4548 }
4549
4550 /*
4551 * Setup the remaining trigger information
4552 */
4554 LocTriggerData.tg_event =
4556 LocTriggerData.tg_relation = rel;
4557 if (TRIGGER_FOR_UPDATE(LocTriggerData.tg_trigger->tgtype))
4558 LocTriggerData.tg_updatedcols = evtshared->ats_modifiedcols;
4559
4561
4562 /*
4563 * If necessary, become the role that was active when the trigger got
4564 * queued. Note that the role might have been dropped since the trigger
4565 * was queued, but if that is a problem, we will get an error later.
4566 * Checking here would still leave a race condition.
4567 */
4568 GetUserIdAndSecContext(&save_rolid, &save_sec_context);
4569 if (save_rolid != evtshared->ats_rolid)
4571 save_sec_context | SECURITY_LOCAL_USERID_CHANGE);
4572
4573 /*
4574 * Call the trigger and throw away any possibly returned updated tuple.
4575 * (Don't let ExecCallTriggerFunc measure EXPLAIN time.)
4576 */
4578 tgindx,
4579 finfo,
4580 NULL,
4582 if (rettuple != NULL &&
4583 rettuple != LocTriggerData.tg_trigtuple &&
4584 rettuple != LocTriggerData.tg_newtuple)
4586
4587 /* Restore the current role if necessary */
4588 if (save_rolid != evtshared->ats_rolid)
4589 SetUserIdAndSecContext(save_rolid, save_sec_context);
4590
4591 /*
4592 * Release resources
4593 */
4594 if (should_free_trig)
4595 heap_freetuple(LocTriggerData.tg_trigtuple);
4596 if (should_free_new)
4597 heap_freetuple(LocTriggerData.tg_newtuple);
4598
4599 /* don't clear slots' contents if foreign table */
4600 if (trig_tuple_slot1 == NULL)
4601 {
4602 if (LocTriggerData.tg_trigslot)
4603 ExecClearTuple(LocTriggerData.tg_trigslot);
4604 if (LocTriggerData.tg_newslot)
4605 ExecClearTuple(LocTriggerData.tg_newslot);
4606 }
4607
4608 /*
4609 * If doing EXPLAIN ANALYZE, stop charging time to this trigger, and count
4610 * the firing of the trigger.
4611 */
4612 if (instr)
4613 InstrStopTrigger(instr + tgindx, 1);
4614}
4615
4616
4617/*
4618 * afterTriggerMarkEvents()
4619 *
4620 * Scan the given event list for not yet invoked events. Mark the ones
4621 * that can be invoked now with the current firing ID.
4622 *
4623 * If move_list isn't NULL, events that are not to be invoked now are
4624 * transferred to move_list.
4625 *
4626 * When immediate_only is true, do not invoke currently-deferred triggers.
4627 * (This will be false only at main transaction exit.)
4628 *
4629 * Returns true if any invokable events were found.
4630 */
4631static bool
4634 bool immediate_only)
4635{
4636 bool found = false;
4637 bool deferred_found = false;
4638 AfterTriggerEvent event;
4640
4641 for_each_event_chunk(event, chunk, *events)
4642 {
4644 bool defer_it = false;
4645
4646 if (!(event->ate_flags &
4648 {
4649 /*
4650 * This trigger hasn't been called or scheduled yet. Check if we
4651 * should call it now.
4652 */
4654 {
4655 defer_it = true;
4656 }
4657 else
4658 {
4659 /*
4660 * Mark it as to be fired in this firing cycle.
4661 */
4662 evtshared->ats_firing_id = afterTriggers.firing_counter;
4663 event->ate_flags |= AFTER_TRIGGER_IN_PROGRESS;
4664 found = true;
4665 }
4666 }
4667
4668 /*
4669 * If it's deferred, move it to move_list, if requested.
4670 */
4671 if (defer_it && move_list != NULL)
4672 {
4673 deferred_found = true;
4674 /* add it to move_list */
4676 /* mark original copy "done" so we don't do it again */
4677 event->ate_flags |= AFTER_TRIGGER_DONE;
4678 }
4679 }
4680
4681 /*
4682 * We could allow deferred triggers if, before the end of the
4683 * security-restricted operation, we were to verify that a SET CONSTRAINTS
4684 * ... IMMEDIATE has fired all such triggers. For now, don't bother.
4685 */
4687 ereport(ERROR,
4689 errmsg("cannot fire deferred trigger within security-restricted operation")));
4690
4691 return found;
4692}
4693
4694/*
4695 * afterTriggerInvokeEvents()
4696 *
4697 * Scan the given event list for events that are marked as to be fired
4698 * in the current firing cycle, and fire them.
4699 *
4700 * If estate isn't NULL, we use its result relation info to avoid repeated
4701 * openings and closing of trigger target relations. If it is NULL, we
4702 * make one locally to cache the info in case there are multiple trigger
4703 * events per rel.
4704 *
4705 * When delete_ok is true, it's safe to delete fully-processed events.
4706 * (We are not very tense about that: we simply reset a chunk to be empty
4707 * if all its events got fired. The objective here is just to avoid useless
4708 * rescanning of events when a trigger queues new events during transaction
4709 * end, so it's not necessary to worry much about the case where only
4710 * some events are fired.)
4711 *
4712 * Returns true if no unfired events remain in the list (this allows us
4713 * to avoid repeating afterTriggerMarkEvents).
4714 */
4715static bool
4718 EState *estate,
4719 bool delete_ok)
4720{
4721 bool all_fired = true;
4724 bool local_estate = false;
4726 Relation rel = NULL;
4727 TriggerDesc *trigdesc = NULL;
4728 FmgrInfo *finfo = NULL;
4731 *slot2 = NULL;
4732
4733 /* Make a local EState if need be */
4734 if (estate == NULL)
4735 {
4736 estate = CreateExecutorState();
4737 local_estate = true;
4738 }
4739
4740 /* Make a per-tuple memory context for trigger function calls */
4743 "AfterTriggerTupleContext",
4745
4746 for_each_chunk(chunk, *events)
4747 {
4748 AfterTriggerEvent event;
4749 bool all_fired_in_chunk = true;
4750
4751 for_each_event(event, chunk)
4752 {
4754
4755 /*
4756 * Is it one for me to fire?
4757 */
4758 if ((event->ate_flags & AFTER_TRIGGER_IN_PROGRESS) &&
4759 evtshared->ats_firing_id == firing_id)
4760 {
4762 *dst_rInfo;
4763
4764 /*
4765 * So let's fire it... but first, find the correct relation if
4766 * this is not the same relation as before.
4767 */
4768 if (rel == NULL || RelationGetRelid(rel) != evtshared->ats_relid)
4769 {
4770 rInfo = ExecGetTriggerResultRel(estate, evtshared->ats_relid,
4771 NULL);
4772 rel = rInfo->ri_RelationDesc;
4773 /* Catch calls with insufficient relcache refcounting */
4775 trigdesc = rInfo->ri_TrigDesc;
4776 /* caution: trigdesc could be NULL here */
4777 finfo = rInfo->ri_TrigFunctions;
4778 instr = rInfo->ri_TrigInstrument;
4779 if (slot1 != NULL)
4780 {
4783 slot1 = slot2 = NULL;
4784 }
4785 if (rel->rd_rel->relkind == RELKIND_FOREIGN_TABLE)
4786 {
4791 }
4792 }
4793
4794 /*
4795 * Look up source and destination partition result rels of a
4796 * cross-partition update event.
4797 */
4798 if ((event->ate_flags & AFTER_TRIGGER_TUP_BITS) ==
4800 {
4801 Assert(OidIsValid(event->ate_src_part) &&
4802 OidIsValid(event->ate_dst_part));
4804 event->ate_src_part,
4805 rInfo);
4807 event->ate_dst_part,
4808 rInfo);
4809 }
4810 else
4812
4813 /*
4814 * Fire it. Note that the AFTER_TRIGGER_IN_PROGRESS flag is
4815 * still set, so recursive examinations of the event list
4816 * won't try to re-fire it.
4817 */
4818 AfterTriggerExecute(estate, event, rInfo,
4820 trigdesc, finfo, instr,
4822
4823 /*
4824 * Mark the event as done.
4825 */
4826 event->ate_flags &= ~AFTER_TRIGGER_IN_PROGRESS;
4827 event->ate_flags |= AFTER_TRIGGER_DONE;
4828 }
4829 else if (!(event->ate_flags & AFTER_TRIGGER_DONE))
4830 {
4831 /* something remains to be done */
4832 all_fired = all_fired_in_chunk = false;
4833 }
4834 }
4835
4836 /* Clear the chunk if delete_ok and nothing left of interest */
4838 {
4839 chunk->freeptr = CHUNK_DATA_START(chunk);
4840 chunk->endfree = chunk->endptr;
4841
4842 /*
4843 * If it's last chunk, must sync event list's tailfree too. Note
4844 * that delete_ok must NOT be passed as true if there could be
4845 * additional AfterTriggerEventList values pointing at this event
4846 * list, since we'd fail to fix their copies of tailfree.
4847 */
4848 if (chunk == events->tail)
4849 events->tailfree = chunk->freeptr;
4850 }
4851 }
4852 if (slot1 != NULL)
4853 {
4856 }
4857
4858 /* Release working resources */
4860
4861 if (local_estate)
4862 {
4864 ExecResetTupleTable(estate->es_tupleTable, false);
4865 FreeExecutorState(estate);
4866 }
4867
4868 return all_fired;
4869}
4870
4871
4872/*
4873 * GetAfterTriggersTableData
4874 *
4875 * Find or create an AfterTriggersTableData struct for the specified
4876 * trigger event (relation + operation type). Ignore existing structs
4877 * marked "closed"; we don't want to put any additional tuples into them,
4878 * nor change their stmt-triggers-fired state.
4879 *
4880 * Note: the AfterTriggersTableData list is allocated in the current
4881 * (sub)transaction's CurTransactionContext. This is OK because
4882 * we don't need it to live past AfterTriggerEndQuery.
4883 */
4886{
4890 ListCell *lc;
4891
4892 /* At this level, cmdType should not be, eg, CMD_MERGE */
4893 Assert(cmdType == CMD_INSERT ||
4894 cmdType == CMD_UPDATE ||
4895 cmdType == CMD_DELETE);
4896
4897 /* Caller should have ensured query_depth is OK. */
4901
4902 foreach(lc, qs->tables)
4903 {
4905 if (table->relid == relid && table->cmdType == cmdType &&
4906 !table->closed)
4907 return table;
4908 }
4909
4911
4913 table->relid = relid;
4914 table->cmdType = cmdType;
4915 qs->tables = lappend(qs->tables, table);
4916
4918
4919 return table;
4920}
4921
4922/*
4923 * Returns a TupleTableSlot suitable for holding the tuples to be put
4924 * into AfterTriggersTableData's transition table tuplestores.
4925 */
4926static TupleTableSlot *
4928 TupleDesc tupdesc)
4929{
4930 /* Create it if not already done. */
4931 if (!table->storeslot)
4932 {
4934
4935 /*
4936 * We need this slot only until AfterTriggerEndQuery, but making it
4937 * last till end-of-subxact is good enough. It'll be freed by
4938 * AfterTriggerFreeQuery(). However, the passed-in tupdesc might have
4939 * a different lifespan, so we'd better make a copy of that.
4940 */
4942 tupdesc = CreateTupleDescCopy(tupdesc);
4943 table->storeslot = MakeSingleTupleTableSlot(tupdesc, &TTSOpsVirtual);
4945 }
4946
4947 return table->storeslot;
4948}
4949
4950/*
4951 * MakeTransitionCaptureState
4952 *
4953 * Make a TransitionCaptureState object for the given TriggerDesc, target
4954 * relation, and operation type. The TCS object holds all the state needed
4955 * to decide whether to capture tuples in transition tables.
4956 *
4957 * If there are no triggers in 'trigdesc' that request relevant transition
4958 * tables, then return NULL.
4959 *
4960 * The resulting object can be passed to the ExecAR* functions. When
4961 * dealing with child tables, the caller can set tcs_original_insert_tuple
4962 * to avoid having to reconstruct the original tuple in the root table's
4963 * format.
4964 *
4965 * Note that we copy the flags from a parent table into this struct (rather
4966 * than subsequently using the relation's TriggerDesc directly) so that we can
4967 * use it to control collection of transition tuples from child tables.
4968 *
4969 * Per SQL spec, all operations of the same kind (INSERT/UPDATE/DELETE)
4970 * on the same table during one query should share one transition table.
4971 * Therefore, the Tuplestores are owned by an AfterTriggersTableData struct
4972 * looked up using the table OID + CmdType, and are merely referenced by
4973 * the TransitionCaptureState objects we hand out to callers.
4974 */
4977{
4979 bool need_old_upd,
4988
4989 if (trigdesc == NULL)
4990 return NULL;
4991
4992 /* Detect which table(s) we need. */
4993 switch (cmdType)
4994 {
4995 case CMD_INSERT:
4998 break;
4999 case CMD_UPDATE:
5002 need_old_del = need_new_ins = false;
5003 break;
5004 case CMD_DELETE:
5007 break;
5008 case CMD_MERGE:
5013 break;
5014 default:
5015 elog(ERROR, "unexpected CmdType: %d", (int) cmdType);
5016 /* keep compiler quiet */
5018 break;
5019 }
5021 return NULL;
5022
5023 /* Check state, like AfterTriggerSaveEvent. */
5024 if (afterTriggers.query_depth < 0)
5025 elog(ERROR, "MakeTransitionCaptureState() called outside of query");
5026
5027 /* Be sure we have enough space to record events at this query depth. */
5030
5031 /*
5032 * Find or create AfterTriggersTableData struct(s) to hold the
5033 * tuplestore(s). If there's a matching struct but it's marked closed,
5034 * ignore it; we need a newer one.
5035 *
5036 * Note: MERGE must use the same AfterTriggersTableData structs as INSERT,
5037 * UPDATE, and DELETE, so that any MERGE'd tuples are added to the same
5038 * tuplestores as tuples from any INSERT, UPDATE, or DELETE commands
5039 * running in the same top-level command (e.g., in a writable CTE).
5040 *
5041 * Note: the AfterTriggersTableData list, as well as the tuplestores, are
5042 * allocated in the current (sub)transaction's CurTransactionContext, and
5043 * the tuplestores are managed by the (sub)transaction's resource owner.
5044 * This is sufficient lifespan because we do not allow triggers using
5045 * transition tables to be deferrable; they will be fired during
5046 * AfterTriggerEndQuery, after which it's okay to delete the data.
5047 */
5048 if (need_new_ins)
5050 else
5051 ins_table = NULL;
5052
5055 else
5056 upd_table = NULL;
5057
5058 if (need_old_del)
5060 else
5061 del_table = NULL;
5062
5063 /* Now create required tuplestore(s), if we don't have them already. */
5067
5068 if (need_old_upd && upd_table->old_tuplestore == NULL)
5069 upd_table->old_tuplestore = tuplestore_begin_heap(false, false, work_mem);
5070 if (need_new_upd && upd_table->new_tuplestore == NULL)
5071 upd_table->new_tuplestore = tuplestore_begin_heap(false, false, work_mem);
5072 if (need_old_del && del_table->old_tuplestore == NULL)
5073 del_table->old_tuplestore = tuplestore_begin_heap(false, false, work_mem);
5074 if (need_new_ins && ins_table->new_tuplestore == NULL)
5075 ins_table->new_tuplestore = tuplestore_begin_heap(false, false, work_mem);
5076
5079
5080 /* Now build the TransitionCaptureState struct, in caller's context */
5082 state->tcs_delete_old_table = need_old_del;
5083 state->tcs_update_old_table = need_old_upd;
5084 state->tcs_update_new_table = need_new_upd;
5085 state->tcs_insert_new_table = need_new_ins;
5086 state->tcs_insert_private = ins_table;
5087 state->tcs_update_private = upd_table;
5088 state->tcs_delete_private = del_table;
5089
5090 return state;
5091}
5092
5093
5094/* ----------
5095 * AfterTriggerBeginXact()
5096 *
5097 * Called at transaction start (either BEGIN or implicit for single
5098 * statement outside of transaction block).
5099 * ----------
5100 */
5101void
5103{
5104 /*
5105 * Initialize after-trigger state structure to empty
5106 */
5107 afterTriggers.firing_counter = (CommandId) 1; /* mustn't be 0 */
5110
5111 /*
5112 * Verify that there is no leftover state remaining. If these assertions
5113 * trip, it means that AfterTriggerEndXact wasn't called or didn't clean
5114 * up properly.
5115 */
5124}
5125
5126
5127/* ----------
5128 * AfterTriggerBeginQuery()
5129 *
5130 * Called just before we start processing a single query within a
5131 * transaction (or subtransaction). Most of the real work gets deferred
5132 * until somebody actually tries to queue a trigger event.
5133 * ----------
5134 */
5135void
5137{
5138 /* Increase the query stack depth */
5140}
5141
5142
5143/* ----------
5144 * AfterTriggerEndQuery()
5145 *
5146 * Called after one query has been completely processed. At this time
5147 * we invoke all AFTER IMMEDIATE trigger events queued by the query, and
5148 * transfer deferred trigger events to the global deferred-trigger list.
5149 *
5150 * Note that this must be called BEFORE closing down the executor
5151 * with ExecutorEnd, because we make use of the EState's info about
5152 * target relations. Normally it is called from ExecutorFinish.
5153 * ----------
5154 */
5155void
5157{
5159
5160 /* Must be inside a query, too */
5162
5163 /*
5164 * If we never even got as far as initializing the event stack, there
5165 * certainly won't be any events, so exit quickly.
5166 */
5168 {
5170 return;
5171 }
5172
5173 /*
5174 * Process all immediate-mode triggers queued by the query, and move the
5175 * deferred ones to the main list of deferred events.
5176 *
5177 * Notice that we decide which ones will be fired, and put the deferred
5178 * ones on the main list, before anything is actually fired. This ensures
5179 * reasonably sane behavior if a trigger function does SET CONSTRAINTS ...
5180 * IMMEDIATE: all events we have decided to defer will be available for it
5181 * to fire.
5182 *
5183 * We loop in case a trigger queues more events at the same query level.
5184 * Ordinary trigger functions, including all PL/pgSQL trigger functions,
5185 * will instead fire any triggers in a dedicated query level. Foreign key
5186 * enforcement triggers do add to the current query level, thanks to their
5187 * passing fire_triggers = false to SPI_execute_snapshot(). Other
5188 * C-language triggers might do likewise.
5189 *
5190 * If we find no firable events, we don't have to increment
5191 * firing_counter.
5192 */
5194
5196 for (;;)
5197 {
5198 if (afterTriggerMarkEvents(&qs->events, &afterTriggers.events, true))
5199 {
5201 AfterTriggerEventChunk *oldtail = qs->events.tail;
5202
5203 if (afterTriggerInvokeEvents(&qs->events, firing_id, estate, false))
5204 break; /* all fired */
5205
5206 /*
5207 * Firing a trigger could result in query_stack being repalloc'd,
5208 * so we must recalculate qs after each afterTriggerInvokeEvents
5209 * call. Furthermore, it's unsafe to pass delete_ok = true here,
5210 * because that could cause afterTriggerInvokeEvents to try to
5211 * access qs->events after the stack has been repalloc'd.
5212 */
5214
5215 /*
5216 * We'll need to scan the events list again. To reduce the cost
5217 * of doing so, get rid of completely-fired chunks. We know that
5218 * all events were marked IN_PROGRESS or DONE at the conclusion of
5219 * afterTriggerMarkEvents, so any still-interesting events must
5220 * have been added after that, and so must be in the chunk that
5221 * was then the tail chunk, or in later chunks. So, zap all
5222 * chunks before oldtail. This is approximately the same set of
5223 * events we would have gotten rid of by passing delete_ok = true.
5224 */
5225 Assert(oldtail != NULL);
5226 while (qs->events.head != oldtail)
5228 }
5229 else
5230 break;
5231 }
5232
5233 /*
5234 * Fire batch callbacks before releasing query-level storage and before
5235 * decrementing query_depth. Callbacks may do real work (index probes,
5236 * error reporting) and rely on query_depth still reflecting the current
5237 * batch level so that nested calls from SPI inside AFTER triggers are
5238 * correctly suppressed by FireAfterTriggerBatchCallbacks's depth guard.
5239 */
5241
5242 /* Release query-level-local storage, including tuplestores if any */
5244
5247}
5248
5249
5250/*
5251 * AfterTriggerFreeQuery
5252 * Release subsidiary storage for a trigger query level.
5253 * This includes closing down tuplestores.
5254 * Note: it's important for this to be safe if interrupted by an error
5255 * and then called again for the same query level.
5256 */
5257static void
5259{
5260 Tuplestorestate *ts;
5261 List *tables;
5262 ListCell *lc;
5263
5264 /* Drop the trigger events */
5265 afterTriggerFreeEventList(&qs->events);
5266
5267 /* Drop FDW tuplestore if any */
5268 ts = qs->fdw_tuplestore;
5269 qs->fdw_tuplestore = NULL;
5270 if (ts)
5271 tuplestore_end(ts);
5272
5273 /* Release per-table subsidiary storage */
5274 tables = qs->tables;
5275 foreach(lc, tables)
5276 {
5278
5279 ts = table->old_tuplestore;
5280 table->old_tuplestore = NULL;
5281 if (ts)
5282 tuplestore_end(ts);
5283 ts = table->new_tuplestore;
5284 table->new_tuplestore = NULL;
5285 if (ts)
5286 tuplestore_end(ts);
5287 if (table->storeslot)
5288 {
5289 TupleTableSlot *slot = table->storeslot;
5290
5291 table->storeslot = NULL;
5293 }
5294 }
5295
5296 /*
5297 * Now free the AfterTriggersTableData structs and list cells. Reset list
5298 * pointer first; if list_free_deep somehow gets an error, better to leak
5299 * that storage than have an infinite loop.
5300 */
5301 qs->tables = NIL;
5302 list_free_deep(tables);
5303}
5304
5305
5306/* ----------
5307 * AfterTriggerFireDeferred()
5308 *
5309 * Called just before the current transaction is committed. At this
5310 * time we invoke all pending DEFERRED triggers.
5311 *
5312 * It is possible for other modules to queue additional deferred triggers
5313 * during pre-commit processing; therefore xact.c may have to call this
5314 * multiple times.
5315 * ----------
5316 */
5317void
5319{
5320 AfterTriggerEventList *events;
5321 bool snap_pushed = false;
5322
5323 /* Must not be inside a query */
5325
5326 /*
5327 * If there are any triggers to fire, make sure we have set a snapshot for
5328 * them to use. (Since PortalRunUtility doesn't set a snap for COMMIT, we
5329 * can't assume ActiveSnapshot is valid on entry.)
5330 */
5331 events = &afterTriggers.events;
5332 if (events->head != NULL)
5333 {
5335 snap_pushed = true;
5336 }
5337
5338 /*
5339 * Run all the remaining triggers. Loop until they are all gone, in case
5340 * some trigger queues more for us to do.
5341 */
5343 while (afterTriggerMarkEvents(events, NULL, false))
5344 {
5346
5347 if (afterTriggerInvokeEvents(events, firing_id, NULL, true))
5348 break; /* all fired */
5349 }
5350
5351 /* Flush any fast-path batches accumulated by the triggers just fired. */
5353
5355
5356 /*
5357 * We don't bother freeing the event list, since it will go away anyway
5358 * (and more efficiently than via pfree) in AfterTriggerEndXact.
5359 */
5360
5361 if (snap_pushed)
5363}
5364
5365
5366/* ----------
5367 * AfterTriggerEndXact()
5368 *
5369 * The current transaction is finishing.
5370 *
5371 * Any unfired triggers are canceled so we simply throw
5372 * away anything we know.
5373 *
5374 * Note: it is possible for this to be called repeatedly in case of
5375 * error during transaction abort; therefore, do not complain if
5376 * already closed down.
5377 * ----------
5378 */
5379void
5381{
5382 /*
5383 * Forget the pending-events list.
5384 *
5385 * Since all the info is in TopTransactionContext or children thereof, we
5386 * don't really need to do anything to reclaim memory. However, the
5387 * pending-events list could be large, and so it's useful to discard it as
5388 * soon as possible --- especially if we are aborting because we ran out
5389 * of memory for the list!
5390 */
5392 {
5398 }
5399
5400 /*
5401 * Forget any subtransaction state as well. Since this can't be very
5402 * large, we let the eventual reset of TopTransactionContext free the
5403 * memory instead of doing it here.
5404 */
5407
5408
5409 /*
5410 * Forget the query stack and constraint-related state information. As
5411 * with the subtransaction state information, we don't bother freeing the
5412 * memory here.
5413 */
5417
5418 /* No more afterTriggers manipulation until next transaction starts. */
5420
5422}
5423
5424/*
5425 * AfterTriggerBeginSubXact()
5426 *
5427 * Start a subtransaction.
5428 */
5429void
5431{
5432 int my_level = GetCurrentTransactionNestLevel();
5433
5434 /*
5435 * Allocate more space in the trans_stack if needed. (Note: because the
5436 * minimum nest level of a subtransaction is 2, we waste the first couple
5437 * entries of the array; not worth the notational effort to avoid it.)
5438 */
5439 while (my_level >= afterTriggers.maxtransdepth)
5440 {
5442 {
5443 /* Arbitrarily initialize for max of 8 subtransaction levels */
5446 8 * sizeof(AfterTriggersTransData));
5448 }
5449 else
5450 {
5451 /* repalloc will keep the stack in the same context */
5453
5458 }
5459 }
5460
5461 /*
5462 * Push the current information into the stack. The SET CONSTRAINTS state
5463 * is not saved until/unless changed. Likewise, we don't make a
5464 * per-subtransaction event context until needed.
5465 */
5466 afterTriggers.trans_stack[my_level].state = NULL;
5470}
5471
5472/*
5473 * AfterTriggerEndSubXact()
5474 *
5475 * The current subtransaction is ending.
5476 */
5477void
5479{
5480 int my_level = GetCurrentTransactionNestLevel();
5482 AfterTriggerEvent event;
5485
5486 /*
5487 * Pop the prior state if needed.
5488 */
5489 if (isCommit)
5490 {
5492 /* If we saved a prior state, we don't need it anymore */
5494 if (state != NULL)
5495 pfree(state);
5496 /* this avoids double pfree if error later: */
5497 afterTriggers.trans_stack[my_level].state = NULL;
5500 }
5501 else
5502 {
5503 /*
5504 * Aborting. It is possible subxact start failed before calling
5505 * AfterTriggerBeginSubXact, in which case we mustn't risk touching
5506 * trans_stack levels that aren't there.
5507 */
5508 if (my_level >= afterTriggers.maxtransdepth)
5509 return;
5510
5511 /*
5512 * Release query-level storage for queries being aborted, and restore
5513 * query_depth to its pre-subxact value. This assumes that a
5514 * subtransaction will not add events to query levels started in a
5515 * earlier transaction state.
5516 */
5518 {
5522 }
5525
5526 /*
5527 * Restore the global deferred-event list to its former length,
5528 * discarding any events queued by the subxact.
5529 */
5531 &afterTriggers.trans_stack[my_level].events);
5532
5533 /*
5534 * Restore the trigger state. If the saved state is NULL, then this
5535 * subxact didn't save it, so it doesn't need restoring.
5536 */
5538 if (state != NULL)
5539 {
5542 }
5543 /* this avoids double pfree if error later: */
5544 afterTriggers.trans_stack[my_level].state = NULL;
5545
5546 /*
5547 * Scan for any remaining deferred events that were marked DONE or IN
5548 * PROGRESS by this subxact or a child, and un-mark them. We can
5549 * recognize such events because they have a firing ID greater than or
5550 * equal to the firing_counter value we saved at subtransaction start.
5551 * (This essentially assumes that the current subxact includes all
5552 * subxacts started after it.)
5553 */
5556 {
5558
5559 if (event->ate_flags &
5561 {
5562 if (evtshared->ats_firing_id >= subxact_firing_id)
5563 event->ate_flags &=
5565 }
5566 }
5567 }
5568}
5569
5570/*
5571 * Get the transition table for the given event and depending on whether we are
5572 * processing the old or the new tuple.
5573 */
5574static Tuplestorestate *
5578 TransitionCaptureState *transition_capture)
5579{
5580 Tuplestorestate *tuplestore = NULL;
5581 bool delete_old_table = transition_capture->tcs_delete_old_table;
5582 bool update_old_table = transition_capture->tcs_update_old_table;
5583 bool update_new_table = transition_capture->tcs_update_new_table;
5584 bool insert_new_table = transition_capture->tcs_insert_new_table;
5585
5586 /*
5587 * For INSERT events NEW should be non-NULL, for DELETE events OLD should
5588 * be non-NULL, whereas for UPDATE events normally both OLD and NEW are
5589 * non-NULL. But for UPDATE events fired for capturing transition tuples
5590 * during UPDATE partition-key row movement, OLD is NULL when the event is
5591 * for a row being inserted, whereas NEW is NULL when the event is for a
5592 * row being deleted.
5593 */
5595 TupIsNull(oldslot)));
5597 TupIsNull(newslot)));
5598
5599 if (!TupIsNull(oldslot))
5600 {
5602 if (event == TRIGGER_EVENT_DELETE && delete_old_table)
5603 tuplestore = transition_capture->tcs_delete_private->old_tuplestore;
5604 else if (event == TRIGGER_EVENT_UPDATE && update_old_table)
5605 tuplestore = transition_capture->tcs_update_private->old_tuplestore;
5606 }
5607 else if (!TupIsNull(newslot))
5608 {
5610 if (event == TRIGGER_EVENT_INSERT && insert_new_table)
5611 tuplestore = transition_capture->tcs_insert_private->new_tuplestore;
5612 else if (event == TRIGGER_EVENT_UPDATE && update_new_table)
5613 tuplestore = transition_capture->tcs_update_private->new_tuplestore;
5614 }
5615
5616 return tuplestore;
5617}
5618
5619/*
5620 * Add the given heap tuple to the given tuplestore, applying the conversion
5621 * map if necessary.
5622 *
5623 * If original_insert_tuple is given, we can add that tuple without conversion.
5624 */
5625static void
5627 int event,
5628 TransitionCaptureState *transition_capture,
5630 TupleTableSlot *slot,
5632 Tuplestorestate *tuplestore)
5633{
5634 TupleConversionMap *map;
5635
5636 /*
5637 * Nothing needs to be done if we don't have a tuplestore.
5638 */
5639 if (tuplestore == NULL)
5640 return;
5641
5644 else if ((map = ExecGetChildToRootMap(relinfo)) != NULL)
5645 {
5647 TupleTableSlot *storeslot;
5648
5649 switch (event)
5650 {
5652 table = transition_capture->tcs_insert_private;
5653 break;
5655 table = transition_capture->tcs_update_private;
5656 break;
5658 table = transition_capture->tcs_delete_private;
5659 break;
5660 default:
5661 elog(ERROR, "invalid after-trigger event code: %d", event);
5662 table = NULL; /* keep compiler quiet */
5663 break;
5664 }
5665
5666 storeslot = GetAfterTriggersStoreSlot(table, map->outdesc);
5667 execute_attr_map_slot(map->attrMap, slot, storeslot);
5668 tuplestore_puttupleslot(tuplestore, storeslot);
5669 }
5670 else
5671 tuplestore_puttupleslot(tuplestore, slot);
5672}
5673
5674/* ----------
5675 * AfterTriggerEnlargeQueryState()
5676 *
5677 * Prepare the necessary state so that we can record AFTER trigger events
5678 * queued by a query. It is allowed to have nested queries within a
5679 * (sub)transaction, so we need to have separate state for each query
5680 * nesting level.
5681 * ----------
5682 */
5683static void
5685{
5687
5689
5691 {
5692 int new_alloc = Max(afterTriggers.query_depth + 1, 8);
5693
5698 }
5699 else
5700 {
5701 /* repalloc will keep the stack in the same context */
5704 old_alloc * 2);
5705
5710 }
5711
5712 /* Initialize new array entries to empty */
5714 {
5716
5717 qs->events.head = NULL;
5718 qs->events.tail = NULL;
5719 qs->events.tailfree = NULL;
5720 qs->fdw_tuplestore = NULL;
5721 qs->tables = NIL;
5722
5723 ++init_depth;
5724 }
5725}
5726
5727/*
5728 * Create an empty SetConstraintState with room for numalloc trigstates
5729 */
5730static SetConstraintState
5732{
5734
5735 /* Behave sanely with numalloc == 0 */
5736 if (numalloc <= 0)
5737 numalloc = 1;
5738
5739 /*
5740 * We assume that zeroing will correctly initialize the state values.
5741 */
5744 offsetof(SetConstraintStateData, trigstates) +
5745 numalloc * sizeof(SetConstraintTriggerData));
5746
5747 state->numalloc = numalloc;
5748
5749 return state;
5750}
5751
5752/*
5753 * Copy a SetConstraintState
5754 */
5755static SetConstraintState
5757{
5759
5761
5762 state->all_isset = origstate->all_isset;
5763 state->all_isdeferred = origstate->all_isdeferred;
5764 state->numstates = origstate->numstates;
5765 memcpy(state->trigstates, origstate->trigstates,
5766 origstate->numstates * sizeof(SetConstraintTriggerData));
5767
5768 return state;
5769}
5770
5771/*
5772 * Add a per-trigger item to a SetConstraintState. Returns possibly-changed
5773 * pointer to the state object (it will change if we have to repalloc).
5774 */
5775static SetConstraintState
5777 Oid tgoid, bool tgisdeferred)
5778{
5779 if (state->numstates >= state->numalloc)
5780 {
5781 int newalloc = state->numalloc * 2;
5782
5783 newalloc = Max(newalloc, 8); /* in case original has size 0 */
5786 offsetof(SetConstraintStateData, trigstates) +
5788 state->numalloc = newalloc;
5789 Assert(state->numstates < state->numalloc);
5790 }
5791
5792 state->trigstates[state->numstates].sct_tgoid = tgoid;
5793 state->trigstates[state->numstates].sct_tgisdeferred = tgisdeferred;
5794 state->numstates++;
5795
5796 return state;
5797}
5798
5799/* ----------
5800 * AfterTriggerSetState()
5801 *
5802 * Execute the SET CONSTRAINTS ... utility command.
5803 * ----------
5804 */
5805void
5807{
5808 int my_level = GetCurrentTransactionNestLevel();
5809
5810 /* If we haven't already done so, initialize our state. */
5811 if (afterTriggers.state == NULL)
5813
5814 /*
5815 * If in a subtransaction, and we didn't save the current state already,
5816 * save it so it can be restored if the subtransaction aborts.
5817 */
5818 if (my_level > 1 &&
5819 afterTriggers.trans_stack[my_level].state == NULL)
5820 {
5821 afterTriggers.trans_stack[my_level].state =
5823 }
5824
5825 /*
5826 * Handle SET CONSTRAINTS ALL ...
5827 */
5828 if (stmt->constraints == NIL)
5829 {
5830 /*
5831 * Forget any previous SET CONSTRAINTS commands in this transaction.
5832 */
5834
5835 /*
5836 * Set the per-transaction ALL state to known.
5837 */
5840 }
5841 else
5842 {
5845 List *conoidlist = NIL;
5846 List *tgoidlist = NIL;
5847 ListCell *lc;
5848
5849 /*
5850 * Handle SET CONSTRAINTS constraint-name [, ...]
5851 *
5852 * First, identify all the named constraints and make a list of their
5853 * OIDs. Since, unlike the SQL spec, we allow multiple constraints of
5854 * the same name within a schema, the specifications are not
5855 * necessarily unique. Our strategy is to target all matching
5856 * constraints within the first search-path schema that has any
5857 * matches, but disregard matches in schemas beyond the first match.
5858 * (This is a bit odd but it's the historical behavior.)
5859 *
5860 * A constraint in a partitioned table may have corresponding
5861 * constraints in the partitions. Grab those too.
5862 */
5864
5865 foreach(lc, stmt->constraints)
5866 {
5867 RangeVar *constraint = lfirst(lc);
5868 bool found;
5870 ListCell *nslc;
5871
5872 if (constraint->catalogname)
5873 {
5874 if (strcmp(constraint->catalogname, get_database_name(MyDatabaseId)) != 0)
5875 ereport(ERROR,
5877 errmsg("cross-database references are not implemented: \"%s.%s.%s\"",
5878 constraint->catalogname, constraint->schemaname,
5879 constraint->relname)));
5880 }
5881
5882 /*
5883 * If we're given the schema name with the constraint, look only
5884 * in that schema. If given a bare constraint name, use the
5885 * search path to find the first matching constraint.
5886 */
5887 if (constraint->schemaname)
5888 {
5890 false);
5891
5893 }
5894 else
5895 {
5897 }
5898
5899 found = false;
5900 foreach(nslc, namespacelist)
5901 {
5904 ScanKeyData skey[2];
5905 HeapTuple tup;
5906
5907 ScanKeyInit(&skey[0],
5910 CStringGetDatum(constraint->relname));
5911 ScanKeyInit(&skey[1],
5915
5917 true, NULL, 2, skey);
5918
5920 {
5922
5923 if (con->condeferrable)
5924 conoidlist = lappend_oid(conoidlist, con->oid);
5925 else if (stmt->deferred)
5926 ereport(ERROR,
5928 errmsg("constraint \"%s\" is not deferrable",
5929 constraint->relname)));
5930 found = true;
5931 }
5932
5934
5935 /*
5936 * Once we've found a matching constraint we do not search
5937 * later parts of the search path.
5938 */
5939 if (found)
5940 break;
5941 }
5942
5944
5945 /*
5946 * Not found ?
5947 */
5948 if (!found)
5949 ereport(ERROR,
5951 errmsg("constraint \"%s\" does not exist",
5952 constraint->relname)));
5953 }
5954
5955 /*
5956 * Scan for any possible descendants of the constraints. We append
5957 * whatever we find to the same list that we're scanning; this has the
5958 * effect that we create new scans for those, too, so if there are
5959 * further descendents, we'll also catch them.
5960 */
5961 foreach(lc, conoidlist)
5962 {
5963 Oid parent = lfirst_oid(lc);
5964 ScanKeyData key;
5965 SysScanDesc scan;
5966 HeapTuple tuple;
5967
5968 ScanKeyInit(&key,
5971 ObjectIdGetDatum(parent));
5972
5973 scan = systable_beginscan(conrel, ConstraintParentIndexId, true, NULL, 1, &key);
5974
5975 while (HeapTupleIsValid(tuple = systable_getnext(scan)))
5976 {
5978
5979 conoidlist = lappend_oid(conoidlist, con->oid);
5980 }
5981
5982 systable_endscan(scan);
5983 }
5984
5986
5987 /*
5988 * Now, locate the trigger(s) implementing each of these constraints,
5989 * and make a list of their OIDs.
5990 */
5992
5993 foreach(lc, conoidlist)
5994 {
5995 Oid conoid = lfirst_oid(lc);
5998 HeapTuple htup;
5999
6003 ObjectIdGetDatum(conoid));
6004
6006 NULL, 1, &skey);
6007
6009 {
6011
6012 /*
6013 * Silently skip triggers that are marked as non-deferrable in
6014 * pg_trigger. This is not an error condition, since a
6015 * deferrable RI constraint may have some non-deferrable
6016 * actions.
6017 */
6018 if (pg_trigger->tgdeferrable)
6020 }
6021
6023 }
6024
6026
6027 /*
6028 * Now we can set the trigger states of individual triggers for this
6029 * xact.
6030 */
6031 foreach(lc, tgoidlist)
6032 {
6033 Oid tgoid = lfirst_oid(lc);
6035 bool found = false;
6036 int i;
6037
6038 for (i = 0; i < state->numstates; i++)
6039 {
6040 if (state->trigstates[i].sct_tgoid == tgoid)
6041 {
6042 state->trigstates[i].sct_tgisdeferred = stmt->deferred;
6043 found = true;
6044 break;
6045 }
6046 }
6047 if (!found)
6048 {
6050 SetConstraintStateAddItem(state, tgoid, stmt->deferred);
6051 }
6052 }
6053 }
6054
6055 /*
6056 * SQL99 requires that when a constraint is set to IMMEDIATE, any deferred
6057 * checks against that constraint must be made when the SET CONSTRAINTS
6058 * command is executed -- i.e. the effects of the SET CONSTRAINTS command
6059 * apply retroactively. We've updated the constraints state, so scan the
6060 * list of previously deferred events to fire any that have now become
6061 * immediate.
6062 *
6063 * Obviously, if this was SET ... DEFERRED then it can't have converted
6064 * any unfired events to immediate, so we need do nothing in that case.
6065 */
6066 if (!stmt->deferred)
6067 {
6069 bool snapshot_set = false;
6070
6072 while (afterTriggerMarkEvents(events, NULL, true))
6073 {
6075
6076 /*
6077 * Make sure a snapshot has been established in case trigger
6078 * functions need one. Note that we avoid setting a snapshot if
6079 * we don't find at least one trigger that has to be fired now.
6080 * This is so that BEGIN; SET CONSTRAINTS ...; SET TRANSACTION
6081 * ISOLATION LEVEL SERIALIZABLE; ... works properly. (If we are
6082 * at the start of a transaction it's not possible for any trigger
6083 * events to be queued yet.)
6084 */
6085 if (!snapshot_set)
6086 {
6088 snapshot_set = true;
6089 }
6090
6091 /*
6092 * We can delete fired events if we are at top transaction level,
6093 * but we'd better not if inside a subtransaction, since the
6094 * subtransaction could later get rolled back.
6095 */
6097 !IsSubTransaction()))
6098 break; /* all fired */
6099 }
6100
6101 /*
6102 * Flush any fast-path batches accumulated by the triggers just fired.
6103 */
6106
6107 if (snapshot_set)
6109 }
6110}
6111
6112/* ----------
6113 * AfterTriggerPendingOnRel()
6114 * Test to see if there are any pending after-trigger events for rel.
6115 *
6116 * This is used by TRUNCATE, CLUSTER, ALTER TABLE, etc to detect whether
6117 * it is unsafe to perform major surgery on a relation. Note that only
6118 * local pending events are examined. We assume that having exclusive lock
6119 * on a rel guarantees there are no unserviced events in other backends ---
6120 * but having a lock does not prevent there being such events in our own.
6121 *
6122 * In some scenarios it'd be reasonable to remove pending events (more
6123 * specifically, mark them DONE by the current subxact) but without a lot
6124 * of knowledge of the trigger semantics we can't do this in general.
6125 * ----------
6126 */
6127bool
6129{
6130 AfterTriggerEvent event;
6132 int depth;
6133
6134 /* Scan queued events */
6136 {
6138
6139 /*
6140 * We can ignore completed events. (Even if a DONE flag is rolled
6141 * back by subxact abort, it's OK because the effects of the TRUNCATE
6142 * or whatever must get rolled back too.)
6143 */
6144 if (event->ate_flags & AFTER_TRIGGER_DONE)
6145 continue;
6146
6147 if (evtshared->ats_relid == relid)
6148 return true;
6149 }
6150
6151 /*
6152 * Also scan events queued by incomplete queries. This could only matter
6153 * if TRUNCATE/etc is executed by a function or trigger within an updating
6154 * query on the same relation, which is pretty perverse, but let's check.
6155 */
6156 for (depth = 0; depth <= afterTriggers.query_depth && depth < afterTriggers.maxquerydepth; depth++)
6157 {
6159 {
6161
6162 if (event->ate_flags & AFTER_TRIGGER_DONE)
6163 continue;
6164
6165 if (evtshared->ats_relid == relid)
6166 return true;
6167 }
6168 }
6169
6170 return false;
6171}
6172
6173/* ----------
6174 * AfterTriggerSaveEvent()
6175 *
6176 * Called by ExecA[RS]...Triggers() to queue up the triggers that should
6177 * be fired for an event.
6178 *
6179 * NOTE: this is called whenever there are any triggers associated with
6180 * the event (even if they are disabled). This function decides which
6181 * triggers actually need to be queued. It is also called after each row,
6182 * even if there are no triggers for that event, if there are any AFTER
6183 * STATEMENT triggers for the statement which use transition tables, so that
6184 * the transition tuplestores can be built. Furthermore, if the transition
6185 * capture is happening for UPDATEd rows being moved to another partition due
6186 * to the partition-key being changed, then this function is called once when
6187 * the row is deleted (to capture OLD row), and once when the row is inserted
6188 * into another partition (to capture NEW row). This is done separately because
6189 * DELETE and INSERT happen on different tables.
6190 *
6191 * Transition tuplestores are built now, rather than when events are pulled
6192 * off of the queue because AFTER ROW triggers are allowed to select from the
6193 * transition tables for the statement.
6194 *
6195 * This contains special support to queue the update events for the case where
6196 * a partitioned table undergoing a cross-partition update may have foreign
6197 * keys pointing into it. Normally, a partitioned table's row triggers are
6198 * not fired because the leaf partition(s) which are modified as a result of
6199 * the operation on the partitioned table contain the same triggers which are
6200 * fired instead. But that general scheme can cause problematic behavior with
6201 * foreign key triggers during cross-partition updates, which are implemented
6202 * as DELETE on the source partition followed by INSERT into the destination
6203 * partition. Specifically, firing DELETE triggers would lead to the wrong
6204 * foreign key action to be enforced considering that the original command is
6205 * UPDATE; in this case, this function is called with relinfo as the
6206 * partitioned table, and src_partinfo and dst_partinfo referring to the
6207 * source and target leaf partitions, respectively.
6208 *
6209 * is_crosspart_update is true either when a DELETE event is fired on the
6210 * source partition (which is to be ignored) or an UPDATE event is fired on
6211 * the root partitioned table.
6212 * ----------
6213 */
6214static void
6218 int event, bool row_trigger,
6221 TransitionCaptureState *transition_capture,
6223{
6224 Relation rel = relinfo->ri_RelationDesc;
6225 TriggerDesc *trigdesc = relinfo->ri_TrigDesc;
6228 char relkind = rel->rd_rel->relkind;
6229 int tgtype_event;
6230 int tgtype_level;
6231 int i;
6232 Tuplestorestate *fdw_tuplestore = NULL;
6233
6234 /*
6235 * Check state. We use a normal test not Assert because it is possible to
6236 * reach here in the wrong state given misconfigured RI triggers, in
6237 * particular deferring a cascade action trigger.
6238 */
6239 if (afterTriggers.query_depth < 0)
6240 elog(ERROR, "AfterTriggerSaveEvent() called outside of query");
6241
6242 /* Be sure we have enough space to record events at this query depth. */
6245
6246 /*
6247 * If the directly named relation has any triggers with transition tables,
6248 * then we need to capture transition tuples.
6249 */
6250 if (row_trigger && transition_capture != NULL)
6251 {
6253
6254 /*
6255 * Capture the old tuple in the appropriate transition table based on
6256 * the event.
6257 */
6258 if (!TupIsNull(oldslot))
6259 {
6260 Tuplestorestate *old_tuplestore;
6261
6262 old_tuplestore = GetAfterTriggersTransitionTable(event,
6263 oldslot,
6264 NULL,
6265 transition_capture);
6266 TransitionTableAddTuple(estate, event, transition_capture, relinfo,
6267 oldslot, NULL, old_tuplestore);
6268 }
6269
6270 /*
6271 * Capture the new tuple in the appropriate transition table based on
6272 * the event.
6273 */
6274 if (!TupIsNull(newslot))
6275 {
6276 Tuplestorestate *new_tuplestore;
6277
6278 new_tuplestore = GetAfterTriggersTransitionTable(event,
6279 NULL,
6280 newslot,
6281 transition_capture);
6282 TransitionTableAddTuple(estate, event, transition_capture, relinfo,
6283 newslot, original_insert_tuple, new_tuplestore);
6284 }
6285
6286 /*
6287 * If transition tables are the only reason we're here, return. As
6288 * mentioned above, we can also be here during update tuple routing in
6289 * presence of transition tables, in which case this function is
6290 * called separately for OLD and NEW, so we expect exactly one of them
6291 * to be NULL.
6292 */
6293 if (trigdesc == NULL ||
6294 (event == TRIGGER_EVENT_DELETE && !trigdesc->trig_delete_after_row) ||
6295 (event == TRIGGER_EVENT_INSERT && !trigdesc->trig_insert_after_row) ||
6296 (event == TRIGGER_EVENT_UPDATE && !trigdesc->trig_update_after_row) ||
6298 return;
6299 }
6300
6301 /*
6302 * We normally don't see partitioned tables here for row level triggers
6303 * except in the special case of a cross-partition update. In that case,
6304 * nodeModifyTable.c:ExecCrossPartitionUpdateForeignKey() calls here to
6305 * queue an update event on the root target partitioned table, also
6306 * passing the source and destination partitions and their tuples.
6307 */
6309 rel->rd_rel->relkind != RELKIND_PARTITIONED_TABLE ||
6311 TRIGGER_FIRED_BY_UPDATE(event) &&
6313
6314 /*
6315 * Validate the event code and collect the associated tuple CTIDs.
6316 *
6317 * The event code will be used both as a bitmask and an array offset, so
6318 * validation is important to make sure we don't walk off the edge of our
6319 * arrays.
6320 *
6321 * Also, if we're considering statement-level triggers, check whether we
6322 * already queued a set of them for this event, and cancel the prior set
6323 * if so. This preserves the behavior that statement-level triggers fire
6324 * just once per statement and fire after row-level triggers.
6325 */
6326 switch (event)
6327 {
6330 if (row_trigger)
6331 {
6332 Assert(oldslot == NULL);
6333 Assert(newslot != NULL);
6334 ItemPointerCopy(&(newslot->tts_tid), &(new_event.ate_ctid1));
6335 ItemPointerSetInvalid(&(new_event.ate_ctid2));
6336 }
6337 else
6338 {
6339 Assert(oldslot == NULL);
6340 Assert(newslot == NULL);
6341 ItemPointerSetInvalid(&(new_event.ate_ctid1));
6342 ItemPointerSetInvalid(&(new_event.ate_ctid2));
6344 CMD_INSERT, event);
6345 }
6346 break;
6349 if (row_trigger)
6350 {
6351 Assert(oldslot != NULL);
6352 Assert(newslot == NULL);
6353 ItemPointerCopy(&(oldslot->tts_tid), &(new_event.ate_ctid1));
6354 ItemPointerSetInvalid(&(new_event.ate_ctid2));
6355 }
6356 else
6357 {
6358 Assert(oldslot == NULL);
6359 Assert(newslot == NULL);
6360 ItemPointerSetInvalid(&(new_event.ate_ctid1));
6361 ItemPointerSetInvalid(&(new_event.ate_ctid2));
6363 CMD_DELETE, event);
6364 }
6365 break;
6368 if (row_trigger)
6369 {
6370 Assert(oldslot != NULL);
6371 Assert(newslot != NULL);
6372 ItemPointerCopy(&(oldslot->tts_tid), &(new_event.ate_ctid1));
6373 ItemPointerCopy(&(newslot->tts_tid), &(new_event.ate_ctid2));
6374
6375 /*
6376 * Also remember the OIDs of partitions to fetch these tuples
6377 * out of later in AfterTriggerExecute().
6378 */
6379 if (rel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE)
6380 {
6382 new_event.ate_src_part =
6383 RelationGetRelid(src_partinfo->ri_RelationDesc);
6384 new_event.ate_dst_part =
6385 RelationGetRelid(dst_partinfo->ri_RelationDesc);
6386 }
6387 }
6388 else
6389 {
6390 Assert(oldslot == NULL);
6391 Assert(newslot == NULL);
6392 ItemPointerSetInvalid(&(new_event.ate_ctid1));
6393 ItemPointerSetInvalid(&(new_event.ate_ctid2));
6395 CMD_UPDATE, event);
6396 }
6397 break;
6400 Assert(oldslot == NULL);
6401 Assert(newslot == NULL);
6402 ItemPointerSetInvalid(&(new_event.ate_ctid1));
6403 ItemPointerSetInvalid(&(new_event.ate_ctid2));
6404 break;
6405 default:
6406 elog(ERROR, "invalid after-trigger event code: %d", event);
6407 tgtype_event = 0; /* keep compiler quiet */
6408 break;
6409 }
6410
6411 /* Determine flags */
6412 if (!(relkind == RELKIND_FOREIGN_TABLE && row_trigger))
6413 {
6414 if (row_trigger && event == TRIGGER_EVENT_UPDATE)
6415 {
6416 if (relkind == RELKIND_PARTITIONED_TABLE)
6418 else
6419 new_event.ate_flags = AFTER_TRIGGER_2CTID;
6420 }
6421 else
6422 new_event.ate_flags = AFTER_TRIGGER_1CTID;
6423 }
6424
6425 /* else, we'll initialize ate_flags for each trigger */
6426
6428
6429 /*
6430 * Must convert/copy the source and destination partition tuples into the
6431 * root partitioned table's format/slot, because the processing in the
6432 * loop below expects both oldslot and newslot tuples to be in that form.
6433 */
6434 if (row_trigger && rel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE)
6435 {
6437 TupleConversionMap *map;
6438
6441 if (map)
6443 oldslot,
6444 rootslot);
6445 else
6447
6450 if (map)
6452 newslot,
6453 rootslot);
6454 else
6456 }
6457
6458 for (i = 0; i < trigdesc->numtriggers; i++)
6459 {
6460 Trigger *trigger = &trigdesc->triggers[i];
6461
6462 if (!TRIGGER_TYPE_MATCHES(trigger->tgtype,
6465 tgtype_event))
6466 continue;
6467 if (!TriggerEnabled(estate, relinfo, trigger, event,
6469 continue;
6470
6471 if (relkind == RELKIND_FOREIGN_TABLE && row_trigger)
6472 {
6473 if (fdw_tuplestore == NULL)
6474 {
6475 fdw_tuplestore = GetCurrentFDWTuplestore();
6477 }
6478 else
6479 /* subsequent event for the same tuple */
6481 }
6482
6483 /*
6484 * If the trigger is a foreign key enforcement trigger, there are
6485 * certain cases where we can skip queueing the event because we can
6486 * tell by inspection that the FK constraint will still pass. There
6487 * are also some cases during cross-partition updates of a partitioned
6488 * table where queuing the event can be skipped.
6489 */
6491 {
6492 switch (RI_FKey_trigger_type(trigger->tgfoid))
6493 {
6494 case RI_TRIGGER_PK:
6495
6496 /*
6497 * For cross-partitioned updates of partitioned PK table,
6498 * skip the event fired by the component delete on the
6499 * source leaf partition unless the constraint originates
6500 * in the partition itself (!tgisclone), because the
6501 * update event that will be fired on the root
6502 * (partitioned) target table will be used to perform the
6503 * necessary foreign key enforcement action.
6504 */
6505 if (is_crosspart_update &&
6506 TRIGGER_FIRED_BY_DELETE(event) &&
6507 trigger->tgisclone)
6508 continue;
6509
6510 /* Update or delete on trigger's PK table */
6512 oldslot, newslot))
6513 {
6514 /* skip queuing this event */
6515 continue;
6516 }
6517 break;
6518
6519 case RI_TRIGGER_FK:
6520
6521 /*
6522 * Update on trigger's FK table. We can skip the update
6523 * event fired on a partitioned table during a
6524 * cross-partition of that table, because the insert event
6525 * that is fired on the destination leaf partition would
6526 * suffice to perform the necessary foreign key check.
6527 * Moreover, RI_FKey_fk_upd_check_required() expects to be
6528 * passed a tuple that contains system attributes, most of
6529 * which are not present in the virtual slot belonging to
6530 * a partitioned table.
6531 */
6532 if (rel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE ||
6534 oldslot, newslot))
6535 {
6536 /* skip queuing this event */
6537 continue;
6538 }
6539 break;
6540
6541 case RI_TRIGGER_NONE:
6542
6543 /*
6544 * Not an FK trigger. No need to queue the update event
6545 * fired during a cross-partitioned update of a
6546 * partitioned table, because the same row trigger must be
6547 * present in the leaf partition(s) that are affected as
6548 * part of this update and the events fired on them are
6549 * queued instead.
6550 */
6551 if (row_trigger &&
6552 rel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE)
6553 continue;
6554 break;
6555 }
6556 }
6557
6558 /*
6559 * If the trigger is a deferred unique constraint check trigger, only
6560 * queue it if the unique constraint was potentially violated, which
6561 * we know from index insertion time.
6562 */
6563 if (trigger->tgfoid == F_UNIQUE_KEY_RECHECK)
6564 {
6565 if (!list_member_oid(recheckIndexes, trigger->tgconstrindid))
6566 continue; /* Uniqueness definitely not violated */
6567 }
6568
6569 /*
6570 * Fill in event structure and add it to the current query's queue.
6571 * Note we set ats_table to NULL whenever this trigger doesn't use
6572 * transition tables, to improve sharability of the shared event data.
6573 */
6574 new_shared.ats_event =
6575 (event & TRIGGER_EVENT_OPMASK) |
6577 (trigger->tgdeferrable ? AFTER_TRIGGER_DEFERRABLE : 0) |
6578 (trigger->tginitdeferred ? AFTER_TRIGGER_INITDEFERRED : 0);
6579 new_shared.ats_tgoid = trigger->tgoid;
6580 new_shared.ats_relid = RelationGetRelid(rel);
6581 new_shared.ats_rolid = GetUserId();
6582 new_shared.ats_firing_id = 0;
6583 if ((trigger->tgoldtable || trigger->tgnewtable) &&
6584 transition_capture != NULL)
6585 {
6586 switch (event)
6587 {
6589 new_shared.ats_table = transition_capture->tcs_insert_private;
6590 break;
6592 new_shared.ats_table = transition_capture->tcs_update_private;
6593 break;
6595 new_shared.ats_table = transition_capture->tcs_delete_private;
6596 break;
6597 default:
6598 /* Must be TRUNCATE, see switch above */
6599 new_shared.ats_table = NULL;
6600 break;
6601 }
6602 }
6603 else
6604 new_shared.ats_table = NULL;
6605 new_shared.ats_modifiedcols = modifiedCols;
6606
6609 }
6610
6611 /*
6612 * Finally, spool any foreign tuple(s). The tuplestore squashes them to
6613 * minimal tuples, so this loses any system columns. The executor lost
6614 * those columns before us, for an unrelated reason, so this is fine.
6615 */
6616 if (fdw_tuplestore)
6617 {
6618 if (oldslot != NULL)
6619 tuplestore_puttupleslot(fdw_tuplestore, oldslot);
6620 if (newslot != NULL)
6621 tuplestore_puttupleslot(fdw_tuplestore, newslot);
6622 }
6623}
6624
6625/*
6626 * Detect whether we already queued BEFORE STATEMENT triggers for the given
6627 * relation + operation, and set the flag so the next call will report "true".
6628 */
6629static bool
6631{
6632 bool result;
6634
6635 /* Check state, like AfterTriggerSaveEvent. */
6636 if (afterTriggers.query_depth < 0)
6637 elog(ERROR, "before_stmt_triggers_fired() called outside of query");
6638
6639 /* Be sure we have enough space to record events at this query depth. */
6642
6643 /*
6644 * We keep this state in the AfterTriggersTableData that also holds
6645 * transition tables for the relation + operation. In this way, if we are
6646 * forced to make a new set of transition tables because more tuples get
6647 * entered after we've already fired triggers, we will allow a new set of
6648 * statement triggers to get queued.
6649 */
6650 table = GetAfterTriggersTableData(relid, cmdType);
6651 result = table->before_trig_done;
6652 table->before_trig_done = true;
6653 return result;
6654}
6655
6656/*
6657 * If we previously queued a set of AFTER STATEMENT triggers for the given
6658 * relation + operation, and they've not been fired yet, cancel them. The
6659 * caller will queue a fresh set that's after any row-level triggers that may
6660 * have been queued by the current sub-statement, preserving (as much as
6661 * possible) the property that AFTER ROW triggers fire before AFTER STATEMENT
6662 * triggers, and that the latter only fire once. This deals with the
6663 * situation where several FK enforcement triggers sequentially queue triggers
6664 * for the same table into the same trigger query level. We can't fully
6665 * prevent odd behavior though: if there are AFTER ROW triggers taking
6666 * transition tables, we don't want to change the transition tables once the
6667 * first such trigger has seen them. In such a case, any additional events
6668 * will result in creating new transition tables and allowing new firings of
6669 * statement triggers.
6670 *
6671 * This also saves the current event list location so that a later invocation
6672 * of this function can cheaply find the triggers we're about to queue and
6673 * cancel them.
6674 */
6675static void
6677{
6680
6681 /*
6682 * We keep this state in the AfterTriggersTableData that also holds
6683 * transition tables for the relation + operation. In this way, if we are
6684 * forced to make a new set of transition tables because more tuples get
6685 * entered after we've already fired triggers, we will allow a new set of
6686 * statement triggers to get queued without canceling the old ones.
6687 */
6688 table = GetAfterTriggersTableData(relid, cmdType);
6689
6690 if (table->after_trig_done)
6691 {
6692 /*
6693 * We want to start scanning from the tail location that existed just
6694 * before we inserted any statement triggers. But the events list
6695 * might've been entirely empty then, in which case scan from the
6696 * current head.
6697 */
6698 AfterTriggerEvent event;
6700
6701 if (table->after_trig_events.tail)
6702 {
6703 chunk = table->after_trig_events.tail;
6704 event = (AfterTriggerEvent) table->after_trig_events.tailfree;
6705 }
6706 else
6707 {
6708 chunk = qs->events.head;
6709 event = NULL;
6710 }
6711
6712 for_each_chunk_from(chunk)
6713 {
6714 if (event == NULL)
6715 event = (AfterTriggerEvent) CHUNK_DATA_START(chunk);
6716 for_each_event_from(event, chunk)
6717 {
6719
6720 /*
6721 * Exit loop when we reach events that aren't AS triggers for
6722 * the target relation.
6723 */
6724 if (evtshared->ats_relid != relid)
6725 goto done;
6726 if ((evtshared->ats_event & TRIGGER_EVENT_OPMASK) != tgevent)
6727 goto done;
6728 if (!TRIGGER_FIRED_FOR_STATEMENT(evtshared->ats_event))
6729 goto done;
6730 if (!TRIGGER_FIRED_AFTER(evtshared->ats_event))
6731 goto done;
6732 /* OK, mark it DONE */
6733 event->ate_flags &= ~AFTER_TRIGGER_IN_PROGRESS;
6734 event->ate_flags |= AFTER_TRIGGER_DONE;
6735 }
6736 /* signal we must reinitialize event ptr for next chunk */
6737 event = NULL;
6738 }
6739 }
6740done:
6741
6742 /* In any case, save current insertion point for next time */
6743 table->after_trig_done = true;
6744 table->after_trig_events = qs->events;
6745}
6746
6747/*
6748 * GUC assign_hook for session_replication_role
6749 */
6750void
6752{
6753 /*
6754 * Must flush the plan cache when changing replication role; but don't
6755 * flush unnecessarily.
6756 */
6759}
6760
6761/*
6762 * SQL function pg_trigger_depth()
6763 */
6764Datum
6769
6770/*
6771 * Check whether a trigger modified a virtual generated column and replace the
6772 * value with null if so.
6773 *
6774 * We need to check this so that we don't end up storing a non-null value in a
6775 * virtual generated column.
6776 *
6777 * We don't need to check for stored generated columns, since those will be
6778 * overwritten later anyway.
6779 */
6780static HeapTuple
6782{
6783 if (!(tupdesc->constr && tupdesc->constr->has_generated_virtual))
6784 return tuple;
6785
6786 for (int i = 0; i < tupdesc->natts; i++)
6787 {
6788 if (TupleDescAttr(tupdesc, i)->attgenerated == ATTRIBUTE_GENERATED_VIRTUAL)
6789 {
6790 if (!heap_attisnull(tuple, i + 1, tupdesc))
6791 {
6792 int replCol = i + 1;
6793 Datum replValue = 0;
6794 bool replIsnull = true;
6795
6796 tuple = heap_modify_tuple_by_cols(tuple, tupdesc, 1, &replCol, &replValue, &replIsnull);
6797 }
6798 }
6799 }
6800
6801 return tuple;
6802}
6803
6804/*
6805 * RegisterAfterTriggerBatchCallback
6806 * Register a function to be called when the current trigger-firing
6807 * batch completes.
6808 *
6809 * Must be called from within a trigger function's execution context
6810 * (i.e., while afterTriggers state is active).
6811 *
6812 * The callback list is cleared after invocation, so the caller must
6813 * re-register for each new batch if needed.
6814 */
6815void
6817 void *arg)
6818{
6821
6822 /*
6823 * Allocate in TopTransactionContext so the item survives for the duration
6824 * of the batch, which may span multiple trigger invocations.
6825 *
6826 * Must be called while afterTriggers is active; callbacks registered
6827 * outside a trigger-firing context would never fire.
6828 */
6831 item = palloc(sizeof(AfterTriggerCallbackItem));
6832 item->callback = callback;
6833 item->arg = arg;
6837}
6838
6839/*
6840 * FireAfterTriggerBatchCallbacks
6841 * Invoke and clear all registered batch callbacks.
6842 *
6843 * Only fires at the outermost query level (query_depth == 0) or from
6844 * top-level operations (query_depth == -1, e.g. AfterTriggerFireDeferred
6845 * at COMMIT). Nested queries from SPI inside AFTER triggers run at
6846 * depth > 0 and must not tear down resources the outer batch still needs.
6847 */
6848static void
6850{
6851 ListCell *lc;
6852
6853 if (afterTriggers.query_depth > 0)
6854 return;
6855
6858 {
6860
6861 item->callback(item->arg);
6862 }
6863
6866}
6867
6868/*
6869 * AfterTriggerIsActive
6870 * Returns true if we're inside the after-trigger framework where
6871 * registered batch callbacks will actually be invoked.
6872 *
6873 * This is false during validateForeignKeyConstraint(), which calls
6874 * RI trigger functions directly outside the after-trigger framework.
6875 */
6876bool
6878{
6879 return afterTriggerFiringDepth > 0;
6880}
AclResult
Definition acl.h:183
@ ACLCHECK_OK
Definition acl.h:184
@ ACLCHECK_NOT_OWNER
Definition acl.h:186
void aclcheck_error(AclResult aclerr, ObjectType objtype, const char *objectname)
Definition aclchk.c:2672
AclResult object_aclcheck(Oid classid, Oid objectid, Oid roleid, AclMode mode)
Definition aclchk.c:3879
bool object_ownercheck(Oid classid, Oid objectid, Oid roleid)
Definition aclchk.c:4133
AclResult pg_class_aclcheck(Oid table_oid, Oid roleid, AclMode mode)
Definition aclchk.c:4082
#define InvalidAttrNumber
Definition attnum.h:23
bool bms_equal(const Bitmapset *a, const Bitmapset *b)
Definition bitmapset.c:142
bool bms_is_member(int x, const Bitmapset *a)
Definition bitmapset.c:510
Bitmapset * bms_copy(const Bitmapset *a)
Definition bitmapset.c:122
static Datum values[MAXATTR]
Definition bootstrap.c:190
#define CStringGetTextDatum(s)
Definition builtins.h:98
#define TextDatumGetCString(d)
Definition builtins.h:99
Datum byteain(PG_FUNCTION_ARGS)
Definition bytea.c:202
#define NameStr(name)
Definition c.h:835
#define Min(x, y)
Definition c.h:1091
#define Max(x, y)
Definition c.h:1085
#define Assert(condition)
Definition c.h:943
#define FLEXIBLE_ARRAY_MEMBER
Definition c.h:558
int16_t int16
Definition c.h:619
#define unlikely(x)
Definition c.h:438
uint32_t uint32
Definition c.h:624
#define pg_fallthrough
Definition c.h:161
uint32 CommandId
Definition c.h:750
#define OidIsValid(objectId)
Definition c.h:858
size_t Size
Definition c.h:689
bool IsSystemRelation(Relation relation)
Definition catalog.c:74
Oid GetNewOidWithIndex(Relation relation, Oid indexId, AttrNumber oidcolumn)
Definition catalog.c:448
bool IsSystemClass(Oid relid, Form_pg_class reltuple)
Definition catalog.c:86
uint32 result
memcpy(sums, checksumBaseOffsets, sizeof(checksumBaseOffsets))
void recordDependencyOnExpr(const ObjectAddress *depender, Node *expr, List *rtable, DependencyType behavior)
@ DEPENDENCY_AUTO
Definition dependency.h:34
@ DEPENDENCY_INTERNAL
Definition dependency.h:35
@ DEPENDENCY_PARTITION_PRI
Definition dependency.h:36
@ DEPENDENCY_PARTITION_SEC
Definition dependency.h:37
@ DEPENDENCY_NORMAL
Definition dependency.h:33
Datum arg
Definition elog.c:1322
int errcode(int sqlerrcode)
Definition elog.c:874
int errhint(const char *fmt,...) pg_attribute_printf(1
int errdetail(const char *fmt,...) pg_attribute_printf(1
#define PG_TRY(...)
Definition elog.h:374
#define PG_END_TRY(...)
Definition elog.h:399
#define ERROR
Definition elog.h:40
#define elog(elevel,...)
Definition elog.h:228
#define NOTICE
Definition elog.h:36
#define PG_FINALLY(...)
Definition elog.h:391
#define ereport(elevel,...)
Definition elog.h:152
ExprState * ExecPrepareQual(List *qual, EState *estate)
Definition execExpr.c:826
LockTupleMode ExecUpdateLockMode(EState *estate, ResultRelInfo *relinfo)
Definition execMain.c:2559
ResultRelInfo * ExecGetTriggerResultRel(EState *estate, Oid relid, ResultRelInfo *rootRelInfo)
Definition execMain.c:1372
bool ExecPartitionCheck(ResultRelInfo *resultRelInfo, TupleTableSlot *slot, EState *estate, bool emitError)
Definition execMain.c:1885
TupleTableSlot * EvalPlanQual(EPQState *epqstate, Relation relation, Index rti, TupleTableSlot *inputslot)
Definition execMain.c:2678
void ExecCloseResultRelations(EState *estate)
Definition execMain.c:1604
void ExecResetTupleTable(List *tupleTable, bool shouldFree)
TupleTableSlot * MakeSingleTupleTableSlot(TupleDesc tupdesc, const TupleTableSlotOps *tts_ops)
const TupleTableSlotOps TTSOpsVirtual
Definition execTuples.c:84
void ExecDropSingleTupleTableSlot(TupleTableSlot *slot)
HeapTuple ExecFetchSlotHeapTuple(TupleTableSlot *slot, bool materialize, bool *shouldFree)
const TupleTableSlotOps TTSOpsMinimalTuple
Definition execTuples.c:86
void ExecForceStoreHeapTuple(HeapTuple tuple, TupleTableSlot *slot, bool shouldFree)
TupleTableSlot * ExecGetTriggerNewSlot(EState *estate, ResultRelInfo *relInfo)
Definition execUtils.c:1252
TupleConversionMap * ExecGetChildToRootMap(ResultRelInfo *resultRelInfo)
Definition execUtils.c:1326
TupleTableSlot * ExecGetTriggerOldSlot(EState *estate, ResultRelInfo *relInfo)
Definition execUtils.c:1230
void FreeExecutorState(EState *estate)
Definition execUtils.c:197
Bitmapset * ExecGetAllUpdatedCols(ResultRelInfo *relinfo, EState *estate)
Definition execUtils.c:1444
EState * CreateExecutorState(void)
Definition execUtils.c:90
#define GetPerTupleExprContext(estate)
Definition executor.h:667
#define GetPerTupleMemoryContext(estate)
Definition executor.h:672
static bool ExecQual(ExprState *state, ExprContext *econtext)
Definition executor.h:529
#define palloc_object(type)
Definition fe_memutils.h:74
#define palloc0_object(type)
Definition fe_memutils.h:75
void fmgr_info(Oid functionId, FmgrInfo *finfo)
Definition fmgr.c:129
#define DatumGetByteaPP(X)
Definition fmgr.h:292
#define InitFunctionCallInfoData(Fcinfo, Flinfo, Nargs, Collation, Context, Resultinfo)
Definition fmgr.h:150
#define DirectFunctionCall1(func, arg1)
Definition fmgr.h:684
#define LOCAL_FCINFO(name, nargs)
Definition fmgr.h:110
#define FunctionCallInvoke(fcinfo)
Definition fmgr.h:172
#define PG_RETURN_INT32(x)
Definition fmgr.h:355
#define PG_FUNCTION_ARGS
Definition fmgr.h:193
void systable_endscan(SysScanDesc sysscan)
Definition genam.c:612
HeapTuple systable_getnext(SysScanDesc sysscan)
Definition genam.c:523
SysScanDesc systable_beginscan(Relation heapRelation, Oid indexId, bool indexOK, Snapshot snapshot, int nkeys, ScanKey key)
Definition genam.c:388
bool allowSystemTableMods
Definition globals.c:132
int work_mem
Definition globals.c:133
Oid MyDatabaseId
Definition globals.c:96
#define newval
HeapTuple heap_copytuple(HeapTuple tuple)
Definition heaptuple.c:686
HeapTuple heap_modify_tuple_by_cols(HeapTuple tuple, TupleDesc tupleDesc, int nCols, const int *replCols, const Datum *replValues, const bool *replIsnull)
Definition heaptuple.c:1186
HeapTuple heap_form_tuple(TupleDesc tupleDescriptor, const Datum *values, const bool *isnull)
Definition heaptuple.c:1025
bool heap_attisnull(HeapTuple tup, int attnum, TupleDesc tupleDesc)
Definition heaptuple.c:456
void heap_freetuple(HeapTuple htup)
Definition heaptuple.c:1372
#define HeapTupleIsValid(tuple)
Definition htup.h:78
static void * GETSTRUCT(const HeapTupleData *tuple)
static Datum fastgetattr(HeapTuple tup, int attnum, TupleDesc tupleDesc, bool *isnull)
#define stmt
void CatalogTupleUpdate(Relation heapRel, const ItemPointerData *otid, HeapTuple tup)
Definition indexing.c:313
void CatalogTupleInsert(Relation heapRel, HeapTuple tup)
Definition indexing.c:233
void CatalogTupleDelete(Relation heapRel, const ItemPointerData *tid)
Definition indexing.c:365
long val
Definition informix.c:689
void InstrStartTrigger(TriggerInstrumentation *tginstr)
Definition instrument.c:265
void InstrStopTrigger(TriggerInstrumentation *tginstr, int64 firings)
Definition instrument.c:271
int2vector * buildint2vector(const int16 *int2s, int n)
Definition int.c:114
void CacheInvalidateRelcache(Relation relation)
Definition inval.c:1635
void CacheInvalidateRelcacheByTuple(HeapTuple classTuple)
Definition inval.c:1669
int j
Definition isn.c:78
int i
Definition isn.c:77
static void ItemPointerSetInvalid(ItemPointerData *pointer)
Definition itemptr.h:184
static void ItemPointerCopy(const ItemPointerData *fromPointer, ItemPointerData *toPointer)
Definition itemptr.h:172
static bool ItemPointerIsValid(const ItemPointerData *pointer)
Definition itemptr.h:83
List * lappend(List *list, void *datum)
Definition list.c:339
List * lappend_oid(List *list, Oid datum)
Definition list.c:375
void list_free(List *list)
Definition list.c:1546
bool list_member_oid(const List *list, Oid datum)
Definition list.c:722
void list_free_deep(List *list)
Definition list.c:1560
void LockRelationOid(Oid relid, LOCKMODE lockmode)
Definition lmgr.c:107
int LOCKMODE
Definition lockdefs.h:26
#define NoLock
Definition lockdefs.h:34
#define AccessExclusiveLock
Definition lockdefs.h:43
#define ShareRowExclusiveLock
Definition lockdefs.h:41
#define AccessShareLock
Definition lockdefs.h:36
#define RowExclusiveLock
Definition lockdefs.h:38
@ LockWaitBlock
Definition lockoptions.h:40
LockTupleMode
Definition lockoptions.h:51
@ LockTupleExclusive
Definition lockoptions.h:59
char * get_rel_name(Oid relid)
Definition lsyscache.c:2148
char * get_database_name(Oid dbid)
Definition lsyscache.c:1312
char get_rel_relkind(Oid relid)
Definition lsyscache.c:2223
char * get_namespace_name(Oid nspid)
Definition lsyscache.c:3588
Oid get_func_rettype(Oid funcid)
Definition lsyscache.c:1875
Alias * makeAlias(const char *aliasname, List *colnames)
Definition makefuncs.c:438
List * make_ands_implicit(Expr *clause)
Definition makefuncs.c:810
void * MemoryContextAlloc(MemoryContext context, Size size)
Definition mcxt.c:1232
void MemoryContextReset(MemoryContext context)
Definition mcxt.c:403
void * MemoryContextAllocZero(MemoryContext context, Size size)
Definition mcxt.c:1266
MemoryContext TopTransactionContext
Definition mcxt.c:171
char * pstrdup(const char *in)
Definition mcxt.c:1781
void * repalloc(void *pointer, Size size)
Definition mcxt.c:1632
void pfree(void *pointer)
Definition mcxt.c:1616
void * palloc(Size size)
Definition mcxt.c:1387
MemoryContext CurTransactionContext
Definition mcxt.c:172
MemoryContext CurrentMemoryContext
Definition mcxt.c:160
MemoryContext CacheMemoryContext
Definition mcxt.c:169
void MemoryContextDelete(MemoryContext context)
Definition mcxt.c:472
#define AllocSetContextCreate
Definition memutils.h:129
#define ALLOCSET_DEFAULT_SIZES
Definition memutils.h:160
#define ALLOCSET_SMALL_SIZES
Definition memutils.h:170
#define SECURITY_LOCAL_USERID_CHANGE
Definition miscadmin.h:330
void GetUserIdAndSecContext(Oid *userid, int *sec_context)
Definition miscinit.c:613
bool InSecurityRestrictedOperation(void)
Definition miscinit.c:640
Oid GetUserId(void)
Definition miscinit.c:470
void SetUserIdAndSecContext(Oid userid, int sec_context)
Definition miscinit.c:620
Datum nameout(PG_FUNCTION_ARGS)
Definition name.c:71
void namestrcpy(Name name, const char *str)
Definition name.c:233
Datum namein(PG_FUNCTION_ARGS)
Definition name.c:48
char * NameListToString(const List *names)
Definition namespace.c:3666
Oid LookupExplicitNamespace(const char *nspname, bool missing_ok)
Definition namespace.c:3457
List * fetch_search_path(bool includeImplicit)
Definition namespace.c:4891
Oid RangeVarGetRelidExtended(const RangeVar *relation, LOCKMODE lockmode, uint32 flags, RangeVarGetRelidCallback callback, void *callback_arg)
Definition namespace.c:442
#define RangeVarGetRelid(relation, lockmode, missing_ok)
Definition namespace.h:98
TupleTableSlot * ExecGetUpdateNewTuple(ResultRelInfo *relinfo, TupleTableSlot *planSlot, TupleTableSlot *oldSlot)
#define copyObject(obj)
Definition nodes.h:232
CmdType
Definition nodes.h:273
@ CMD_MERGE
Definition nodes.h:279
@ CMD_INSERT
Definition nodes.h:277
@ CMD_DELETE
Definition nodes.h:278
@ CMD_UPDATE
Definition nodes.h:276
static char * errmsg
#define InvokeObjectPostAlterHook(classId, objectId, subId)
#define InvokeObjectPostCreateHookArg(classId, objectId, subId, is_internal)
ObjectType get_relkind_objtype(char relkind)
#define ObjectAddressSet(addr, class_id, object_id)
char * nodeToString(const void *obj)
Definition outfuncs.c:811
static MemoryContext MemoryContextSwitchTo(MemoryContext context)
Definition palloc.h:124
Node * transformWhereClause(ParseState *pstate, Node *clause, ParseExprKind exprKind, const char *constructName)
void assign_expr_collations(ParseState *pstate, Node *expr)
Oid LookupFuncName(List *funcname, int nargs, const Oid *argtypes, bool missing_ok)
void free_parsestate(ParseState *pstate)
Definition parse_node.c:72
int parser_errposition(ParseState *pstate, int location)
Definition parse_node.c:106
ParseState * make_parsestate(ParseState *parentParseState)
Definition parse_node.c:39
@ EXPR_KIND_TRIGGER_WHEN
Definition parse_node.h:78
void addNSItemToQuery(ParseState *pstate, ParseNamespaceItem *nsitem, bool addToJoinList, bool addToRelNameSpace, bool addToVarNameSpace)
ParseNamespaceItem * addRangeTableEntryForRelation(ParseState *pstate, Relation rel, LOCKMODE lockmode, Alias *alias, bool inh, bool inFromCl)
int attnameAttNum(Relation rd, const char *attname, bool sysColOK)
@ OBJECT_FUNCTION
#define ACL_EXECUTE
Definition parsenodes.h:83
#define ACL_TRIGGER
Definition parsenodes.h:82
PartitionDesc RelationGetPartitionDesc(Relation rel, bool omit_detached)
Definition partdesc.c:71
List * map_partition_varattnos(List *expr, int fromrel_varno, Relation to_rel, Relation from_rel)
Definition partition.c:222
Oid get_partition_parent(Oid relid, bool even_if_detached)
Definition partition.c:53
int16 attnum
int errdetail_relkind_not_supported(char relkind)
Definition pg_class.c:24
FormData_pg_class * Form_pg_class
Definition pg_class.h:160
#define NAMEDATALEN
Oid CreateConstraintEntry(const char *constraintName, Oid constraintNamespace, char constraintType, bool isDeferrable, bool isDeferred, bool isEnforced, bool isValidated, Oid parentConstrId, Oid relId, const int16 *constraintKey, int constraintNKeys, int constraintNTotalKeys, Oid domainId, Oid indexRelId, Oid foreignRelId, const int16 *foreignKey, const Oid *pfEqOp, const Oid *ppEqOp, const Oid *ffEqOp, int foreignNKeys, char foreignUpdateType, char foreignDeleteType, const int16 *fkDeleteSetCols, int numFkDeleteSetCols, char foreignMatchType, const Oid *exclOp, Node *conExpr, const char *conBin, bool conIsLocal, int16 conInhCount, bool conNoInherit, bool conPeriod, bool is_internal)
END_CATALOG_STRUCT typedef FormData_pg_constraint * Form_pg_constraint
const void size_t len
void recordDependencyOn(const ObjectAddress *depender, const ObjectAddress *referenced, DependencyType behavior)
Definition pg_depend.c:47
long deleteDependencyRecordsForClass(Oid classId, Oid objectId, Oid refclassId, char deptype)
Definition pg_depend.c:353
long deleteDependencyRecordsFor(Oid classId, Oid objectId, bool skipExtensionDeps)
Definition pg_depend.c:303
List * find_all_inheritors(Oid parentrelId, LOCKMODE lockmode, List **numparents)
bool has_superclass(Oid relationId)
#define lfirst(lc)
Definition pg_list.h:172
#define lfirst_node(type, lc)
Definition pg_list.h:176
static int list_length(const List *l)
Definition pg_list.h:152
#define NIL
Definition pg_list.h:68
#define list_make1_oid(x1)
Definition pg_list.h:274
#define lfirst_oid(lc)
Definition pg_list.h:174
static const struct lconv_member_info table[]
END_CATALOG_STRUCT typedef FormData_pg_trigger * Form_pg_trigger
Definition pg_trigger.h:84
#define ERRCODE_T_R_SERIALIZATION_FAILURE
Definition pgbench.c:77
void pgstat_init_function_usage(FunctionCallInfo fcinfo, PgStat_FunctionCallUsage *fcu)
void pgstat_end_function_usage(PgStat_FunctionCallUsage *fcu, bool finalize)
void ResetPlanCache(void)
Definition plancache.c:2328
#define snprintf
Definition port.h:260
static Datum PointerGetDatum(const void *X)
Definition postgres.h:342
static Datum Int16GetDatum(int16 X)
Definition postgres.h:172
static Datum BoolGetDatum(bool X)
Definition postgres.h:112
static Datum ObjectIdGetDatum(Oid X)
Definition postgres.h:252
static char * DatumGetCString(Datum X)
Definition postgres.h:355
static Datum NameGetDatum(const NameData *X)
Definition postgres.h:393
uint64_t Datum
Definition postgres.h:70
static Pointer DatumGetPointer(Datum X)
Definition postgres.h:332
static Datum CStringGetDatum(const char *X)
Definition postgres.h:370
static Datum CharGetDatum(char X)
Definition postgres.h:132
#define InvalidOid
unsigned int Oid
static void test(void)
static int fb(int x)
#define PRS2_OLD_VARNO
Definition primnodes.h:251
#define PRS2_NEW_VARNO
Definition primnodes.h:252
#define OUTER_VAR
Definition primnodes.h:244
#define INNER_VAR
Definition primnodes.h:243
void * stringToNode(const char *str)
Definition read.c:90
#define RelationHasReferenceCountZero(relation)
Definition rel.h:500
#define RelationGetRelid(relation)
Definition rel.h:516
#define RelationGetDescr(relation)
Definition rel.h:542
#define RelationGetRelationName(relation)
Definition rel.h:550
#define RelationGetNamespace(relation)
Definition rel.h:557
ResourceOwner CurrentResourceOwner
Definition resowner.c:173
ResourceOwner CurTransactionResourceOwner
Definition resowner.c:174
Node * expand_generated_columns_in_expr(Node *node, Relation rel, int rt_index)
void ChangeVarNodes(Node *node, int rt_index, int new_index, int sublevels_up)
bool RI_FKey_pk_upd_check_required(Trigger *trigger, Relation pk_rel, TupleTableSlot *oldslot, TupleTableSlot *newslot)
bool RI_FKey_fk_upd_check_required(Trigger *trigger, Relation fk_rel, TupleTableSlot *oldslot, TupleTableSlot *newslot)
int RI_FKey_trigger_type(Oid tgfoid)
void ScanKeyInit(ScanKey entry, AttrNumber attributeNumber, StrategyNumber strategy, RegProcedure procedure, Datum argument)
Definition scankey.c:76
Snapshot GetTransactionSnapshot(void)
Definition snapmgr.c:272
void PushActiveSnapshot(Snapshot snapshot)
Definition snapmgr.c:682
void PopActiveSnapshot(void)
Definition snapmgr.c:775
#define SnapshotAny
Definition snapmgr.h:33
void relation_close(Relation relation, LOCKMODE lockmode)
Definition relation.c:206
Relation relation_open(Oid relationId, LOCKMODE lockmode)
Definition relation.c:48
#define BTEqualStrategyNumber
Definition stratnum.h:31
#define ERRCODE_DUPLICATE_OBJECT
Definition streamutil.c:30
AfterTriggerBatchCallback callback
Definition trigger.c:3937
struct AfterTriggerEventChunk * next
Definition trigger.c:3765
ItemPointerData ate_ctid1
Definition trigger.c:3727
ItemPointerData ate_ctid2
Definition trigger.c:3728
ItemPointerData ate_ctid1
Definition trigger.c:3735
ItemPointerData ate_ctid2
Definition trigger.c:3712
TriggerFlags ate_flags
Definition trigger.c:3710
ItemPointerData ate_ctid1
Definition trigger.c:3711
AfterTriggerEventChunk * head
Definition trigger.c:3777
AfterTriggerEventChunk * tail
Definition trigger.c:3778
TriggerEvent ats_event
Definition trigger.c:3697
struct AfterTriggersTableData * ats_table
Definition trigger.c:3702
CommandId ats_firing_id
Definition trigger.c:3701
Bitmapset * ats_modifiedcols
Definition trigger.c:3703
SetConstraintState state
Definition trigger.c:3884
AfterTriggersQueryData * query_stack
Definition trigger.c:3889
MemoryContext event_cxt
Definition trigger.c:3886
List * batch_callbacks
Definition trigger.c:3897
CommandId firing_counter
Definition trigger.c:3883
AfterTriggersTransData * trans_stack
Definition trigger.c:3894
AfterTriggerEventList events
Definition trigger.c:3885
Tuplestorestate * fdw_tuplestore
Definition trigger.c:3903
AfterTriggerEventList events
Definition trigger.c:3902
Tuplestorestate * new_tuplestore
Definition trigger.c:3929
TupleTableSlot * storeslot
Definition trigger.c:3931
Tuplestorestate * old_tuplestore
Definition trigger.c:3927
AfterTriggerEventList after_trig_events
Definition trigger.c:3924
AfterTriggerEventList events
Definition trigger.c:3911
SetConstraintState state
Definition trigger.c:3910
CommandId firing_counter
Definition trigger.c:3913
MemoryContext es_query_cxt
Definition execnodes.h:746
List * es_tupleTable
Definition execnodes.h:748
CommandId es_output_cid
Definition execnodes.h:718
Snapshot es_snapshot
Definition execnodes.h:696
TupleTableSlot * ecxt_innertuple
Definition execnodes.h:289
TupleTableSlot * ecxt_outertuple
Definition execnodes.h:291
Oid fn_oid
Definition fmgr.h:59
ItemPointerData t_self
Definition htup.h:65
Definition pg_list.h:54
Definition nodes.h:135
const char * p_sourcetext
Definition parse_node.h:214
List * p_rtable
Definition parse_node.h:215
char * relname
Definition primnodes.h:84
char * catalogname
Definition primnodes.h:78
char * schemaname
Definition primnodes.h:81
TriggerDesc * trigdesc
Definition rel.h:117
TupleDesc rd_att
Definition rel.h:112
Oid rd_id
Definition rel.h:113
Form_pg_class rd_rel
Definition rel.h:111
SetConstraintTriggerData trigstates[FLEXIBLE_ARRAY_MEMBER]
Definition trigger.c:3633
CommandId cmax
Definition tableam.h:173
TupleTableSlot * tcs_original_insert_tuple
Definition trigger.h:76
struct AfterTriggersTableData * tcs_insert_private
Definition trigger.h:81
struct AfterTriggersTableData * tcs_update_private
Definition trigger.h:82
struct AfterTriggersTableData * tcs_delete_private
Definition trigger.h:83
Tuplestorestate * tg_oldtable
Definition trigger.h:41
NodeTag type
Definition trigger.h:33
Tuplestorestate * tg_newtable
Definition trigger.h:42
TriggerEvent tg_event
Definition trigger.h:34
Trigger * tg_trigger
Definition trigger.h:38
int numtriggers
Definition reltrigger.h:50
bool trig_delete_before_row
Definition reltrigger.h:66
bool trig_update_instead_row
Definition reltrigger.h:63
Trigger * triggers
Definition reltrigger.h:49
bool trig_delete_instead_row
Definition reltrigger.h:68
bool trig_update_after_row
Definition reltrigger.h:62
bool trig_insert_instead_row
Definition reltrigger.h:58
bool trig_update_new_table
Definition reltrigger.h:77
bool trig_insert_after_row
Definition reltrigger.h:57
bool trig_update_after_statement
Definition reltrigger.h:65
bool trig_update_before_row
Definition reltrigger.h:61
bool trig_truncate_before_statement
Definition reltrigger.h:72
bool trig_insert_new_table
Definition reltrigger.h:75
bool trig_update_before_statement
Definition reltrigger.h:64
bool trig_truncate_after_statement
Definition reltrigger.h:73
bool trig_insert_before_statement
Definition reltrigger.h:59
bool trig_delete_old_table
Definition reltrigger.h:78
bool trig_delete_after_row
Definition reltrigger.h:67
bool trig_insert_before_row
Definition reltrigger.h:56
bool trig_delete_after_statement
Definition reltrigger.h:70
bool trig_delete_before_statement
Definition reltrigger.h:69
bool trig_update_old_table
Definition reltrigger.h:76
bool trig_insert_after_statement
Definition reltrigger.h:60
Oid tgoid
Definition reltrigger.h:25
char * tgname
Definition reltrigger.h:27
Oid tgfoid
Definition reltrigger.h:28
bool has_generated_virtual
Definition tupdesc.h:47
AttrMap * attrMap
Definition tupconvert.h:28
TupleDesc outdesc
Definition tupconvert.h:27
TupleConstr * constr
Definition tupdesc.h:159
ParseLoc location
Definition primnodes.h:311
AttrNumber varattno
Definition primnodes.h:275
int varno
Definition primnodes.h:270
Definition c.h:776
bool superuser(void)
Definition superuser.c:47
#define FirstLowInvalidHeapAttributeNumber
Definition sysattr.h:27
void ReleaseSysCache(HeapTuple tuple)
Definition syscache.c:265
HeapTuple SearchSysCache1(SysCacheIdentifier cacheId, Datum key1)
Definition syscache.c:221
#define SearchSysCacheCopy1(cacheId, key1)
Definition syscache.h:91
void table_close(Relation relation, LOCKMODE lockmode)
Definition table.c:126
Relation table_open(Oid relationId, LOCKMODE lockmode)
Definition table.c:40
Relation table_openrv(const RangeVar *relation, LOCKMODE lockmode)
Definition table.c:83
TM_Result
Definition tableam.h:95
@ TM_Ok
Definition tableam.h:100
@ TM_Deleted
Definition tableam.h:115
@ TM_Updated
Definition tableam.h:112
@ TM_SelfModified
Definition tableam.h:106
@ TM_Invisible
Definition tableam.h:103
static TM_Result table_tuple_lock(Relation rel, ItemPointer tid, Snapshot snapshot, TupleTableSlot *slot, CommandId cid, LockTupleMode mode, LockWaitPolicy wait_policy, uint8 flags, TM_FailureData *tmfd)
Definition tableam.h:1648
#define TUPLE_LOCK_FLAG_FIND_LAST_VERSION
Definition tableam.h:299
static bool table_tuple_fetch_row_version(Relation rel, ItemPointer tid, Snapshot snapshot, TupleTableSlot *slot)
Definition tableam.h:1344
static void callback(struct sockaddr *addr, struct sockaddr *mask, void *unused)
static SetConstraintState SetConstraintStateCopy(SetConstraintState origstate)
Definition trigger.c:5756
static void cancel_prior_stmt_triggers(Oid relid, CmdType cmdType, int tgevent)
Definition trigger.c:6676
static AfterTriggersData afterTriggers
Definition trigger.c:3941
#define AFTER_TRIGGER_FDW_FETCH
Definition trigger.c:3688
static SetConstraintState SetConstraintStateAddItem(SetConstraintState state, Oid tgoid, bool tgisdeferred)
Definition trigger.c:5776
#define AFTER_TRIGGER_IN_PROGRESS
Definition trigger.c:3685
static void renametrig_internal(Relation tgrel, Relation targetrel, HeapTuple trigtup, const char *newname, const char *expected_name)
Definition trigger.c:1584
bool ExecBRUpdateTriggers(EState *estate, EPQState *epqstate, ResultRelInfo *relinfo, ItemPointer tupleid, HeapTuple fdw_trigtuple, TupleTableSlot *newslot, TM_Result *tmresult, TM_FailureData *tmfd, bool is_merge_update)
Definition trigger.c:2973
TransitionCaptureState * MakeTransitionCaptureState(TriggerDesc *trigdesc, Oid relid, CmdType cmdType)
Definition trigger.c:4976
static bool GetTupleForTrigger(EState *estate, EPQState *epqstate, ResultRelInfo *relinfo, ItemPointer tid, LockTupleMode lockmode, TupleTableSlot *oldslot, bool do_epq_recheck, TupleTableSlot **epqslot, TM_Result *tmresultp, TM_FailureData *tmfdp)
Definition trigger.c:3346
void AfterTriggerBeginXact(void)
Definition trigger.c:5102
void ExecARDeleteTriggers(EState *estate, ResultRelInfo *relinfo, ItemPointer tupleid, HeapTuple fdw_trigtuple, TransitionCaptureState *transition_capture, bool is_crosspart_update)
Definition trigger.c:2803
void ExecBSInsertTriggers(EState *estate, ResultRelInfo *relinfo)
Definition trigger.c:2403
static void afterTriggerDeleteHeadEventChunk(AfterTriggersQueryData *qs)
Definition trigger.c:4284
static AfterTriggersTableData * GetAfterTriggersTableData(Oid relid, CmdType cmdType)
Definition trigger.c:4885
static Bitmapset * afterTriggerCopyBitmap(Bitmapset *src)
Definition trigger.c:4071
#define CHUNK_DATA_START(cptr)
Definition trigger.c:3772
static void RangeVarCallbackForRenameTrigger(const RangeVar *rv, Oid relid, Oid oldrelid, void *arg)
Definition trigger.c:1422
bool ExecBRInsertTriggers(EState *estate, ResultRelInfo *relinfo, TupleTableSlot *slot)
Definition trigger.c:2467
void AfterTriggerEndSubXact(bool isCommit)
Definition trigger.c:5478
uint32 TriggerFlags
Definition trigger.c:3681
void ExecBSTruncateTriggers(EState *estate, ResultRelInfo *relinfo)
Definition trigger.c:3282
void RegisterAfterTriggerBatchCallback(AfterTriggerBatchCallback callback, void *arg)
Definition trigger.c:6816
#define AFTER_TRIGGER_TUP_BITS
Definition trigger.c:3692
static void FireAfterTriggerBatchCallbacks(void)
Definition trigger.c:6849
static bool TriggerEnabled(EState *estate, ResultRelInfo *relinfo, Trigger *trigger, TriggerEvent event, Bitmapset *modifiedCols, TupleTableSlot *oldslot, TupleTableSlot *newslot)
Definition trigger.c:3484
void FreeTriggerDesc(TriggerDesc *trigdesc)
Definition trigger.c:2147
bool ExecIRDeleteTriggers(EState *estate, ResultRelInfo *relinfo, HeapTuple trigtuple)
Definition trigger.c:2850
#define AFTER_TRIGGER_1CTID
Definition trigger.c:3689
bool AfterTriggerIsActive(void)
Definition trigger.c:6877
Datum pg_trigger_depth(PG_FUNCTION_ARGS)
Definition trigger.c:6765
void ExecBSDeleteTriggers(EState *estate, ResultRelInfo *relinfo)
Definition trigger.c:2632
#define MAX_CHUNK_SIZE
ObjectAddress CreateTriggerFiringOn(const CreateTrigStmt *stmt, const char *queryString, Oid relOid, Oid refRelOid, Oid constraintOid, Oid indexOid, Oid funcoid, Oid parentTriggerOid, Node *whenClause, bool isInternal, bool in_partition, char trigger_fires_when)
Definition trigger.c:179
void EnableDisableTrigger(Relation rel, const char *tgname, Oid tgparent, char fires_when, bool skip_system, bool recurse, LOCKMODE lockmode)
Definition trigger.c:1728
static void AfterTriggerFreeQuery(AfterTriggersQueryData *qs)
Definition trigger.c:5258
static void afterTriggerFreeEventList(AfterTriggerEventList *events)
Definition trigger.c:4223
const char * FindTriggerIncompatibleWithInheritance(TriggerDesc *trigdesc)
Definition trigger.c:2279
bool ExecIRInsertTriggers(EState *estate, ResultRelInfo *relinfo, TupleTableSlot *slot)
Definition trigger.c:2571
#define GetTriggerSharedData(evt)
Definition trigger.c:3753
static int MyTriggerDepth
Definition trigger.c:68
#define for_each_chunk_from(cptr)
Definition trigger.c:3794
static bool afterTriggerMarkEvents(AfterTriggerEventList *events, AfterTriggerEventList *move_list, bool immediate_only)
Definition trigger.c:4632
static Tuplestorestate * GetAfterTriggersTransitionTable(int event, TupleTableSlot *oldslot, TupleTableSlot *newslot, TransitionCaptureState *transition_capture)
Definition trigger.c:5575
void ExecASTruncateTriggers(EState *estate, ResultRelInfo *relinfo)
Definition trigger.c:3329
static bool afterTriggerInvokeEvents(AfterTriggerEventList *events, CommandId firing_id, EState *estate, bool delete_ok)
Definition trigger.c:4716
void ExecARUpdateTriggers(EState *estate, ResultRelInfo *relinfo, ResultRelInfo *src_partinfo, ResultRelInfo *dst_partinfo, ItemPointer tupleid, HeapTuple fdw_trigtuple, TupleTableSlot *newslot, List *recheckIndexes, TransitionCaptureState *transition_capture, bool is_crosspart_update)
Definition trigger.c:3146
struct AfterTriggerSharedData * AfterTriggerShared
Definition trigger.c:3693
void AfterTriggerSetState(ConstraintsSetStmt *stmt)
Definition trigger.c:5806
bool ExecBRDeleteTriggers(EState *estate, EPQState *epqstate, ResultRelInfo *relinfo, ItemPointer tupleid, HeapTuple fdw_trigtuple, TupleTableSlot **epqslot, TM_Result *tmresult, TM_FailureData *tmfd, bool is_merge_delete)
Definition trigger.c:2703
Oid get_trigger_oid(Oid relid, const char *trigname, bool missing_ok)
Definition trigger.c:1372
static void AfterTriggerExecute(EState *estate, AfterTriggerEvent event, ResultRelInfo *relInfo, ResultRelInfo *src_relInfo, ResultRelInfo *dst_relInfo, TriggerDesc *trigdesc, FmgrInfo *finfo, TriggerInstrumentation *instr, MemoryContext per_tuple_context, TupleTableSlot *trig_tuple_slot1, TupleTableSlot *trig_tuple_slot2)
Definition trigger.c:4346
static bool before_stmt_triggers_fired(Oid relid, CmdType cmdType)
Definition trigger.c:6630
static int afterTriggerFiringDepth
Definition trigger.c:3948
static void afterTriggerAddEvent(AfterTriggerEventList *events, AfterTriggerEvent event, AfterTriggerShared evtshared)
Definition trigger.c:4096
struct SetConstraintTriggerData * SetConstraintTrigger
Definition trigger.c:3615
#define AFTER_TRIGGER_2CTID
Definition trigger.c:3690
#define SizeofTriggerEvent(evt)
Definition trigger.c:3744
int SessionReplicationRole
Definition trigger.c:65
static HeapTuple ExecCallTriggerFunc(TriggerData *trigdata, int tgindx, FmgrInfo *finfo, TriggerInstrumentation *instr, MemoryContext per_tuple_context)
Definition trigger.c:2311
static bool afterTriggerCheckState(AfterTriggerShared evtshared)
Definition trigger.c:4026
void ExecASUpdateTriggers(EState *estate, ResultRelInfo *relinfo, TransitionCaptureState *transition_capture)
Definition trigger.c:2955
static SetConstraintState SetConstraintStateCreate(int numalloc)
Definition trigger.c:5731
void ExecASDeleteTriggers(EState *estate, ResultRelInfo *relinfo, TransitionCaptureState *transition_capture)
Definition trigger.c:2683
ObjectAddress renametrig(RenameStmt *stmt)
Definition trigger.c:1469
void AfterTriggerFireDeferred(void)
Definition trigger.c:5318
static void TransitionTableAddTuple(EState *estate, int event, TransitionCaptureState *transition_capture, ResultRelInfo *relinfo, TupleTableSlot *slot, TupleTableSlot *original_insert_tuple, Tuplestorestate *tuplestore)
Definition trigger.c:5626
void ExecARInsertTriggers(EState *estate, ResultRelInfo *relinfo, TupleTableSlot *slot, List *recheckIndexes, TransitionCaptureState *transition_capture)
Definition trigger.c:2545
void TriggerSetParentTrigger(Relation trigRel, Oid childTrigId, Oid parentTrigId, Oid childTableId)
Definition trigger.c:1222
static void afterTriggerRestoreEventList(AfterTriggerEventList *events, const AfterTriggerEventList *old_events)
Definition trigger.c:4244
static void SetTriggerFlags(TriggerDesc *trigdesc, Trigger *trigger)
Definition trigger.c:2015
#define for_each_event_from(eptr, cptr)
Definition trigger.c:3796
#define MIN_CHUNK_SIZE
static void renametrig_partition(Relation tgrel, Oid partitionId, Oid parentTriggerOid, const char *newname, const char *expected_name)
Definition trigger.c:1655
void ExecASInsertTriggers(EState *estate, ResultRelInfo *relinfo, TransitionCaptureState *transition_capture)
Definition trigger.c:2454
static Tuplestorestate * GetCurrentFDWTuplestore(void)
Definition trigger.c:3990
TriggerDesc * CopyTriggerDesc(TriggerDesc *trigdesc)
Definition trigger.c:2092
void assign_session_replication_role(int newval, void *extra)
Definition trigger.c:6751
bool ExecIRUpdateTriggers(EState *estate, ResultRelInfo *relinfo, HeapTuple trigtuple, TupleTableSlot *newslot)
Definition trigger.c:3216
void AfterTriggerEndXact(bool isCommit)
Definition trigger.c:5380
bool AfterTriggerPendingOnRel(Oid relid)
Definition trigger.c:6128
#define AFTER_TRIGGER_FDW_REUSE
Definition trigger.c:3687
void RelationBuildTriggers(Relation relation)
Definition trigger.c:1863
void AfterTriggerBeginSubXact(void)
Definition trigger.c:5430
static void AfterTriggerSaveEvent(EState *estate, ResultRelInfo *relinfo, ResultRelInfo *src_partinfo, ResultRelInfo *dst_partinfo, int event, bool row_trigger, TupleTableSlot *oldslot, TupleTableSlot *newslot, List *recheckIndexes, Bitmapset *modifiedCols, TransitionCaptureState *transition_capture, bool is_crosspart_update)
Definition trigger.c:6215
static HeapTuple check_modified_virtual_generated(TupleDesc tupdesc, HeapTuple tuple)
Definition trigger.c:6781
ObjectAddress CreateTrigger(const CreateTrigStmt *stmt, const char *queryString, Oid relOid, Oid refRelOid, Oid constraintOid, Oid indexOid, Oid funcoid, Oid parentTriggerOid, Node *whenClause, bool isInternal, bool in_partition)
Definition trigger.c:162
static TupleTableSlot * GetAfterTriggersStoreSlot(AfterTriggersTableData *table, TupleDesc tupdesc)
Definition trigger.c:4927
#define AFTER_TRIGGER_CP_UPDATE
Definition trigger.c:3691
void AfterTriggerEndQuery(EState *estate)
Definition trigger.c:5156
void RemoveTriggerById(Oid trigOid)
Definition trigger.c:1293
#define AFTER_TRIGGER_DONE
Definition trigger.c:3684
#define for_each_event_chunk(eptr, cptr, evtlist)
Definition trigger.c:3790
SetConstraintStateData * SetConstraintState
Definition trigger.c:3636
static void AfterTriggerEnlargeQueryState(void)
Definition trigger.c:5684
#define for_each_event(eptr, cptr)
Definition trigger.c:3785
struct AfterTriggerEventData * AfterTriggerEvent
Definition trigger.c:3706
#define for_each_chunk(cptr, evtlist)
Definition trigger.c:3783
void ExecBSUpdateTriggers(EState *estate, ResultRelInfo *relinfo)
Definition trigger.c:2897
void AfterTriggerBeginQuery(void)
Definition trigger.c:5136
#define AFTER_TRIGGER_DEFERRABLE
Definition trigger.h:109
uint32 TriggerEvent
Definition trigger.h:29
#define TRIGGER_FIRED_FOR_STATEMENT(event)
Definition trigger.h:127
#define TRIGGER_EVENT_UPDATE
Definition trigger.h:96
#define RI_TRIGGER_FK
Definition trigger.h:287
#define TRIGGER_FIRED_BY_DELETE(event)
Definition trigger.h:115
#define SESSION_REPLICATION_ROLE_REPLICA
Definition trigger.h:143
#define TRIGGER_EVENT_DELETE
Definition trigger.h:95
#define TRIGGER_FIRES_ON_ORIGIN
Definition trigger.h:151
#define TRIGGER_EVENT_OPMASK
Definition trigger.h:98
#define TRIGGER_DISABLED
Definition trigger.h:154
#define RI_TRIGGER_NONE
Definition trigger.h:288
#define TRIGGER_FIRES_ON_REPLICA
Definition trigger.h:153
#define AFTER_TRIGGER_INITDEFERRED
Definition trigger.h:110
#define TRIGGER_EVENT_INSTEAD
Definition trigger.h:104
#define TRIGGER_EVENT_ROW
Definition trigger.h:100
#define TRIGGER_FIRED_AFTER(event)
Definition trigger.h:133
#define TRIGGER_EVENT_BEFORE
Definition trigger.h:102
#define TRIGGER_FIRED_BY_INSERT(event)
Definition trigger.h:112
#define SESSION_REPLICATION_ROLE_ORIGIN
Definition trigger.h:142
void(* AfterTriggerBatchCallback)(void *arg)
Definition trigger.h:307
#define TRIGGER_EVENT_INSERT
Definition trigger.h:94
#define TRIGGER_FIRED_BY_UPDATE(event)
Definition trigger.h:118
#define TRIGGER_EVENT_TRUNCATE
Definition trigger.h:97
#define RI_TRIGGER_PK
Definition trigger.h:286
TupleTableSlot * execute_attr_map_slot(AttrMap *attrMap, TupleTableSlot *in_slot, TupleTableSlot *out_slot)
Definition tupconvert.c:193
TupleDesc CreateTupleDescCopy(TupleDesc tupdesc)
Definition tupdesc.c:242
static FormData_pg_attribute * TupleDescAttr(TupleDesc tupdesc, int i)
Definition tupdesc.h:178
bool tuplestore_gettupleslot(Tuplestorestate *state, bool forward, bool copy, TupleTableSlot *slot)
void tuplestore_puttupleslot(Tuplestorestate *state, TupleTableSlot *slot)
Definition tuplestore.c:743
Tuplestorestate * tuplestore_begin_heap(bool randomAccess, bool interXact, int maxKBytes)
Definition tuplestore.c:331
void tuplestore_end(Tuplestorestate *state)
Definition tuplestore.c:493
static TupleTableSlot * ExecClearTuple(TupleTableSlot *slot)
Definition tuptable.h:476
#define TupIsNull(slot)
Definition tuptable.h:325
static TupleTableSlot * ExecCopySlot(TupleTableSlot *dstslot, TupleTableSlot *srcslot)
Definition tuptable.h:543
static void ExecMaterializeSlot(TupleTableSlot *slot)
Definition tuptable.h:494
#define strVal(v)
Definition value.h:82
List * pull_var_clause(Node *node, int flags)
Definition var.c:653
static char * VARDATA_ANY(const void *PTR)
Definition varatt.h:486
const char * name
int GetCurrentTransactionNestLevel(void)
Definition xact.c:931
void CommandCounterIncrement(void)
Definition xact.c:1130
bool IsSubTransaction(void)
Definition xact.c:5095
#define IsolationUsesXactSnapshot()
Definition xact.h:52