44 #include "utils/fmgroids.h"
60 #define RI_MAX_NUMKEYS INDEX_MAX_KEYS
62 #define RI_INIT_CONSTRAINTHASHSIZE 64
63 #define RI_INIT_QUERYHASHSIZE (RI_INIT_CONSTRAINTHASHSIZE * 4)
65 #define RI_KEYS_ALL_NULL 0
66 #define RI_KEYS_SOME_NULL 1
67 #define RI_KEYS_NONE_NULL 2
71 #define RI_PLAN_CHECK_LOOKUPPK 1
72 #define RI_PLAN_CHECK_LOOKUPPK_FROM_PK 2
73 #define RI_PLAN_LAST_ON_PK RI_PLAN_CHECK_LOOKUPPK_FROM_PK
75 #define RI_PLAN_CASCADE_ONDELETE 3
76 #define RI_PLAN_CASCADE_ONUPDATE 4
78 #define RI_PLAN_RESTRICT 5
79 #define RI_PLAN_SETNULL_ONDELETE 6
80 #define RI_PLAN_SETNULL_ONUPDATE 7
81 #define RI_PLAN_SETDEFAULT_ONDELETE 8
82 #define RI_PLAN_SETDEFAULT_ONUPDATE 9
84 #define MAX_QUOTED_NAME_LEN (NAMEDATALEN*2+3)
85 #define MAX_QUOTED_REL_NAME_LEN (MAX_QUOTED_NAME_LEN*2)
87 #define RIAttName(rel, attnum) NameStr(*attnumAttName(rel, attnum))
88 #define RIAttType(rel, attnum) attnumTypeId(rel, attnum)
89 #define RIAttCollation(rel, attnum) attnumCollationId(rel, attnum)
91 #define RI_TRIGTYPE_INSERT 1
92 #define RI_TRIGTYPE_UPDATE 2
93 #define RI_TRIGTYPE_DELETE 3
199 const char *leftop,
Oid leftoptype,
201 const char *rightop,
Oid rightoptype);
207 int32 constr_queryno);
231 bool detectNewRows,
int expect_OK);
234 Datum *vals,
char *nulls);
310 (
errcode(ERRCODE_FOREIGN_KEY_VIOLATION),
311 errmsg(
"insert or update on table \"%s\" violates foreign key constraint \"%s\"",
314 errdetail(
"MATCH FULL does not allow mixing of null and nonnull key values."),
362 const char *querysep;
390 pk_only = pk_rel->
rd_rel->relkind == RELKIND_PARTITIONED_TABLE ?
399 "SELECT 1 FROM (SELECT %s AS r FROM %s%s x",
408 for (
int i = 0;
i < riinfo->
nkeys;
i++)
421 queryoids[
i] = fk_type;
433 "pg_catalog.range_agg", ANYMULTIRANGEOID);
439 &qkey, fk_rel, pk_rel);
452 pk_rel->
rd_rel->relkind == RELKIND_PARTITIONED_TABLE,
532 const char *querysep;
560 pk_only = pk_rel->
rd_rel->relkind == RELKIND_PARTITIONED_TABLE ?
568 "SELECT 1 FROM (SELECT %s AS r FROM %s%s x",
577 for (
int i = 0;
i < riinfo->
nkeys;
i++)
589 queryoids[
i] = pk_type;
601 "pg_catalog.range_agg", ANYMULTIRANGEOID);
607 &qkey, fk_rel, pk_rel);
756 const char *querysep;
769 fk_only = fk_rel->
rd_rel->relkind == RELKIND_PARTITIONED_TABLE ?
775 for (
int i = 0;
i < riinfo->
nkeys;
i++)
792 queryoids[
i] = pk_type;
798 &qkey, fk_rel, pk_rel);
862 const char *querysep;
874 fk_only = fk_rel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE ?
880 for (
int i = 0;
i < riinfo->nkeys;
i++)
892 riinfo->pf_eq_oprs[
i],
897 queryoids[
i] = pk_type;
902 &qkey, fk_rel, pk_rel);
971 const char *querysep;
988 fk_only = fk_rel->rd_rel->relkind == RELKIND_PARTITIONED_TABLE ?
995 for (
int i = 0,
j = riinfo->nkeys; i < riinfo->nkeys;
i++,
j++)
1010 riinfo->pf_eq_oprs[
i],
1016 queryoids[
i] = pk_type;
1017 queryoids[
j] = pk_type;
1023 &qkey, fk_rel, pk_rel);
1142 queryno = is_set_null
1147 queryno = is_set_null
1152 elog(
ERROR,
"invalid tgkind passed to ri_set");
1163 const char *querysep;
1164 const char *qualsep;
1166 const char *fk_only;
1167 int num_cols_to_set;
1168 const int16 *set_cols;
1173 num_cols_to_set = riinfo->
nkeys;
1190 num_cols_to_set = riinfo->
nkeys;
1195 elog(
ERROR,
"invalid tgkind passed to ri_set");
1207 fk_only = fk_rel->
rd_rel->relkind == RELKIND_PARTITIONED_TABLE ?
1211 fk_only, fkrelname);
1217 for (
int i = 0;
i < num_cols_to_set;
i++)
1223 is_set_null ?
"NULL" :
"DEFAULT");
1231 for (
int i = 0;
i < riinfo->
nkeys;
i++)
1249 queryoids[
i] = pk_type;
1254 &qkey, fk_rel, pk_rel);
1320 if (newslot &&
ri_KeysEqual(pk_rel, oldslot, newslot, riinfo,
true))
1347 Assert(fk_rel->
rd_rel->relkind != RELKIND_PARTITIONED_TABLE);
1413 if (
ri_KeysEqual(fk_rel, oldslot, newslot, riinfo,
false))
1452 const char *fk_only;
1453 const char *pk_only;
1455 char workmembuf[32];
1471 perminfos =
lappend(perminfos, pk_perminfo);
1475 rte->relkind = pk_rel->
rd_rel->relkind;
1483 perminfos =
lappend(perminfos, fk_perminfo);
1487 rte->relkind = fk_rel->
rd_rel->relkind;
1492 for (
int i = 0;
i < riinfo->
nkeys;
i++)
1512 ((pk_rel->
rd_rel->relrowsecurity &&
1515 (fk_rel->
rd_rel->relrowsecurity &&
1538 for (
int i = 0;
i < riinfo->
nkeys;
i++)
1548 fk_only = fk_rel->
rd_rel->relkind == RELKIND_PARTITIONED_TABLE ?
1550 pk_only = pk_rel->
rd_rel->relkind == RELKIND_PARTITIONED_TABLE ?
1553 " FROM %s%s fk LEFT OUTER JOIN %s%s pk ON",
1554 fk_only, fkrelname, pk_only, pkrelname);
1556 strcpy(pkattname,
"pk.");
1557 strcpy(fkattname,
"fk.");
1559 for (
int i = 0;
i < riinfo->
nkeys;
i++)
1573 fkattname, fk_type);
1574 if (pk_coll != fk_coll)
1587 for (
int i = 0;
i < riinfo->
nkeys;
i++)
1591 "%sfk.%s IS NOT NULL",
1638 elog(
ERROR,
"SPI_prepare returned %s for %s",
1682 for (
int i = 0;
i < fake_riinfo.
nkeys;
i++)
1693 (
errcode(ERRCODE_FOREIGN_KEY_VIOLATION),
1694 errmsg(
"insert or update on table \"%s\" violates foreign key constraint \"%s\"",
1697 errdetail(
"MATCH FULL does not allow mixing of null and nonnull key values."),
1736 char *constraintDef;
1742 const char *fk_only;
1744 char workmembuf[32];
1775 for (
i = 0;
i < riinfo->
nkeys;
i++)
1785 fk_only = fk_rel->
rd_rel->relkind == RELKIND_PARTITIONED_TABLE ?
1788 " FROM %s%s fk JOIN %s pk ON",
1789 fk_only, fkrelname, pkrelname);
1790 strcpy(pkattname,
"pk.");
1791 strcpy(fkattname,
"fk.");
1793 for (
i = 0;
i < riinfo->
nkeys;
i++)
1807 fkattname, fk_type);
1808 if (pk_coll != fk_coll)
1819 if (constraintDef && constraintDef[0] !=
'\0')
1826 for (
i = 0;
i < riinfo->
nkeys;
i++)
1830 "%sfk.%s IS NOT NULL",
1877 elog(
ERROR,
"SPI_prepare returned %s for %s",
1921 for (
i = 0;
i < fake_riinfo.
nkeys;
i++)
1925 slot, tupdesc, 0,
true);
1958 *buffer++ = *
name++;
1973 buffer += strlen(buffer);
1989 const char *leftop,
Oid leftoptype,
1991 const char *rightop,
Oid rightoptype)
1995 rightop, rightoptype);
2029 elog(
ERROR,
"cache lookup failed for collation %u", collation);
2031 collname =
NameStr(colltup->collname);
2058 int32 constr_queryno)
2082 key->constr_queryno = constr_queryno;
2095 (
errcode(ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED),
2096 errmsg(
"function \"%s\" was not called by trigger manager",
funcname)));
2104 (
errcode(ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED),
2112 (
errcode(ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED),
2118 (
errcode(ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED),
2124 (
errcode(ERRCODE_E_R_I_E_TRIGGER_PROTOCOL_VIOLATED),
2147 (
errcode(ERRCODE_INVALID_OBJECT_DEFINITION),
2148 errmsg(
"no pg_constraint entry for trigger \"%s\" on table \"%s\"",
2150 errhint(
"Remove this referential integrity trigger and its mates, then do ALTER TABLE ADD CONSTRAINT.")));
2160 elog(
ERROR,
"wrong pg_constraint entry for trigger \"%s\" on table \"%s\"",
2167 elog(
ERROR,
"wrong pg_constraint entry for trigger \"%s\" on table \"%s\"",
2174 elog(
ERROR,
"unrecognized confmatchtype: %d",
2179 (
errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
2180 errmsg(
"MATCH PARTIAL not yet implemented")));
2209 riinfo->
valid =
false;
2210 else if (riinfo->
valid)
2218 elog(
ERROR,
"cache lookup failed for constraint %u", constraintOid);
2221 if (conForm->contype != CONSTRAINT_FOREIGN)
2222 elog(
ERROR,
"constraint %u is not a foreign key constraint",
2237 riinfo->
pk_relid = conForm->confrelid;
2238 riinfo->
fk_relid = conForm->conrelid;
2276 riinfo->
valid =
true;
2291 Oid constrParentOid;
2295 elog(
ERROR,
"cache lookup failed for constraint %u", constrOid);
2300 constrOid = constrParentOid;
2338 valid_link, iter.
cur);
2345 if (hashvalue == 0 ||
2349 riinfo->
valid =
false;
2367 int save_sec_context;
2408 bool detectNewRows,
int expect_OK)
2418 int save_sec_context;
2440 source_rel = fk_rel;
2441 source_is_pk =
false;
2445 source_rel = pk_rel;
2446 source_is_pk =
true;
2456 vals + riinfo->
nkeys, nulls + riinfo->
nkeys);
2505 test_snapshot, crosscheck_snapshot,
2506 false,
false, limit);
2515 if (expect_OK >= 0 && spi_result != expect_OK)
2517 (
errcode(ERRCODE_INTERNAL_ERROR),
2518 errmsg(
"referential integrity query on \"%s\" from constraint \"%s\" on \"%s\" gave unexpected result",
2522 errhint(
"This is most likely due to a rule having rewritten the query.")));
2530 newslot ? newslot : oldslot,
2543 Datum *vals,
char *nulls)
2545 const int16 *attnums;
2553 for (
int i = 0;
i < riinfo->
nkeys;
i++)
2556 nulls[
i] = isnull ?
'n' :
' ';
2573 int queryno,
bool partgone)
2578 const int16 *attnums;
2581 bool has_perm =
true;
2591 rel_oid = fk_rel->
rd_id;
2592 if (tupdesc == NULL)
2593 tupdesc = fk_rel->
rd_att;
2598 rel_oid = pk_rel->
rd_id;
2599 if (tupdesc == NULL)
2600 tupdesc = pk_rel->
rd_att;
2649 int fnum = attnums[
idx];
2682 (
errcode(ERRCODE_FOREIGN_KEY_VIOLATION),
2683 errmsg(
"removing partition \"%s\" violates foreign key constraint \"%s\"",
2686 errdetail(
"Key (%s)=(%s) is still referenced from table \"%s\".",
2692 (
errcode(ERRCODE_FOREIGN_KEY_VIOLATION),
2693 errmsg(
"insert or update on table \"%s\" violates foreign key constraint \"%s\"",
2697 errdetail(
"Key (%s)=(%s) is not present in table \"%s\".",
2700 errdetail(
"Key is not present in table \"%s\".",
2705 (
errcode(ERRCODE_FOREIGN_KEY_VIOLATION),
2706 errmsg(
"update or delete on table \"%s\" violates foreign key constraint \"%s\" on table \"%s\"",
2711 errdetail(
"Key (%s)=(%s) is still referenced from table \"%s\".",
2714 errdetail(
"Key is still referenced from table \"%s\".",
2732 const int16 *attnums;
2733 bool allnull =
true;
2734 bool nonenull =
true;
2741 for (
int i = 0;
i < riinfo->
nkeys;
i++)
2769 ctl.keysize =
sizeof(
Oid);
2893 const int16 *attnums;
2901 for (
int i = 0;
i < riinfo->
nkeys;
i++)
2933 if (!
datum_image_eq(oldvalue, newvalue, att->attbyval, att->attlen))
2956 newvalue, oldvalue))
3012 DEFAULT_COLLATION_OID,
3039 key.eq_opr = eq_opr;
3040 key.typeid =
typeid;
3045 entry->
valid =
false;
3076 Assert(lefttype == righttype);
3077 if (
typeid == lefttype)
3094 elog(
ERROR,
"no conversion function from %s to %s",
3104 entry->
valid =
true;
3120 case F_RI_FKEY_CASCADE_DEL:
3121 case F_RI_FKEY_CASCADE_UPD:
3122 case F_RI_FKEY_RESTRICT_DEL:
3123 case F_RI_FKEY_RESTRICT_UPD:
3124 case F_RI_FKEY_SETNULL_DEL:
3125 case F_RI_FKEY_SETNULL_UPD:
3126 case F_RI_FKEY_SETDEFAULT_DEL:
3127 case F_RI_FKEY_SETDEFAULT_UPD:
3128 case F_RI_FKEY_NOACTION_DEL:
3129 case F_RI_FKEY_NOACTION_UPD:
3132 case F_RI_FKEY_CHECK_INS:
3133 case F_RI_FKEY_CHECK_UPD:
Datum idx(PG_FUNCTION_ARGS)
bool has_bypassrls_privilege(Oid roleid)
AclResult pg_attribute_aclcheck(Oid table_oid, AttrNumber attnum, Oid roleid, AclMode mode)
bool object_ownercheck(Oid classid, Oid objectid, Oid roleid)
AclResult pg_class_aclcheck(Oid table_oid, Oid roleid, AclMode mode)
Bitmapset * bms_add_member(Bitmapset *a, int x)
#define Assert(condition)
#define pg_attribute_noreturn()
#define OidIsValid(objectId)
bool datum_image_eq(Datum value1, Datum value2, bool typByVal, int typLen)
void * hash_search(HTAB *hashp, const void *keyPtr, HASHACTION action, bool *foundPtr)
HTAB * hash_create(const char *tabname, long nelem, const HASHCTL *info, int flags)
int errdetail(const char *fmt,...)
int errhint(const char *fmt,...)
int errcode(int sqlerrcode)
int errmsg(const char *fmt,...)
#define ereport(elevel,...)
bool ExecCheckPermissions(List *rangeTable, List *rteperminfos, bool ereport_on_violation)
const TupleTableSlotOps TTSOpsVirtual
TupleTableSlot * ExecStoreVirtualTuple(TupleTableSlot *slot)
void ExecDropSingleTupleTableSlot(TupleTableSlot *slot)
TupleTableSlot * MakeSingleTupleTableSlot(TupleDesc tupdesc, const TupleTableSlotOps *tts_ops)
Datum FunctionCall2Coll(FmgrInfo *flinfo, Oid collation, Datum arg1, Datum arg2)
void fmgr_info_cxt(Oid functionId, FmgrInfo *finfo, MemoryContext mcxt)
char * OidOutputFunctionCall(Oid functionId, Datum val)
#define FunctionCall3(flinfo, arg1, arg2, arg3)
int NewGUCNestLevel(void)
void AtEOXact_GUC(bool isCommit, int nestLevel)
int set_config_option(const char *name, const char *value, GucContext context, GucSource source, GucAction action, bool changeVal, int elevel, bool is_reload)
void heap_deform_tuple(HeapTuple tuple, TupleDesc tupleDesc, Datum *values, bool *isnull)
#define HeapTupleIsValid(tuple)
#define dclist_container(type, membername, ptr)
static void dclist_push_tail(dclist_head *head, dlist_node *node)
static uint32 dclist_count(const dclist_head *head)
static void dclist_delete_from(dclist_head *head, dlist_node *node)
#define dclist_foreach_modify(iter, lhead)
void CacheRegisterSyscacheCallback(int cacheid, SyscacheCallbackFunction func, Datum arg)
if(TABLE==NULL||TABLE_index==NULL)
List * lappend(List *list, void *datum)
char * get_namespace_name(Oid nspid)
void getTypeOutputInfo(Oid type, Oid *typOutput, bool *typIsVarlena)
RegProcedure get_opcode(Oid opno)
Oid get_index_column_opclass(Oid index_oid, int attno)
bool get_collation_isdeterministic(Oid colloid)
void op_input_types(Oid opno, Oid *lefttype, Oid *righttype)
MemoryContext TopMemoryContext
#define SECURITY_NOFORCE_RLS
#define SECURITY_LOCAL_USERID_CHANGE
void GetUserIdAndSecContext(Oid *userid, int *sec_context)
void SetUserIdAndSecContext(Oid userid, int sec_context)
CoercionPathType find_coercion_pathway(Oid targetTypeId, Oid sourceTypeId, CoercionContext ccontext, Oid *funcid)
bool IsBinaryCoercible(Oid srctype, Oid targettype)
@ COERCION_PATH_RELABELTYPE
#define FKCONSTR_MATCH_SIMPLE
#define FKCONSTR_MATCH_PARTIAL
#define FKCONSTR_MATCH_FULL
FormData_pg_attribute * Form_pg_attribute
FormData_pg_collation * Form_pg_collation
void DeconstructFkConstraintRow(HeapTuple tuple, int *numfks, AttrNumber *conkey, AttrNumber *confkey, Oid *pf_eq_oprs, Oid *pp_eq_oprs, Oid *ff_eq_oprs, int *num_fk_del_set_cols, AttrNumber *fk_del_set_cols)
void FindFKPeriodOpers(Oid opclass, Oid *containedbyoperoid, Oid *aggedcontainedbyoperoid)
FormData_pg_constraint * Form_pg_constraint
static int list_length(const List *l)
static bool DatumGetBool(Datum X)
static Datum PointerGetDatum(const void *X)
static Datum BoolGetDatum(bool X)
static Datum ObjectIdGetDatum(Oid X)
static Datum Int32GetDatum(int32 X)
#define RelationGetForm(relation)
#define RelationGetRelid(relation)
#define RelationGetDescr(relation)
#define RelationGetRelationName(relation)
#define RelationGetNamespace(relation)
int errtableconstraint(Relation rel, const char *conname)
static bool ri_CompareWithCast(Oid eq_opr, Oid typeid, Datum lhs, Datum rhs)
static Datum ri_set(TriggerData *trigdata, bool is_set_null, int tgkind)
#define RI_TRIGTYPE_INSERT
struct RI_ConstraintInfo RI_ConstraintInfo
static const RI_ConstraintInfo * ri_LoadConstraintInfo(Oid constraintOid)
static Datum RI_FKey_check(TriggerData *trigdata)
#define RI_PLAN_SETNULL_ONUPDATE
#define RI_PLAN_CASCADE_ONUPDATE
#define RI_TRIGTYPE_DELETE
Datum RI_FKey_setnull_del(PG_FUNCTION_ARGS)
static bool ri_PerformCheck(const RI_ConstraintInfo *riinfo, RI_QueryKey *qkey, SPIPlanPtr qplan, Relation fk_rel, Relation pk_rel, TupleTableSlot *oldslot, TupleTableSlot *newslot, bool detectNewRows, int expect_OK)
static void ri_HashPreparedPlan(RI_QueryKey *key, SPIPlanPtr plan)
static void quoteOneName(char *buffer, const char *name)
bool RI_FKey_pk_upd_check_required(Trigger *trigger, Relation pk_rel, TupleTableSlot *oldslot, TupleTableSlot *newslot)
#define RI_PLAN_LAST_ON_PK
#define RIAttType(rel, attnum)
static void ri_GenerateQualCollation(StringInfo buf, Oid collation)
Datum RI_FKey_cascade_del(PG_FUNCTION_ARGS)
#define RI_KEYS_SOME_NULL
Datum RI_FKey_check_upd(PG_FUNCTION_ARGS)
static HTAB * ri_query_cache
#define MAX_QUOTED_REL_NAME_LEN
static void ri_ReportViolation(const RI_ConstraintInfo *riinfo, Relation pk_rel, Relation fk_rel, TupleTableSlot *violatorslot, TupleDesc tupdesc, int queryno, bool partgone) pg_attribute_noreturn()
Datum RI_FKey_restrict_upd(PG_FUNCTION_ARGS)
static void InvalidateConstraintCacheCallBack(Datum arg, int cacheid, uint32 hashvalue)
static Datum ri_restrict(TriggerData *trigdata, bool is_no_action)
Datum RI_FKey_restrict_del(PG_FUNCTION_ARGS)
Datum RI_FKey_noaction_del(PG_FUNCTION_ARGS)
static void quoteRelationName(char *buffer, Relation rel)
static int ri_NullCheck(TupleDesc tupDesc, TupleTableSlot *slot, const RI_ConstraintInfo *riinfo, bool rel_is_pk)
static void ri_GenerateQual(StringInfo buf, const char *sep, const char *leftop, Oid leftoptype, Oid opoid, const char *rightop, Oid rightoptype)
struct RI_QueryKey RI_QueryKey
static bool ri_KeysEqual(Relation rel, TupleTableSlot *oldslot, TupleTableSlot *newslot, const RI_ConstraintInfo *riinfo, bool rel_is_pk)
struct RI_CompareHashEntry RI_CompareHashEntry
static RI_CompareHashEntry * ri_HashCompareOp(Oid eq_opr, Oid typeid)
#define RI_PLAN_CHECK_LOOKUPPK_FROM_PK
#define RIAttCollation(rel, attnum)
static dclist_head ri_constraint_cache_valid_list
static Oid get_ri_constraint_root(Oid constrOid)
Datum RI_FKey_check_ins(PG_FUNCTION_ARGS)
struct RI_QueryHashEntry RI_QueryHashEntry
static HTAB * ri_compare_cache
#define RI_KEYS_NONE_NULL
#define RI_INIT_QUERYHASHSIZE
static const RI_ConstraintInfo * ri_FetchConstraintInfo(Trigger *trigger, Relation trig_rel, bool rel_is_pk)
static void ri_BuildQueryKey(RI_QueryKey *key, const RI_ConstraintInfo *riinfo, int32 constr_queryno)
#define RI_PLAN_CASCADE_ONDELETE
Datum RI_FKey_setnull_upd(PG_FUNCTION_ARGS)
#define RI_PLAN_SETDEFAULT_ONDELETE
Datum RI_FKey_setdefault_del(PG_FUNCTION_ARGS)
#define RI_PLAN_SETDEFAULT_ONUPDATE
#define RI_PLAN_CHECK_LOOKUPPK
#define RI_PLAN_SETNULL_ONDELETE
#define RI_INIT_CONSTRAINTHASHSIZE
bool RI_Initial_Check(Trigger *trigger, Relation fk_rel, Relation pk_rel)
static bool ri_Check_Pk_Match(Relation pk_rel, Relation fk_rel, TupleTableSlot *oldslot, const RI_ConstraintInfo *riinfo)
void RI_PartitionRemove_Check(Trigger *trigger, Relation fk_rel, Relation pk_rel)
static SPIPlanPtr ri_PlanCheck(const char *querystr, int nargs, Oid *argtypes, RI_QueryKey *qkey, Relation fk_rel, Relation pk_rel)
#define MAX_QUOTED_NAME_LEN
static void ri_CheckTrigger(FunctionCallInfo fcinfo, const char *funcname, int tgkind)
#define RI_TRIGTYPE_UPDATE
bool RI_FKey_fk_upd_check_required(Trigger *trigger, Relation fk_rel, TupleTableSlot *oldslot, TupleTableSlot *newslot)
int RI_FKey_trigger_type(Oid tgfoid)
Datum RI_FKey_cascade_upd(PG_FUNCTION_ARGS)
Datum RI_FKey_noaction_upd(PG_FUNCTION_ARGS)
static void ri_InitHashTables(void)
static void ri_ExtractValues(Relation rel, TupleTableSlot *slot, const RI_ConstraintInfo *riinfo, bool rel_is_pk, Datum *vals, char *nulls)
#define RIAttName(rel, attnum)
static HTAB * ri_constraint_cache
static SPIPlanPtr ri_FetchPreparedPlan(RI_QueryKey *key)
struct RI_CompareKey RI_CompareKey
Datum RI_FKey_setdefault_upd(PG_FUNCTION_ARGS)
int check_enable_rls(Oid relid, Oid checkAsUser, bool noError)
char * pg_get_partconstrdef_string(Oid partitionId, char *aliasname)
void generate_operator_clause(StringInfo buf, const char *leftop, Oid leftoptype, Oid opoid, const char *rightop, Oid rightoptype)
Snapshot GetTransactionSnapshot(void)
Snapshot GetLatestSnapshot(void)
bool SPI_plan_is_valid(SPIPlanPtr plan)
int SPI_freeplan(SPIPlanPtr plan)
SPITupleTable * SPI_tuptable
int SPI_execute_snapshot(SPIPlanPtr plan, Datum *Values, const char *Nulls, Snapshot snapshot, Snapshot crosscheck_snapshot, bool read_only, bool fire_triggers, long tcount)
const char * SPI_result_code_string(int code)
SPIPlanPtr SPI_prepare(const char *src, int nargs, Oid *argtypes)
int SPI_keepplan(SPIPlanPtr plan)
void appendStringInfo(StringInfo str, const char *fmt,...)
void appendBinaryStringInfo(StringInfo str, const void *data, int datalen)
void appendStringInfoString(StringInfo str, const char *s)
void appendStringInfoChar(StringInfo str, char ch)
void initStringInfo(StringInfo str)
int16 pk_attnums[RI_MAX_NUMKEYS]
Oid agged_period_contained_by_oper
int16 fk_attnums[RI_MAX_NUMKEYS]
Oid pp_eq_oprs[RI_MAX_NUMKEYS]
Oid pf_eq_oprs[RI_MAX_NUMKEYS]
Oid period_contained_by_oper
int16 confdelsetcols[RI_MAX_NUMKEYS]
Oid ff_eq_oprs[RI_MAX_NUMKEYS]
TupleTableSlot * tg_trigslot
TupleTableSlot * tg_newslot
TupleDesc tts_tupleDescriptor
#define FirstLowInvalidHeapAttributeNumber
void ReleaseSysCache(HeapTuple tuple)
HeapTuple SearchSysCache1(int cacheId, Datum key1)
#define GetSysCacheHashValue1(cacheId, key1)
void table_close(Relation relation, LOCKMODE lockmode)
Relation table_open(Oid relationId, LOCKMODE lockmode)
static bool table_tuple_satisfies_snapshot(Relation rel, TupleTableSlot *slot, Snapshot snapshot)
#define TRIGGER_FIRED_BY_DELETE(event)
#define CALLED_AS_TRIGGER(fcinfo)
#define TRIGGER_FIRED_FOR_ROW(event)
#define TRIGGER_FIRED_AFTER(event)
#define TRIGGER_FIRED_BY_INSERT(event)
#define TRIGGER_FIRED_BY_UPDATE(event)
#define TupleDescAttr(tupdesc, i)
static Datum slot_getattr(TupleTableSlot *slot, int attnum, bool *isnull)
static bool slot_is_current_xact_tuple(TupleTableSlot *slot)
static bool slot_attisnull(TupleTableSlot *slot, int attnum)
void CommandCounterIncrement(void)
#define IsolationUsesXactSnapshot()