pg_constraint.h File Reference

#include "catalog/dependency.h"
#include "catalog/genbki.h"
#include "catalog/pg_constraint_d.h"
#include "nodes/pg_list.h"

Include dependency graph for pg_constraint.h:

This graph shows which files directly or indirectly include this file:

Go to the source code of this file.

Typedefs
typedef enum ConstraintCategory	ConstraintCategory

Enumerations
enum	ConstraintCategory { CONSTRAINT_RELATION , CONSTRAINT_DOMAIN , CONSTRAINT_ASSERTION }

Functions
BEGIN_CATALOG_STRUCT	CATALOG (pg_constraint, 2606, ConstraintRelationId)
	DECLARE_TOAST (pg_constraint, 2832, 2833)
	DECLARE_INDEX (pg_constraint_conname_nsp_index, 2664, ConstraintNameNspIndexId, pg_constraint, btree(conname name_ops, connamespace oid_ops))
	DECLARE_UNIQUE_INDEX (pg_constraint_conrelid_contypid_conname_index, 2665, ConstraintRelidTypidNameIndexId, pg_constraint, btree(conrelid oid_ops, contypid oid_ops, conname name_ops))
	DECLARE_INDEX (pg_constraint_contypid_index, 2666, ConstraintTypidIndexId, pg_constraint, btree(contypid oid_ops))
	DECLARE_UNIQUE_INDEX_PKEY (pg_constraint_oid_index, 2667, ConstraintOidIndexId, pg_constraint, btree(oid oid_ops))
	DECLARE_INDEX (pg_constraint_conparentid_index, 2579, ConstraintParentIndexId, pg_constraint, btree(conparentid oid_ops))
	MAKE_SYSCACHE (CONSTROID, pg_constraint_oid_index, 16)
	DECLARE_ARRAY_FOREIGN_KEY_OPT ((conrelid, conkey), pg_attribute,(attrelid, attnum))
	DECLARE_ARRAY_FOREIGN_KEY ((confrelid, confkey), pg_attribute,(attrelid, attnum))
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)
bool	ConstraintNameIsUsed (ConstraintCategory conCat, Oid objId, const char *conname)
bool	ConstraintNameExists (const char *conname, Oid namespaceid)
char *	ChooseConstraintName (const char *name1, const char *name2, const char *label, Oid namespaceid, List *others)
HeapTuple	findNotNullConstraintAttnum (Oid relid, AttrNumber attnum)
HeapTuple	findNotNullConstraint (Oid relid, const char *colname)
HeapTuple	findDomainNotNullConstraint (Oid typid)
AttrNumber	extractNotNullColumn (HeapTuple constrTup)
bool	AdjustNotNullInheritance (Oid relid, AttrNumber attnum, const char *new_conname, bool is_local, bool is_no_inherit, bool is_notvalid)
List *	RelationGetNotNullConstraints (Oid relid, bool cooked, bool include_noinh)
void	RemoveConstraintById (Oid conId)
void	RenameConstraintById (Oid conId, const char *newname)
void	AlterConstraintNamespaces (Oid ownerId, Oid oldNspId, Oid newNspId, bool isType, ObjectAddresses *objsMoved)
void	ConstraintSetParentConstraint (Oid childConstrId, Oid parentConstrId, Oid childTableId)
Oid	get_relation_constraint_oid (Oid relid, const char *conname, bool missing_ok)
Bitmapset *	get_relation_constraint_attnos (Oid relid, const char *conname, bool missing_ok, Oid *constraintOid)
Oid	get_domain_constraint_oid (Oid typid, const char *conname, bool missing_ok)
Oid	get_relation_idx_constraint_oid (Oid relationId, Oid indexId)
Bitmapset *	get_primary_key_attnos (Oid relid, bool deferrableOk, Oid *constraintOid)
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, Oid *intersectoperoid)
bool	check_functional_grouping (Oid relid, Index varno, Index varlevelsup, List *grouping_columns, List **constraintDeps)

Variables
END_CATALOG_STRUCT typedef FormData_pg_constraint *	Form_pg_constraint
	FormData_pg_constraint

Typedef Documentation

ConstraintCategory

typedef enum ConstraintCategory ConstraintCategory

Enumeration Type Documentation

ConstraintCategory

enum ConstraintCategory

Enumerator
CONSTRAINT_RELATION
CONSTRAINT_DOMAIN
CONSTRAINT_ASSERTION

Definition at line 217 of file pg_constraint.h.

{
    CONSTRAINT_RELATION,
    CONSTRAINT_DOMAIN,
    CONSTRAINT_ASSERTION,       /* for future expansion */
} ConstraintCategory;

Function Documentation

AdjustNotNullInheritance()

bool AdjustNotNullInheritance ( Oid  relid, AttrNumber  attnum, const char *  new_conname, bool  is_local, bool  is_no_inherit, bool  is_notvalid  )

extern

Definition at line 742 of file pg_constraint.c.

{
    HeapTuple   tup;
 
    tup = findNotNullConstraintAttnum(relid, attnum);
    if (HeapTupleIsValid(tup))
    {
        Relation    pg_constraint;
        Form_pg_constraint conform;
        bool        changed = false;
 
        pg_constraint = table_open(ConstraintRelationId, RowExclusiveLock);
        conform = (Form_pg_constraint) GETSTRUCT(tup);
 
        /*
         * If the NO INHERIT flag we're asked for doesn't match what the
         * existing constraint has, throw an error.
         */
        if (is_no_inherit != conform->connoinherit)
            ereport(ERROR,
                    errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
                    errmsg("cannot change NO INHERIT status of NOT NULL constraint \"%s\" on relation \"%s\"",
                           NameStr(conform->conname), get_rel_name(relid)),
                    errhint("You might need to make the existing constraint inheritable using %s.",
                            "ALTER TABLE ... ALTER CONSTRAINT ... INHERIT"));
 
        /*
         * Throw an error if the existing constraint is NOT VALID and caller
         * wants a valid one.
         */
        if (!is_notvalid && !conform->convalidated)
            ereport(ERROR,
                    errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
                    errmsg("incompatible NOT VALID constraint \"%s\" on relation \"%s\"",
                           NameStr(conform->conname), get_rel_name(relid)),
                    errhint("You might need to validate it using %s.",
                            "ALTER TABLE ... VALIDATE CONSTRAINT"));
 
        /*
         * If, for a new constraint that is being defined locally (i.e., not
         * being passed down via inheritance), a name was specified, then
         * verify that the existing constraint has the same name.  Otherwise
         * throw an error.  Names of inherited constraints are ignored because
         * they are not directly user-specified, so matching is not important.
         */
        if (is_local && new_conname &&
            strcmp(new_conname, NameStr(conform->conname)) != 0)
            ereport(ERROR,
                    errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
                    errmsg("cannot create not-null constraint \"%s\" on column \"%s\" of table \"%s\"",
                           new_conname, get_attname(relid, attnum, false), get_rel_name(relid)),
                    errdetail("A not-null constraint named \"%s\" already exists for this column.",
                              NameStr(conform->conname)));
 
        if (!is_local)
        {
            if (pg_add_s16_overflow(conform->coninhcount, 1,
                                    &conform->coninhcount))
                ereport(ERROR,
                        errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
                        errmsg("too many inheritance parents"));
            changed = true;
        }
        else if (!conform->conislocal)
        {
            conform->conislocal = true;
            changed = true;
        }
 
        if (changed)
            CatalogTupleUpdate(pg_constraint, &tup->t_self, tup);
 
        table_close(pg_constraint, RowExclusiveLock);
 
        return true;
    }
 
    return false;
}

References attnum, CatalogTupleUpdate(), ereport, errcode(), errdetail(), errhint(), errmsg, ERROR, fb(), findNotNullConstraintAttnum(), Form_pg_constraint, get_attname(), get_rel_name(), GETSTRUCT(), HeapTupleIsValid, NameStr, pg_add_s16_overflow(), RowExclusiveLock, table_close(), and table_open().

Referenced by AddRelationNewConstraints().

AlterConstraintNamespaces()

void AlterConstraintNamespaces ( Oid  ownerId, Oid  oldNspId, Oid  newNspId, bool  isType, ObjectAddresses *  objsMoved  )

extern

Definition at line 1057 of file pg_constraint.c.

{
    Relation    conRel;
    ScanKeyData key[2];
    SysScanDesc scan;
    HeapTuple   tup;
 
    conRel = table_open(ConstraintRelationId, RowExclusiveLock);
 
    ScanKeyInit(&key[0],
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(isType ? InvalidOid : ownerId));
    ScanKeyInit(&key[1],
                Anum_pg_constraint_contypid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(isType ? ownerId : InvalidOid));
 
    scan = systable_beginscan(conRel, ConstraintRelidTypidNameIndexId, true,
                              NULL, 2, key);
 
    while (HeapTupleIsValid((tup = systable_getnext(scan))))
    {
        Form_pg_constraint conform = (Form_pg_constraint) GETSTRUCT(tup);
        ObjectAddress thisobj;
 
        ObjectAddressSet(thisobj, ConstraintRelationId, conform->oid);
 
        if (object_address_present(&thisobj, objsMoved))
            continue;
 
        /* Don't update if the object is already part of the namespace */
        if (conform->connamespace == oldNspId && oldNspId != newNspId)
        {
            tup = heap_copytuple(tup);
            conform = (Form_pg_constraint) GETSTRUCT(tup);
 
            conform->connamespace = newNspId;
 
            CatalogTupleUpdate(conRel, &tup->t_self, tup);
 
            /*
             * Note: currently, the constraint will not have its own
             * dependency on the namespace, so we don't need to do
             * changeDependencyFor().
             */
        }
 
        InvokeObjectPostAlterHook(ConstraintRelationId, thisobj.objectId, 0);
 
        add_exact_object_address(&thisobj, objsMoved);
    }
 
    systable_endscan(scan);
 
    table_close(conRel, RowExclusiveLock);
}

References add_exact_object_address(), BTEqualStrategyNumber, CatalogTupleUpdate(), fb(), Form_pg_constraint, GETSTRUCT(), heap_copytuple(), HeapTupleIsValid, InvalidOid, InvokeObjectPostAlterHook, object_address_present(), ObjectAddressSet, ObjectIdGetDatum(), RowExclusiveLock, ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by AlterTableNamespaceInternal(), and AlterTypeNamespaceInternal().

CATALOG()

BEGIN_CATALOG_STRUCT CATALOG	(	pg_constraint	,
		2606	,
		ConstraintRelationId
	)

Definition at line 33 of file pg_constraint.h.

{
    Oid         oid;            /* oid */
 
    /*
     * conname + connamespace is deliberately not unique; we allow, for
     * example, the same name to be used for constraints of different
     * relations.  This is partly for backwards compatibility with past
     * Postgres practice, and partly because we don't want to have to obtain a
     * global lock to generate a globally unique name for a nameless
     * constraint.  We associate a namespace with constraint names only for
     * SQL-spec compatibility.
     *
     * However, we do require conname to be unique among the constraints of a
     * single relation or domain.  This is enforced by a unique index on
     * conrelid + contypid + conname.
     */
    NameData    conname;        /* name of this constraint */
    Oid         connamespace BKI_LOOKUP(pg_namespace);  /* OID of namespace
                                                         * containing constraint */
    char        contype;        /* constraint type; see codes below */
    bool        condeferrable;  /* deferrable constraint? */
    bool        condeferred;    /* deferred by default? */
    bool        conenforced;    /* enforced constraint? */
    bool        convalidated;   /* constraint has been validated? */
 
    /*
     * conrelid and conkey are only meaningful if the constraint applies to a
     * specific relation (this excludes domain constraints and assertions).
     * Otherwise conrelid is 0 and conkey is NULL.
     */
    Oid         conrelid BKI_LOOKUP_OPT(pg_class);  /* relation this
                                                     * constraint constrains */
 
    /*
     * contypid links to the pg_type row for a domain if this is a domain
     * constraint.  Otherwise it's 0.
     *
     * For SQL-style global ASSERTIONs, both conrelid and contypid would be
     * zero. This is not presently supported, however.
     */
    Oid         contypid BKI_LOOKUP_OPT(pg_type);   /* domain this constraint
                                                     * constrains */
 
    /*
     * conindid links to the index supporting the constraint, if any;
     * otherwise it's 0.  This is used for unique, primary-key, and exclusion
     * constraints, and less obviously for foreign-key constraints (where the
     * index is a unique index on the referenced relation's referenced
     * columns).  Notice that the index is on conrelid in the first case but
     * confrelid in the second.
     */
    Oid         conindid BKI_LOOKUP_OPT(pg_class);  /* index supporting this
                                                     * constraint */
 
    /*
     * If this constraint is on a partition inherited from a partitioned
     * table, this is the OID of the corresponding constraint in the parent.
     */
    Oid         conparentid BKI_LOOKUP_OPT(pg_constraint);
 
    /*
     * These fields, plus confkey, are only meaningful for a foreign-key
     * constraint.  Otherwise confrelid is 0 and the char fields are spaces.
     */
    Oid         confrelid BKI_LOOKUP_OPT(pg_class); /* relation referenced by
                                                     * foreign key */
    char        confupdtype;    /* foreign key's ON UPDATE action */
    char        confdeltype;    /* foreign key's ON DELETE action */
    char        confmatchtype;  /* foreign key's match type */
 
    /* Has a local definition (hence, do not drop when coninhcount is 0) */
    bool        conislocal;
 
    /* Number of times inherited from direct parent relation(s) */
    int16       coninhcount;
 
    /* Has a local definition and cannot be inherited */
    bool        connoinherit;
 
    /*
     * For primary keys, unique constraints, and foreign keys, signifies the
     * last column uses overlaps instead of equals.
     */
    bool        conperiod;
 
#ifdef CATALOG_VARLEN           /* variable-length fields start here */
 
    /*
     * Columns of conrelid that the constraint applies to, if known (this is
     * NULL for trigger constraints)
     */
    int16       conkey[1];
 
    /*
     * If a foreign key, the referenced columns of confrelid
     */
    int16       confkey[1];
 
    /*
     * If a foreign key, the OIDs of the PK = FK equality/overlap operators
     * for each column of the constraint
     */
    Oid         conpfeqop[1] BKI_LOOKUP(pg_operator);
 
    /*
     * If a foreign key, the OIDs of the PK = PK equality/overlap operators
     * for each column of the constraint (i.e., equality for the referenced
     * columns)
     */
    Oid         conppeqop[1] BKI_LOOKUP(pg_operator);
 
    /*
     * If a foreign key, the OIDs of the FK = FK equality/overlap operators
     * for each column of the constraint (i.e., equality for the referencing
     * columns)
     */
    Oid         conffeqop[1] BKI_LOOKUP(pg_operator);
 
    /*
     * If a foreign key with an ON DELETE SET NULL/DEFAULT action, the subset
     * of conkey to updated.  If null, all columns are updated.
     */
    int16       confdelsetcols[1];
 
    /*
     * If an exclusion constraint, the OIDs of the exclusion operators for
     * each column of the constraint.  Also set for unique constraints/primary
     * keys using WITHOUT OVERLAPS.
     */
    Oid         conexclop[1] BKI_LOOKUP(pg_operator);
 
    /*
     * If a check constraint, nodeToString representation of expression
     */
    pg_node_tree conbin;
#endif
} FormData_pg_constraint;

References BKI_LOOKUP, BKI_LOOKUP_OPT, and fb().

check_functional_grouping()

bool check_functional_grouping ( Oid  relid, Index  varno, Index  varlevelsup, List *  grouping_columns, List **  constraintDeps  )

extern

Definition at line 1742 of file pg_constraint.c.

{
    Bitmapset  *pkattnos;
    Bitmapset  *groupbyattnos;
    Oid         constraintOid;
    ListCell   *gl;
 
    /* If the rel has no PK, then we can't prove functional dependency */
    pkattnos = get_primary_key_attnos(relid, false, &constraintOid);
    if (pkattnos == NULL)
        return false;
 
    /* Identify all the rel's columns that appear in grouping_columns */
    groupbyattnos = NULL;
    foreach(gl, grouping_columns)
    {
        Var        *gvar = (Var *) lfirst(gl);
 
        if (IsA(gvar, Var) &&
            gvar->varno == varno &&
            gvar->varlevelsup == varlevelsup)
            groupbyattnos = bms_add_member(groupbyattnos,
                                           gvar->varattno - FirstLowInvalidHeapAttributeNumber);
    }
 
    if (bms_is_subset(pkattnos, groupbyattnos))
    {
        /* The PK is a subset of grouping_columns, so we win */
        *constraintDeps = lappend_oid(*constraintDeps, constraintOid);
        return true;
    }
 
    return false;
}

References bms_add_member(), bms_is_subset(), fb(), FirstLowInvalidHeapAttributeNumber, get_primary_key_attnos(), IsA, lappend_oid(), and lfirst.

Referenced by init_grouping_targets(), and substitute_grouped_columns_mutator().

ChooseConstraintName()

char * ChooseConstraintName ( const char *  name1, const char *  name2, const char *  label, Oid  namespaceid, List *  others  )

extern

Definition at line 513 of file pg_constraint.c.

{
    int         pass = 0;
    char       *conname = NULL;
    char        modlabel[NAMEDATALEN];
    Relation    conDesc;
    SysScanDesc conscan;
    ScanKeyData skey[2];
    bool        found;
    ListCell   *l;
 
    conDesc = table_open(ConstraintRelationId, AccessShareLock);
 
    /* try the unmodified label first, unless it's empty */
    if (label[0] != '\0')
        strlcpy(modlabel, label, sizeof(modlabel));
    else
        snprintf(modlabel, sizeof(modlabel), "%s%d", label, ++pass);
 
    for (;;)
    {
        conname = makeObjectName(name1, name2, modlabel);
 
        found = false;
 
        foreach(l, others)
        {
            if (strcmp((char *) lfirst(l), conname) == 0)
            {
                found = true;
                break;
            }
        }
 
        if (!found)
        {
            ScanKeyInit(&skey[0],
                        Anum_pg_constraint_conname,
                        BTEqualStrategyNumber, F_NAMEEQ,
                        CStringGetDatum(conname));
 
            ScanKeyInit(&skey[1],
                        Anum_pg_constraint_connamespace,
                        BTEqualStrategyNumber, F_OIDEQ,
                        ObjectIdGetDatum(namespaceid));
 
            conscan = systable_beginscan(conDesc, ConstraintNameNspIndexId, true,
                                         NULL, 2, skey);
 
            found = (HeapTupleIsValid(systable_getnext(conscan)));
 
            systable_endscan(conscan);
        }
 
        if (!found)
            break;
 
        /* found a conflict, so try a new name component */
        pfree(conname);
        snprintf(modlabel, sizeof(modlabel), "%s%d", label, ++pass);
    }
 
    table_close(conDesc, AccessShareLock);
 
    return conname;
}

References AccessShareLock, BTEqualStrategyNumber, CStringGetDatum(), fb(), HeapTupleIsValid, label, lfirst, makeObjectName(), NAMEDATALEN, ObjectIdGetDatum(), pfree(), ScanKeyInit(), snprintf, strlcpy(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by addFkConstraint(), AddRelationNewConstraints(), AddRelationNotNullConstraints(), ATExecAddConstraint(), ATExecSetNotNull(), domainAddCheckConstraint(), and domainAddNotNullConstraint().

ConstraintNameExists()

bool ConstraintNameExists ( const char *  conname, Oid  namespaceid  )

extern

Definition at line 457 of file pg_constraint.c.

{
    bool        found;
    Relation    conDesc;
    SysScanDesc conscan;
    ScanKeyData skey[2];
 
    conDesc = table_open(ConstraintRelationId, AccessShareLock);
 
    ScanKeyInit(&skey[0],
                Anum_pg_constraint_conname,
                BTEqualStrategyNumber, F_NAMEEQ,
                CStringGetDatum(conname));
 
    ScanKeyInit(&skey[1],
                Anum_pg_constraint_connamespace,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(namespaceid));
 
    conscan = systable_beginscan(conDesc, ConstraintNameNspIndexId, true,
                                 NULL, 2, skey);
 
    found = (HeapTupleIsValid(systable_getnext(conscan)));
 
    systable_endscan(conscan);
    table_close(conDesc, AccessShareLock);
 
    return found;
}

References AccessShareLock, BTEqualStrategyNumber, CStringGetDatum(), fb(), HeapTupleIsValid, ObjectIdGetDatum(), ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by ChooseRelationName().

ConstraintNameIsUsed()

bool ConstraintNameIsUsed ( ConstraintCategory  conCat, Oid  objId, const char *  conname  )

extern

Definition at line 412 of file pg_constraint.c.

{
    bool        found;
    Relation    conDesc;
    SysScanDesc conscan;
    ScanKeyData skey[3];
 
    conDesc = table_open(ConstraintRelationId, AccessShareLock);
 
    ScanKeyInit(&skey[0],
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum((conCat == CONSTRAINT_RELATION)
                                 ? objId : InvalidOid));
    ScanKeyInit(&skey[1],
                Anum_pg_constraint_contypid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum((conCat == CONSTRAINT_DOMAIN)
                                 ? objId : InvalidOid));
    ScanKeyInit(&skey[2],
                Anum_pg_constraint_conname,
                BTEqualStrategyNumber, F_NAMEEQ,
                CStringGetDatum(conname));
 
    conscan = systable_beginscan(conDesc, ConstraintRelidTypidNameIndexId,
                                 true, NULL, 3, skey);
 
    /* There can be at most one matching row */
    found = (HeapTupleIsValid(systable_getnext(conscan)));
 
    systable_endscan(conscan);
    table_close(conDesc, AccessShareLock);
 
    return found;
}

References AccessShareLock, BTEqualStrategyNumber, CONSTRAINT_DOMAIN, CONSTRAINT_RELATION, CStringGetDatum(), fb(), HeapTupleIsValid, InvalidOid, ObjectIdGetDatum(), ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by addFkConstraint(), AddRelationNewConstraints(), ATExecAddConstraint(), domainAddCheckConstraint(), domainAddNotNullConstraint(), index_create(), and RenameConstraintById().

ConstraintSetParentConstraint()

void ConstraintSetParentConstraint ( Oid  childConstrId, Oid  parentConstrId, Oid  childTableId  )

extern

Definition at line 1126 of file pg_constraint.c.

{
    Relation    constrRel;
    Form_pg_constraint constrForm;
    HeapTuple   tuple,
                newtup;
    ObjectAddress depender;
    ObjectAddress referenced;
 
    constrRel = table_open(ConstraintRelationId, RowExclusiveLock);
    tuple = SearchSysCache1(CONSTROID, ObjectIdGetDatum(childConstrId));
    if (!HeapTupleIsValid(tuple))
        elog(ERROR, "cache lookup failed for constraint %u", childConstrId);
    newtup = heap_copytuple(tuple);
    constrForm = (Form_pg_constraint) GETSTRUCT(newtup);
    if (OidIsValid(parentConstrId))
    {
        /* don't allow setting parent for a constraint that already has one */
        Assert(constrForm->coninhcount == 0);
        if (constrForm->conparentid != InvalidOid)
            elog(ERROR, "constraint %u already has a parent constraint",
                 childConstrId);
 
        constrForm->conislocal = false;
        if (pg_add_s16_overflow(constrForm->coninhcount, 1,
                                &constrForm->coninhcount))
            ereport(ERROR,
                    errcode(ERRCODE_PROGRAM_LIMIT_EXCEEDED),
                    errmsg("too many inheritance parents"));
 
        constrForm->conparentid = parentConstrId;
 
        CatalogTupleUpdate(constrRel, &tuple->t_self, newtup);
 
        ObjectAddressSet(depender, ConstraintRelationId, childConstrId);
 
        ObjectAddressSet(referenced, ConstraintRelationId, parentConstrId);
        recordDependencyOn(&depender, &referenced, DEPENDENCY_PARTITION_PRI);
 
        ObjectAddressSet(referenced, RelationRelationId, childTableId);
        recordDependencyOn(&depender, &referenced, DEPENDENCY_PARTITION_SEC);
    }
    else
    {
        constrForm->coninhcount--;
        constrForm->conislocal = true;
        constrForm->conparentid = InvalidOid;
 
        /* Make sure there's no further inheritance. */
        Assert(constrForm->coninhcount == 0);
 
        CatalogTupleUpdate(constrRel, &tuple->t_self, newtup);
 
        deleteDependencyRecordsForClass(ConstraintRelationId, childConstrId,
                                        ConstraintRelationId,
                                        DEPENDENCY_PARTITION_PRI);
        deleteDependencyRecordsForClass(ConstraintRelationId, childConstrId,
                                        RelationRelationId,
                                        DEPENDENCY_PARTITION_SEC);
    }
 
    ReleaseSysCache(tuple);
    table_close(constrRel, RowExclusiveLock);
}

References Assert, CatalogTupleUpdate(), deleteDependencyRecordsForClass(), DEPENDENCY_PARTITION_PRI, DEPENDENCY_PARTITION_SEC, elog, ereport, errcode(), errmsg, ERROR, fb(), Form_pg_constraint, GETSTRUCT(), heap_copytuple(), HeapTupleIsValid, InvalidOid, ObjectAddressSet, ObjectIdGetDatum(), OidIsValid, pg_add_s16_overflow(), recordDependencyOn(), ReleaseSysCache(), RowExclusiveLock, SearchSysCache1(), HeapTupleData::t_self, table_close(), and table_open().

Referenced by ATExecAttachPartitionIdx(), AttachPartitionEnsureIndexes(), AttachPartitionForeignKey(), DefineIndex(), and DetachPartitionFinalize().

CreateConstraintEntry()

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  )

extern

Definition at line 51 of file pg_constraint.c.

{
    Relation    conDesc;
    Oid         conOid;
    HeapTuple   tup;
    bool        nulls[Natts_pg_constraint];
    Datum       values[Natts_pg_constraint];
    ArrayType  *conkeyArray;
    ArrayType  *confkeyArray;
    ArrayType  *conpfeqopArray;
    ArrayType  *conppeqopArray;
    ArrayType  *conffeqopArray;
    ArrayType  *conexclopArray;
    ArrayType  *confdelsetcolsArray;
    NameData    cname;
    int         i;
    ObjectAddress conobject;
    ObjectAddresses *addrs_auto;
    ObjectAddresses *addrs_normal;
 
    /* Only CHECK or FOREIGN KEY constraint can be not enforced */
    Assert(isEnforced || constraintType == CONSTRAINT_CHECK ||
           constraintType == CONSTRAINT_FOREIGN);
    /* NOT ENFORCED constraint must be NOT VALID */
    Assert(isEnforced || !isValidated);
 
    conDesc = table_open(ConstraintRelationId, RowExclusiveLock);
 
    Assert(constraintName);
    namestrcpy(&cname, constraintName);
 
    /*
     * Convert C arrays into Postgres arrays.
     */
    if (constraintNKeys > 0)
    {
        Datum      *conkey;
 
        conkey = (Datum *) palloc(constraintNKeys * sizeof(Datum));
        for (i = 0; i < constraintNKeys; i++)
            conkey[i] = Int16GetDatum(constraintKey[i]);
        conkeyArray = construct_array_builtin(conkey, constraintNKeys, INT2OID);
    }
    else
        conkeyArray = NULL;
 
    if (foreignNKeys > 0)
    {
        Datum      *fkdatums;
        int         nkeys = Max(foreignNKeys, numFkDeleteSetCols);
 
        fkdatums = (Datum *) palloc(nkeys * sizeof(Datum));
        for (i = 0; i < foreignNKeys; i++)
            fkdatums[i] = Int16GetDatum(foreignKey[i]);
        confkeyArray = construct_array_builtin(fkdatums, foreignNKeys, INT2OID);
        for (i = 0; i < foreignNKeys; i++)
            fkdatums[i] = ObjectIdGetDatum(pfEqOp[i]);
        conpfeqopArray = construct_array_builtin(fkdatums, foreignNKeys, OIDOID);
        for (i = 0; i < foreignNKeys; i++)
            fkdatums[i] = ObjectIdGetDatum(ppEqOp[i]);
        conppeqopArray = construct_array_builtin(fkdatums, foreignNKeys, OIDOID);
        for (i = 0; i < foreignNKeys; i++)
            fkdatums[i] = ObjectIdGetDatum(ffEqOp[i]);
        conffeqopArray = construct_array_builtin(fkdatums, foreignNKeys, OIDOID);
 
        if (numFkDeleteSetCols > 0)
        {
            for (i = 0; i < numFkDeleteSetCols; i++)
                fkdatums[i] = Int16GetDatum(fkDeleteSetCols[i]);
            confdelsetcolsArray = construct_array_builtin(fkdatums, numFkDeleteSetCols, INT2OID);
        }
        else
            confdelsetcolsArray = NULL;
    }
    else
    {
        confkeyArray = NULL;
        conpfeqopArray = NULL;
        conppeqopArray = NULL;
        conffeqopArray = NULL;
        confdelsetcolsArray = NULL;
    }
 
    if (exclOp != NULL)
    {
        Datum      *opdatums;
 
        opdatums = (Datum *) palloc(constraintNKeys * sizeof(Datum));
        for (i = 0; i < constraintNKeys; i++)
            opdatums[i] = ObjectIdGetDatum(exclOp[i]);
        conexclopArray = construct_array_builtin(opdatums, constraintNKeys, OIDOID);
    }
    else
        conexclopArray = NULL;
 
    /* initialize nulls and values */
    for (i = 0; i < Natts_pg_constraint; i++)
    {
        nulls[i] = false;
        values[i] = (Datum) 0;
    }
 
    conOid = GetNewOidWithIndex(conDesc, ConstraintOidIndexId,
                                Anum_pg_constraint_oid);
    values[Anum_pg_constraint_oid - 1] = ObjectIdGetDatum(conOid);
    values[Anum_pg_constraint_conname - 1] = NameGetDatum(&cname);
    values[Anum_pg_constraint_connamespace - 1] = ObjectIdGetDatum(constraintNamespace);
    values[Anum_pg_constraint_contype - 1] = CharGetDatum(constraintType);
    values[Anum_pg_constraint_condeferrable - 1] = BoolGetDatum(isDeferrable);
    values[Anum_pg_constraint_condeferred - 1] = BoolGetDatum(isDeferred);
    values[Anum_pg_constraint_conenforced - 1] = BoolGetDatum(isEnforced);
    values[Anum_pg_constraint_convalidated - 1] = BoolGetDatum(isValidated);
    values[Anum_pg_constraint_conrelid - 1] = ObjectIdGetDatum(relId);
    values[Anum_pg_constraint_contypid - 1] = ObjectIdGetDatum(domainId);
    values[Anum_pg_constraint_conindid - 1] = ObjectIdGetDatum(indexRelId);
    values[Anum_pg_constraint_conparentid - 1] = ObjectIdGetDatum(parentConstrId);
    values[Anum_pg_constraint_confrelid - 1] = ObjectIdGetDatum(foreignRelId);
    values[Anum_pg_constraint_confupdtype - 1] = CharGetDatum(foreignUpdateType);
    values[Anum_pg_constraint_confdeltype - 1] = CharGetDatum(foreignDeleteType);
    values[Anum_pg_constraint_confmatchtype - 1] = CharGetDatum(foreignMatchType);
    values[Anum_pg_constraint_conislocal - 1] = BoolGetDatum(conIsLocal);
    values[Anum_pg_constraint_coninhcount - 1] = Int16GetDatum(conInhCount);
    values[Anum_pg_constraint_connoinherit - 1] = BoolGetDatum(conNoInherit);
    values[Anum_pg_constraint_conperiod - 1] = BoolGetDatum(conPeriod);
 
    if (conkeyArray)
        values[Anum_pg_constraint_conkey - 1] = PointerGetDatum(conkeyArray);
    else
        nulls[Anum_pg_constraint_conkey - 1] = true;
 
    if (confkeyArray)
        values[Anum_pg_constraint_confkey - 1] = PointerGetDatum(confkeyArray);
    else
        nulls[Anum_pg_constraint_confkey - 1] = true;
 
    if (conpfeqopArray)
        values[Anum_pg_constraint_conpfeqop - 1] = PointerGetDatum(conpfeqopArray);
    else
        nulls[Anum_pg_constraint_conpfeqop - 1] = true;
 
    if (conppeqopArray)
        values[Anum_pg_constraint_conppeqop - 1] = PointerGetDatum(conppeqopArray);
    else
        nulls[Anum_pg_constraint_conppeqop - 1] = true;
 
    if (conffeqopArray)
        values[Anum_pg_constraint_conffeqop - 1] = PointerGetDatum(conffeqopArray);
    else
        nulls[Anum_pg_constraint_conffeqop - 1] = true;
 
    if (confdelsetcolsArray)
        values[Anum_pg_constraint_confdelsetcols - 1] = PointerGetDatum(confdelsetcolsArray);
    else
        nulls[Anum_pg_constraint_confdelsetcols - 1] = true;
 
    if (conexclopArray)
        values[Anum_pg_constraint_conexclop - 1] = PointerGetDatum(conexclopArray);
    else
        nulls[Anum_pg_constraint_conexclop - 1] = true;
 
    if (conBin)
        values[Anum_pg_constraint_conbin - 1] = CStringGetTextDatum(conBin);
    else
        nulls[Anum_pg_constraint_conbin - 1] = true;
 
    tup = heap_form_tuple(RelationGetDescr(conDesc), values, nulls);
 
    CatalogTupleInsert(conDesc, tup);
 
    ObjectAddressSet(conobject, ConstraintRelationId, conOid);
 
    table_close(conDesc, RowExclusiveLock);
 
    /* Handle set of auto dependencies */
    addrs_auto = new_object_addresses();
 
    if (OidIsValid(relId))
    {
        /*
         * Register auto dependency from constraint to owning relation, or to
         * specific column(s) if any are mentioned.
         */
        ObjectAddress relobject;
 
        if (constraintNTotalKeys > 0)
        {
            for (i = 0; i < constraintNTotalKeys; i++)
            {
                ObjectAddressSubSet(relobject, RelationRelationId, relId,
                                    constraintKey[i]);
                add_exact_object_address(&relobject, addrs_auto);
            }
        }
        else
        {
            ObjectAddressSet(relobject, RelationRelationId, relId);
            add_exact_object_address(&relobject, addrs_auto);
        }
    }
 
    if (OidIsValid(domainId))
    {
        /*
         * Register auto dependency from constraint to owning domain
         */
        ObjectAddress domobject;
 
        ObjectAddressSet(domobject, TypeRelationId, domainId);
        add_exact_object_address(&domobject, addrs_auto);
    }
 
    record_object_address_dependencies(&conobject, addrs_auto,
                                       DEPENDENCY_AUTO);
    free_object_addresses(addrs_auto);
 
    /* Handle set of normal dependencies */
    addrs_normal = new_object_addresses();
 
    if (OidIsValid(foreignRelId))
    {
        /*
         * Register normal dependency from constraint to foreign relation, or
         * to specific column(s) if any are mentioned.
         */
        ObjectAddress relobject;
 
        if (foreignNKeys > 0)
        {
            for (i = 0; i < foreignNKeys; i++)
            {
                ObjectAddressSubSet(relobject, RelationRelationId,
                                    foreignRelId, foreignKey[i]);
                add_exact_object_address(&relobject, addrs_normal);
            }
        }
        else
        {
            ObjectAddressSet(relobject, RelationRelationId, foreignRelId);
            add_exact_object_address(&relobject, addrs_normal);
        }
    }
 
    if (OidIsValid(indexRelId) && constraintType == CONSTRAINT_FOREIGN)
    {
        /*
         * Register normal dependency on the unique index that supports a
         * foreign-key constraint.  (Note: for indexes associated with unique
         * or primary-key constraints, the dependency runs the other way, and
         * is not made here.)
         */
        ObjectAddress relobject;
 
        ObjectAddressSet(relobject, RelationRelationId, indexRelId);
        add_exact_object_address(&relobject, addrs_normal);
    }
 
    if (foreignNKeys > 0)
    {
        /*
         * Register normal dependencies on the equality operators that support
         * a foreign-key constraint.  If the PK and FK types are the same then
         * all three operators for a column are the same; otherwise they are
         * different.
         */
        ObjectAddress oprobject;
 
        oprobject.classId = OperatorRelationId;
        oprobject.objectSubId = 0;
 
        for (i = 0; i < foreignNKeys; i++)
        {
            oprobject.objectId = pfEqOp[i];
            add_exact_object_address(&oprobject, addrs_normal);
            if (ppEqOp[i] != pfEqOp[i])
            {
                oprobject.objectId = ppEqOp[i];
                add_exact_object_address(&oprobject, addrs_normal);
            }
            if (ffEqOp[i] != pfEqOp[i])
            {
                oprobject.objectId = ffEqOp[i];
                add_exact_object_address(&oprobject, addrs_normal);
            }
        }
    }
 
    record_object_address_dependencies(&conobject, addrs_normal,
                                       DEPENDENCY_NORMAL);
    free_object_addresses(addrs_normal);
 
    /*
     * We don't bother to register dependencies on the exclusion operators of
     * an exclusion constraint.  We assume they are members of the opclass
     * supporting the index, so there's an indirect dependency via that. (This
     * would be pretty dicey for cross-type operators, but exclusion operators
     * can never be cross-type.)
     */
 
    if (conExpr != NULL)
    {
        /*
         * Register dependencies from constraint to objects mentioned in CHECK
         * expression.
         */
        recordDependencyOnSingleRelExpr(&conobject, conExpr, relId,
                                        DEPENDENCY_NORMAL,
                                        DEPENDENCY_NORMAL, false);
    }
 
    /* Post creation hook for new constraint */
    InvokeObjectPostCreateHookArg(ConstraintRelationId, conOid, 0,
                                  is_internal);
 
    return conOid;
}

References add_exact_object_address(), Assert, BoolGetDatum(), CatalogTupleInsert(), CharGetDatum(), ObjectAddress::classId, construct_array_builtin(), CStringGetTextDatum, DEPENDENCY_AUTO, DEPENDENCY_NORMAL, fb(), free_object_addresses(), GetNewOidWithIndex(), heap_form_tuple(), i, Int16GetDatum(), InvokeObjectPostCreateHookArg, Max, NameGetDatum(), namestrcpy(), new_object_addresses(), ObjectAddressSet, ObjectAddressSubSet, ObjectIdGetDatum(), OidIsValid, palloc(), PointerGetDatum, record_object_address_dependencies(), recordDependencyOnSingleRelExpr(), RelationGetDescr, RowExclusiveLock, table_close(), table_open(), and values.

Referenced by addFkConstraint(), CreateTriggerFiringOn(), domainAddCheckConstraint(), domainAddNotNullConstraint(), index_constraint_create(), StoreRelCheck(), and StoreRelNotNull().

DECLARE_ARRAY_FOREIGN_KEY()

DECLARE_ARRAY_FOREIGN_KEY	(	(confrelid, confkey)	,
		pg_attribute	,
		(attrelid, attnum)
	)

DECLARE_ARRAY_FOREIGN_KEY_OPT()

DECLARE_ARRAY_FOREIGN_KEY_OPT	(	(conrelid, conkey)	,
		pg_attribute	,
		(attrelid, attnum)
	)

DECLARE_INDEX() [1/3]

DECLARE_INDEX	(	pg_constraint_conname_nsp_index	,
		2664	,
		ConstraintNameNspIndexId	,
		pg_constraint	,
		btree(conname name_ops, connamespace oid_ops)
	)

DECLARE_INDEX() [2/3]

DECLARE_INDEX	(	pg_constraint_conparentid_index	,
		2579	,
		ConstraintParentIndexId	,
		pg_constraint	,
		btree(conparentid oid_ops)
	)

DECLARE_INDEX() [3/3]

DECLARE_INDEX	(	pg_constraint_contypid_index	,
		2666	,
		ConstraintTypidIndexId	,
		pg_constraint	,
		btree(contypid oid_ops)
	)

DECLARE_TOAST()

DECLARE_TOAST	(	pg_constraint	,
		2832	,
		2833
	)

DECLARE_UNIQUE_INDEX()

DECLARE_UNIQUE_INDEX	(	pg_constraint_conrelid_contypid_conname_index	,
		2665	,
		ConstraintRelidTypidNameIndexId	,
		pg_constraint	,
		btree(conrelid oid_ops, contypid oid_ops, conname name_ops)
	)

DECLARE_UNIQUE_INDEX_PKEY()

DECLARE_UNIQUE_INDEX_PKEY	(	pg_constraint_oid_index	,
		2667	,
		ConstraintOidIndexId	,
		pg_constraint	,
		btree(oid oid_ops)
	)

DeconstructFkConstraintRow()

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  )

extern

Definition at line 1538 of file pg_constraint.c.

{
    Datum       adatum;
    bool        isNull;
    ArrayType  *arr;
    int         numkeys;
 
    /*
     * We expect the arrays to be 1-D arrays of the right types; verify that.
     * We don't need to use deconstruct_array() since the array data is just
     * going to look like a C array of values.
     */
    adatum = SysCacheGetAttrNotNull(CONSTROID, tuple,
                                    Anum_pg_constraint_conkey);
    arr = DatumGetArrayTypeP(adatum);   /* ensure not toasted */
    if (ARR_NDIM(arr) != 1 ||
        ARR_HASNULL(arr) ||
        ARR_ELEMTYPE(arr) != INT2OID)
        elog(ERROR, "conkey is not a 1-D smallint array");
    numkeys = ARR_DIMS(arr)[0];
    if (numkeys <= 0 || numkeys > INDEX_MAX_KEYS)
        elog(ERROR, "foreign key constraint cannot have %d columns", numkeys);
    memcpy(conkey, ARR_DATA_PTR(arr), numkeys * sizeof(int16));
    if (arr != DatumGetPointer(adatum))
        pfree(arr);             /* free de-toasted copy, if any */
 
    adatum = SysCacheGetAttrNotNull(CONSTROID, tuple,
                                    Anum_pg_constraint_confkey);
    arr = DatumGetArrayTypeP(adatum);   /* ensure not toasted */
    if (ARR_NDIM(arr) != 1 ||
        ARR_DIMS(arr)[0] != numkeys ||
        ARR_HASNULL(arr) ||
        ARR_ELEMTYPE(arr) != INT2OID)
        elog(ERROR, "confkey is not a 1-D smallint array");
    memcpy(confkey, ARR_DATA_PTR(arr), numkeys * sizeof(int16));
    if (arr != DatumGetPointer(adatum))
        pfree(arr);             /* free de-toasted copy, if any */
 
    if (pf_eq_oprs)
    {
        adatum = SysCacheGetAttrNotNull(CONSTROID, tuple,
                                        Anum_pg_constraint_conpfeqop);
        arr = DatumGetArrayTypeP(adatum);   /* ensure not toasted */
        /* see TryReuseForeignKey if you change the test below */
        if (ARR_NDIM(arr) != 1 ||
            ARR_DIMS(arr)[0] != numkeys ||
            ARR_HASNULL(arr) ||
            ARR_ELEMTYPE(arr) != OIDOID)
            elog(ERROR, "conpfeqop is not a 1-D Oid array");
        memcpy(pf_eq_oprs, ARR_DATA_PTR(arr), numkeys * sizeof(Oid));
        if (arr != DatumGetPointer(adatum))
            pfree(arr);         /* free de-toasted copy, if any */
    }
 
    if (pp_eq_oprs)
    {
        adatum = SysCacheGetAttrNotNull(CONSTROID, tuple,
                                        Anum_pg_constraint_conppeqop);
        arr = DatumGetArrayTypeP(adatum);   /* ensure not toasted */
        if (ARR_NDIM(arr) != 1 ||
            ARR_DIMS(arr)[0] != numkeys ||
            ARR_HASNULL(arr) ||
            ARR_ELEMTYPE(arr) != OIDOID)
            elog(ERROR, "conppeqop is not a 1-D Oid array");
        memcpy(pp_eq_oprs, ARR_DATA_PTR(arr), numkeys * sizeof(Oid));
        if (arr != DatumGetPointer(adatum))
            pfree(arr);         /* free de-toasted copy, if any */
    }
 
    if (ff_eq_oprs)
    {
        adatum = SysCacheGetAttrNotNull(CONSTROID, tuple,
                                        Anum_pg_constraint_conffeqop);
        arr = DatumGetArrayTypeP(adatum);   /* ensure not toasted */
        if (ARR_NDIM(arr) != 1 ||
            ARR_DIMS(arr)[0] != numkeys ||
            ARR_HASNULL(arr) ||
            ARR_ELEMTYPE(arr) != OIDOID)
            elog(ERROR, "conffeqop is not a 1-D Oid array");
        memcpy(ff_eq_oprs, ARR_DATA_PTR(arr), numkeys * sizeof(Oid));
        if (arr != DatumGetPointer(adatum))
            pfree(arr);         /* free de-toasted copy, if any */
    }
 
    if (fk_del_set_cols)
    {
        adatum = SysCacheGetAttr(CONSTROID, tuple,
                                 Anum_pg_constraint_confdelsetcols, &isNull);
        if (isNull)
        {
            *num_fk_del_set_cols = 0;
        }
        else
        {
            int         num_delete_cols;
 
            arr = DatumGetArrayTypeP(adatum);   /* ensure not toasted */
            if (ARR_NDIM(arr) != 1 ||
                ARR_HASNULL(arr) ||
                ARR_ELEMTYPE(arr) != INT2OID)
                elog(ERROR, "confdelsetcols is not a 1-D smallint array");
            num_delete_cols = ARR_DIMS(arr)[0];
            memcpy(fk_del_set_cols, ARR_DATA_PTR(arr), num_delete_cols * sizeof(int16));
            if (arr != DatumGetPointer(adatum))
                pfree(arr);     /* free de-toasted copy, if any */
 
            *num_fk_del_set_cols = num_delete_cols;
        }
    }
 
    *numfks = numkeys;
}

References ARR_DATA_PTR, ARR_DIMS, ARR_ELEMTYPE, ARR_HASNULL, ARR_NDIM, DatumGetArrayTypeP, DatumGetPointer(), elog, ERROR, fb(), INDEX_MAX_KEYS, memcpy(), pfree(), SysCacheGetAttr(), and SysCacheGetAttrNotNull().

Referenced by CloneFkReferenced(), CloneFkReferencing(), DetachPartitionFinalize(), RelationGetFKeyList(), and ri_LoadConstraintInfo().

extractNotNullColumn()

AttrNumber extractNotNullColumn ( HeapTuple  constrTup )

extern

Definition at line 702 of file pg_constraint.c.

{
    Datum       adatum;
    ArrayType  *arr;
 
    /* only tuples for not-null constraints should be given */
    Assert(((Form_pg_constraint) GETSTRUCT(constrTup))->contype == CONSTRAINT_NOTNULL);
 
    adatum = SysCacheGetAttrNotNull(CONSTROID, constrTup,
                                    Anum_pg_constraint_conkey);
    arr = DatumGetArrayTypeP(adatum);   /* ensure not toasted */
    if (ARR_NDIM(arr) != 1 ||
        ARR_HASNULL(arr) ||
        ARR_ELEMTYPE(arr) != INT2OID ||
        ARR_DIMS(arr)[0] != 1)
        elog(ERROR, "conkey is not a 1-D smallint array");
 
    /* We leak the detoasted datum, but we don't care */
 
    return ((AttrNumber *) ARR_DATA_PTR(arr))[0];
}

References ARR_DATA_PTR, ARR_DIMS, ARR_ELEMTYPE, ARR_HASNULL, ARR_NDIM, Assert, DatumGetArrayTypeP, elog, ERROR, fb(), Form_pg_constraint, GETSTRUCT(), and SysCacheGetAttrNotNull().

Referenced by ATExecAlterConstrInheritability(), CheckNNConstraintFetch(), dropconstraint_internal(), findNotNullConstraintAttnum(), MergeConstraintsIntoExisting(), pg_get_constraintdef_worker(), QueueNNConstraintValidation(), RelationGetNotNullConstraints(), and RemoveInheritance().

findDomainNotNullConstraint()

HeapTuple findDomainNotNullConstraint ( Oid  typid )

extern

Definition at line 658 of file pg_constraint.c.

{
    Relation    pg_constraint;
    HeapTuple   conTup,
                retval = NULL;
    SysScanDesc scan;
    ScanKeyData key;
 
    pg_constraint = table_open(ConstraintRelationId, AccessShareLock);
    ScanKeyInit(&key,
                Anum_pg_constraint_contypid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(typid));
    scan = systable_beginscan(pg_constraint, ConstraintRelidTypidNameIndexId,
                              true, NULL, 1, &key);
 
    while (HeapTupleIsValid(conTup = systable_getnext(scan)))
    {
        Form_pg_constraint con = (Form_pg_constraint) GETSTRUCT(conTup);
 
        /*
         * We're looking for a NOTNULL constraint that's marked validated.
         */
        if (con->contype != CONSTRAINT_NOTNULL)
            continue;
        if (!con->convalidated)
            continue;
 
        /* Found it */
        retval = heap_copytuple(conTup);
        break;
    }
 
    systable_endscan(scan);
    table_close(pg_constraint, AccessShareLock);
 
    return retval;
}

References AccessShareLock, BTEqualStrategyNumber, fb(), Form_pg_constraint, GETSTRUCT(), heap_copytuple(), HeapTupleIsValid, ObjectIdGetDatum(), ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by AlterDomainNotNull().

FindFKPeriodOpers()

void FindFKPeriodOpers ( Oid  opclass, Oid *  containedbyoperoid, Oid *  aggedcontainedbyoperoid, Oid *  intersectoperoid  )

extern

Definition at line 1668 of file pg_constraint.c.

{
    Oid         opfamily = InvalidOid;
    Oid         opcintype = InvalidOid;
    StrategyNumber strat;
 
    /* Make sure we have a range or multirange. */
    if (get_opclass_opfamily_and_input_type(opclass, &opfamily, &opcintype))
    {
        if (opcintype != ANYRANGEOID && opcintype != ANYMULTIRANGEOID)
            ereport(ERROR,
                    errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
                    errmsg("invalid type for PERIOD part of foreign key"),
                    errdetail("Only range and multirange are supported."));
 
    }
    else
        elog(ERROR, "cache lookup failed for opclass %u", opclass);
 
    /*
     * Look up the ContainedBy operator whose lhs and rhs are the opclass's
     * type. We use this to optimize RI checks: if the new value includes all
     * of the old value, then we can treat the attribute as if it didn't
     * change, and skip the RI check.
     */
    GetOperatorFromCompareType(opclass,
                               InvalidOid,
                               COMPARE_CONTAINED_BY,
                               containedbyoperoid,
                               &strat);
 
    /*
     * Now look up the ContainedBy operator. Its left arg must be the type of
     * the column (or rather of the opclass). Its right arg must match the
     * return type of the support proc.
     */
    GetOperatorFromCompareType(opclass,
                               ANYMULTIRANGEOID,
                               COMPARE_CONTAINED_BY,
                               aggedcontainedbyoperoid,
                               &strat);
 
    switch (opcintype)
    {
        case ANYRANGEOID:
            *intersectoperoid = OID_RANGE_INTERSECT_RANGE_OP;
            break;
        case ANYMULTIRANGEOID:
            *intersectoperoid = OID_MULTIRANGE_INTERSECT_MULTIRANGE_OP;
            break;
        default:
            elog(ERROR, "unexpected opcintype: %u", opcintype);
    }
}

References COMPARE_CONTAINED_BY, elog, ereport, errcode(), errdetail(), errmsg, ERROR, fb(), get_opclass_opfamily_and_input_type(), GetOperatorFromCompareType(), and InvalidOid.

Referenced by ATAddForeignKeyConstraint(), and ri_LoadConstraintInfo().

findNotNullConstraint()

HeapTuple findNotNullConstraint ( Oid  relid, const char *  colname  )

extern

Definition at line 642 of file pg_constraint.c.

{
    AttrNumber  attnum;
 
    attnum = get_attnum(relid, colname);
    if (attnum <= InvalidAttrNumber)
        return NULL;
 
    return findNotNullConstraintAttnum(relid, attnum);
}

References attnum, fb(), findNotNullConstraintAttnum(), get_attnum(), and InvalidAttrNumber.

Referenced by ATExecAlterConstrInheritability(), ATPrepAddPrimaryKey(), dropconstraint_internal(), and QueueNNConstraintValidation().

findNotNullConstraintAttnum()

HeapTuple findNotNullConstraintAttnum ( Oid  relid, AttrNumber  attnum  )

extern

Definition at line 592 of file pg_constraint.c.

{
    Relation    pg_constraint;
    HeapTuple   conTup,
                retval = NULL;
    SysScanDesc scan;
    ScanKeyData key;
 
    pg_constraint = table_open(ConstraintRelationId, AccessShareLock);
    ScanKeyInit(&key,
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(relid));
    scan = systable_beginscan(pg_constraint, ConstraintRelidTypidNameIndexId,
                              true, NULL, 1, &key);
 
    while (HeapTupleIsValid(conTup = systable_getnext(scan)))
    {
        Form_pg_constraint con = (Form_pg_constraint) GETSTRUCT(conTup);
        AttrNumber  conkey;
 
        /*
         * We're looking for a NOTNULL constraint with the column we're
         * looking for as the sole element in conkey.
         */
        if (con->contype != CONSTRAINT_NOTNULL)
            continue;
 
        conkey = extractNotNullColumn(conTup);
        if (conkey != attnum)
            continue;
 
        /* Found it */
        retval = heap_copytuple(conTup);
        break;
    }
 
    systable_endscan(scan);
    table_close(pg_constraint, AccessShareLock);
 
    return retval;
}

References AccessShareLock, attnum, BTEqualStrategyNumber, extractNotNullColumn(), fb(), Form_pg_constraint, GETSTRUCT(), heap_copytuple(), HeapTupleIsValid, ObjectIdGetDatum(), ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by AdjustNotNullInheritance(), ATExecAddIdentity(), ATExecDropNotNull(), ATExecSetNotNull(), findNotNullConstraint(), and MergeAttributesIntoExisting().

get_domain_constraint_oid()

Oid get_domain_constraint_oid ( Oid  typid, const char *  conname, bool  missing_ok  )

extern

Definition at line 1393 of file pg_constraint.c.

{
    Relation    pg_constraint;
    HeapTuple   tuple;
    SysScanDesc scan;
    ScanKeyData skey[3];
    Oid         conOid = InvalidOid;
 
    pg_constraint = table_open(ConstraintRelationId, AccessShareLock);
 
    ScanKeyInit(&skey[0],
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(InvalidOid));
    ScanKeyInit(&skey[1],
                Anum_pg_constraint_contypid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(typid));
    ScanKeyInit(&skey[2],
                Anum_pg_constraint_conname,
                BTEqualStrategyNumber, F_NAMEEQ,
                CStringGetDatum(conname));
 
    scan = systable_beginscan(pg_constraint, ConstraintRelidTypidNameIndexId, true,
                              NULL, 3, skey);
 
    /* There can be at most one matching row */
    if (HeapTupleIsValid(tuple = systable_getnext(scan)))
        conOid = ((Form_pg_constraint) GETSTRUCT(tuple))->oid;
 
    systable_endscan(scan);
 
    /* If no such constraint exists, complain */
    if (!OidIsValid(conOid) && !missing_ok)
        ereport(ERROR,
                (errcode(ERRCODE_UNDEFINED_OBJECT),
                 errmsg("constraint \"%s\" for domain %s does not exist",
                        conname, format_type_be(typid))));
 
    table_close(pg_constraint, AccessShareLock);
 
    return conOid;
}

References AccessShareLock, BTEqualStrategyNumber, CStringGetDatum(), ereport, errcode(), errmsg, ERROR, fb(), Form_pg_constraint, format_type_be(), GETSTRUCT(), HeapTupleIsValid, InvalidOid, ObjectIdGetDatum(), OidIsValid, ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by get_object_address(), and rename_constraint_internal().

get_primary_key_attnos()

Bitmapset * get_primary_key_attnos ( Oid  relid, bool  deferrableOk, Oid *  constraintOid  )

extern

Definition at line 1452 of file pg_constraint.c.

{
    Bitmapset  *pkattnos = NULL;
    Relation    pg_constraint;
    HeapTuple   tuple;
    SysScanDesc scan;
    ScanKeyData skey[1];
 
    /* Set *constraintOid, to avoid complaints about uninitialized vars */
    *constraintOid = InvalidOid;
 
    /* Scan pg_constraint for constraints of the target rel */
    pg_constraint = table_open(ConstraintRelationId, AccessShareLock);
 
    ScanKeyInit(&skey[0],
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(relid));
 
    scan = systable_beginscan(pg_constraint, ConstraintRelidTypidNameIndexId, true,
                              NULL, 1, skey);
 
    while (HeapTupleIsValid(tuple = systable_getnext(scan)))
    {
        Form_pg_constraint con = (Form_pg_constraint) GETSTRUCT(tuple);
        Datum       adatum;
        bool        isNull;
        ArrayType  *arr;
        int16      *attnums;
        int         numkeys;
        int         i;
 
        /* Skip constraints that are not PRIMARY KEYs */
        if (con->contype != CONSTRAINT_PRIMARY)
            continue;
 
        /*
         * If the primary key is deferrable, but we've been instructed to
         * ignore deferrable constraints, then we might as well give up
         * searching, since there can only be a single primary key on a table.
         */
        if (con->condeferrable && !deferrableOk)
            break;
 
        /* Extract the conkey array, ie, attnums of PK's columns */
        adatum = heap_getattr(tuple, Anum_pg_constraint_conkey,
                              RelationGetDescr(pg_constraint), &isNull);
        if (isNull)
            elog(ERROR, "null conkey for constraint %u",
                 ((Form_pg_constraint) GETSTRUCT(tuple))->oid);
        arr = DatumGetArrayTypeP(adatum);   /* ensure not toasted */
        numkeys = ARR_DIMS(arr)[0];
        if (ARR_NDIM(arr) != 1 ||
            numkeys < 0 ||
            ARR_HASNULL(arr) ||
            ARR_ELEMTYPE(arr) != INT2OID)
            elog(ERROR, "conkey is not a 1-D smallint array");
        attnums = (int16 *) ARR_DATA_PTR(arr);
 
        /* Construct the result value */
        for (i = 0; i < numkeys; i++)
        {
            pkattnos = bms_add_member(pkattnos,
                                      attnums[i] - FirstLowInvalidHeapAttributeNumber);
        }
        *constraintOid = ((Form_pg_constraint) GETSTRUCT(tuple))->oid;
 
        /* No need to search further */
        break;
    }
 
    systable_endscan(scan);
 
    table_close(pg_constraint, AccessShareLock);
 
    return pkattnos;
}

References AccessShareLock, ARR_DATA_PTR, ARR_DIMS, ARR_ELEMTYPE, ARR_HASNULL, ARR_NDIM, bms_add_member(), BTEqualStrategyNumber, DatumGetArrayTypeP, elog, ERROR, fb(), FirstLowInvalidHeapAttributeNumber, Form_pg_constraint, GETSTRUCT(), heap_getattr(), HeapTupleIsValid, i, InvalidOid, ObjectIdGetDatum(), RelationGetDescr, ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by check_functional_grouping().

get_relation_constraint_attnos()

Bitmapset * get_relation_constraint_attnos ( Oid  relid, const char *  conname, bool  missing_ok, Oid *  constraintOid  )

extern

Definition at line 1257 of file pg_constraint.c.

{
    Bitmapset  *conattnos = NULL;
    Relation    pg_constraint;
    HeapTuple   tuple;
    SysScanDesc scan;
    ScanKeyData skey[3];
 
    /* Set *constraintOid, to avoid complaints about uninitialized vars */
    *constraintOid = InvalidOid;
 
    pg_constraint = table_open(ConstraintRelationId, AccessShareLock);
 
    ScanKeyInit(&skey[0],
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(relid));
    ScanKeyInit(&skey[1],
                Anum_pg_constraint_contypid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(InvalidOid));
    ScanKeyInit(&skey[2],
                Anum_pg_constraint_conname,
                BTEqualStrategyNumber, F_NAMEEQ,
                CStringGetDatum(conname));
 
    scan = systable_beginscan(pg_constraint, ConstraintRelidTypidNameIndexId, true,
                              NULL, 3, skey);
 
    /* There can be at most one matching row */
    if (HeapTupleIsValid(tuple = systable_getnext(scan)))
    {
        Datum       adatum;
        bool        isNull;
 
        *constraintOid = ((Form_pg_constraint) GETSTRUCT(tuple))->oid;
 
        /* Extract the conkey array, ie, attnums of constrained columns */
        adatum = heap_getattr(tuple, Anum_pg_constraint_conkey,
                              RelationGetDescr(pg_constraint), &isNull);
        if (!isNull)
        {
            ArrayType  *arr;
            int         numcols;
            int16      *attnums;
            int         i;
 
            arr = DatumGetArrayTypeP(adatum);   /* ensure not toasted */
            numcols = ARR_DIMS(arr)[0];
            if (ARR_NDIM(arr) != 1 ||
                numcols < 0 ||
                ARR_HASNULL(arr) ||
                ARR_ELEMTYPE(arr) != INT2OID)
                elog(ERROR, "conkey is not a 1-D smallint array");
            attnums = (int16 *) ARR_DATA_PTR(arr);
 
            /* Construct the result value */
            for (i = 0; i < numcols; i++)
            {
                conattnos = bms_add_member(conattnos,
                                           attnums[i] - FirstLowInvalidHeapAttributeNumber);
            }
        }
    }
 
    systable_endscan(scan);
 
    /* If no such constraint exists, complain */
    if (!OidIsValid(*constraintOid) && !missing_ok)
        ereport(ERROR,
                (errcode(ERRCODE_UNDEFINED_OBJECT),
                 errmsg("constraint \"%s\" for table \"%s\" does not exist",
                        conname, get_rel_name(relid))));
 
    table_close(pg_constraint, AccessShareLock);
 
    return conattnos;
}

References AccessShareLock, ARR_DATA_PTR, ARR_DIMS, ARR_ELEMTYPE, ARR_HASNULL, ARR_NDIM, bms_add_member(), BTEqualStrategyNumber, CStringGetDatum(), DatumGetArrayTypeP, elog, ereport, errcode(), errmsg, ERROR, fb(), FirstLowInvalidHeapAttributeNumber, Form_pg_constraint, get_rel_name(), GETSTRUCT(), heap_getattr(), HeapTupleIsValid, i, InvalidOid, ObjectIdGetDatum(), OidIsValid, RelationGetDescr, ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by transformOnConflictArbiter().

get_relation_constraint_oid()

Oid get_relation_constraint_oid ( Oid  relid, const char *  conname, bool  missing_ok  )

extern

Definition at line 1200 of file pg_constraint.c.

{
    Relation    pg_constraint;
    HeapTuple   tuple;
    SysScanDesc scan;
    ScanKeyData skey[3];
    Oid         conOid = InvalidOid;
 
    pg_constraint = table_open(ConstraintRelationId, AccessShareLock);
 
    ScanKeyInit(&skey[0],
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(relid));
    ScanKeyInit(&skey[1],
                Anum_pg_constraint_contypid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(InvalidOid));
    ScanKeyInit(&skey[2],
                Anum_pg_constraint_conname,
                BTEqualStrategyNumber, F_NAMEEQ,
                CStringGetDatum(conname));
 
    scan = systable_beginscan(pg_constraint, ConstraintRelidTypidNameIndexId, true,
                              NULL, 3, skey);
 
    /* There can be at most one matching row */
    if (HeapTupleIsValid(tuple = systable_getnext(scan)))
        conOid = ((Form_pg_constraint) GETSTRUCT(tuple))->oid;
 
    systable_endscan(scan);
 
    /* If no such constraint exists, complain */
    if (!OidIsValid(conOid) && !missing_ok)
        ereport(ERROR,
                (errcode(ERRCODE_UNDEFINED_OBJECT),
                 errmsg("constraint \"%s\" for table \"%s\" does not exist",
                        conname, get_rel_name(relid))));
 
    table_close(pg_constraint, AccessShareLock);
 
    return conOid;
}

References AccessShareLock, BTEqualStrategyNumber, CStringGetDatum(), ereport, errcode(), errmsg, ERROR, fb(), Form_pg_constraint, get_rel_name(), GETSTRUCT(), HeapTupleIsValid, InvalidOid, ObjectIdGetDatum(), OidIsValid, ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by ATExecAlterCheckConstrEnforceability(), expandTableLikeClause(), get_object_address_relobject(), rename_constraint_internal(), and transformTableLikeClause().

get_relation_idx_constraint_oid()

Oid get_relation_idx_constraint_oid ( Oid  relationId, Oid  indexId  )

extern

Definition at line 1346 of file pg_constraint.c.

{
    Relation    pg_constraint;
    SysScanDesc scan;
    ScanKeyData key;
    HeapTuple   tuple;
    Oid         constraintId = InvalidOid;
 
    pg_constraint = table_open(ConstraintRelationId, AccessShareLock);
 
    ScanKeyInit(&key,
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber,
                F_OIDEQ,
                ObjectIdGetDatum(relationId));
    scan = systable_beginscan(pg_constraint, ConstraintRelidTypidNameIndexId,
                              true, NULL, 1, &key);
    while ((tuple = systable_getnext(scan)) != NULL)
    {
        Form_pg_constraint constrForm;
 
        constrForm = (Form_pg_constraint) GETSTRUCT(tuple);
 
        /* See above */
        if (constrForm->contype != CONSTRAINT_PRIMARY &&
            constrForm->contype != CONSTRAINT_UNIQUE &&
            constrForm->contype != CONSTRAINT_EXCLUSION)
            continue;
 
        if (constrForm->conindid == indexId)
        {
            constraintId = constrForm->oid;
            break;
        }
    }
    systable_endscan(scan);
 
    table_close(pg_constraint, AccessShareLock);
    return constraintId;
}

References AccessShareLock, BTEqualStrategyNumber, fb(), Form_pg_constraint, GETSTRUCT(), InvalidOid, ObjectIdGetDatum(), ScanKeyInit(), systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by ATExecAttachPartitionIdx(), AttachPartitionEnsureIndexes(), DefineIndex(), and DetachPartitionFinalize().

MAKE_SYSCACHE()

MAKE_SYSCACHE	(	CONSTROID	,
		pg_constraint_oid_index	,
		16
	)

RelationGetNotNullConstraints()

List * RelationGetNotNullConstraints ( Oid  relid, bool  cooked, bool  include_noinh  )

extern

Definition at line 834 of file pg_constraint.c.

{
    List       *notnulls = NIL;
    Relation    constrRel;
    HeapTuple   htup;
    SysScanDesc conscan;
    ScanKeyData skey;
 
    constrRel = table_open(ConstraintRelationId, AccessShareLock);
    ScanKeyInit(&skey,
                Anum_pg_constraint_conrelid,
                BTEqualStrategyNumber, F_OIDEQ,
                ObjectIdGetDatum(relid));
    conscan = systable_beginscan(constrRel, ConstraintRelidTypidNameIndexId, true,
                                 NULL, 1, &skey);
 
    while (HeapTupleIsValid(htup = systable_getnext(conscan)))
    {
        Form_pg_constraint conForm = (Form_pg_constraint) GETSTRUCT(htup);
        AttrNumber  colnum;
 
        if (conForm->contype != CONSTRAINT_NOTNULL)
            continue;
        if (conForm->connoinherit && !include_noinh)
            continue;
 
        colnum = extractNotNullColumn(htup);
 
        if (cooked)
        {
            CookedConstraint *cooked;
 
            cooked = palloc_object(CookedConstraint);
 
            cooked->contype = CONSTR_NOTNULL;
            cooked->conoid = conForm->oid;
            cooked->name = pstrdup(NameStr(conForm->conname));
            cooked->attnum = colnum;
            cooked->expr = NULL;
            cooked->is_enforced = true;
            cooked->skip_validation = !conForm->convalidated;
            cooked->is_local = true;
            cooked->inhcount = 0;
            cooked->is_no_inherit = conForm->connoinherit;
 
            notnulls = lappend(notnulls, cooked);
        }
        else
        {
            Constraint *constr;
 
            constr = makeNode(Constraint);
            constr->contype = CONSTR_NOTNULL;
            constr->conname = pstrdup(NameStr(conForm->conname));
            constr->deferrable = false;
            constr->initdeferred = false;
            constr->location = -1;
            constr->keys = list_make1(makeString(get_attname(relid, colnum,
                                                             false)));
            constr->is_enforced = true;
            constr->skip_validation = !conForm->convalidated;
            constr->initially_valid = conForm->convalidated;
            constr->is_no_inherit = conForm->connoinherit;
            notnulls = lappend(notnulls, constr);
        }
    }
 
    systable_endscan(conscan);
    table_close(constrRel, AccessShareLock);
 
    return notnulls;
}

References AccessShareLock, BTEqualStrategyNumber, Constraint::conname, CONSTR_NOTNULL, Constraint::contype, Constraint::deferrable, extractNotNullColumn(), fb(), Form_pg_constraint, get_attname(), GETSTRUCT(), HeapTupleIsValid, Constraint::initdeferred, Constraint::initially_valid, Constraint::is_enforced, Constraint::is_no_inherit, Constraint::keys, lappend(), list_make1, Constraint::location, makeNode, makeString(), NameStr, NIL, ObjectIdGetDatum(), palloc_object, pstrdup(), ScanKeyInit(), Constraint::skip_validation, systable_beginscan(), systable_endscan(), systable_getnext(), table_close(), and table_open().

Referenced by createTableConstraints(), MergeAttributes(), and transformTableLikeClause().

RemoveConstraintById()

void RemoveConstraintById ( Oid  conId )

extern

Definition at line 912 of file pg_constraint.c.

{
    Relation    conDesc;
    HeapTuple   tup;
    Form_pg_constraint con;
 
    conDesc = table_open(ConstraintRelationId, RowExclusiveLock);
 
    tup = SearchSysCache1(CONSTROID, ObjectIdGetDatum(conId));
    if (!HeapTupleIsValid(tup)) /* should not happen */
        elog(ERROR, "cache lookup failed for constraint %u", conId);
    con = (Form_pg_constraint) GETSTRUCT(tup);
 
    /*
     * Special processing depending on what the constraint is for.
     */
    if (OidIsValid(con->conrelid))
    {
        Relation    rel;
 
        /*
         * If the constraint is for a relation, open and exclusive-lock the
         * relation it's for.
         */
        rel = table_open(con->conrelid, AccessExclusiveLock);
 
        /*
         * We need to update the relchecks count if it is a check constraint
         * being dropped.  This update will force backends to rebuild relcache
         * entries when we commit.
         */
        if (con->contype == CONSTRAINT_CHECK)
        {
            Relation    pgrel;
            HeapTuple   relTup;
            Form_pg_class classForm;
 
            pgrel = table_open(RelationRelationId, RowExclusiveLock);
            relTup = SearchSysCacheCopy1(RELOID,
                                         ObjectIdGetDatum(con->conrelid));
            if (!HeapTupleIsValid(relTup))
                elog(ERROR, "cache lookup failed for relation %u",
                     con->conrelid);
            classForm = (Form_pg_class) GETSTRUCT(relTup);
 
            if (classForm->relchecks > 0)
                classForm->relchecks--;
            else
                /* should not happen */
                elog(WARNING, "relation \"%s\" has relchecks = %d",
                     RelationGetRelationName(rel), classForm->relchecks);
 
            CatalogTupleUpdate(pgrel, &relTup->t_self, relTup);
 
            heap_freetuple(relTup);
 
            table_close(pgrel, RowExclusiveLock);
        }
 
        /* Keep lock on constraint's rel until end of xact */
        table_close(rel, NoLock);
    }
    else if (OidIsValid(con->contypid))
    {
        /*
         * XXX for now, do nothing special when dropping a domain constraint
         *
         * Probably there should be some form of locking on the domain type,
         * but we have no such concept at the moment.
         */
    }
    else
        elog(ERROR, "constraint %u is not of a known type", conId);
 
    /* Fry the constraint itself */
    CatalogTupleDelete(conDesc, &tup->t_self);
 
    /* Clean up */
    ReleaseSysCache(tup);
    table_close(conDesc, RowExclusiveLock);
}

References AccessExclusiveLock, CatalogTupleDelete(), CatalogTupleUpdate(), elog, ERROR, fb(), Form_pg_constraint, GETSTRUCT(), heap_freetuple(), HeapTupleIsValid, NoLock, ObjectIdGetDatum(), OidIsValid, RelationGetRelationName, ReleaseSysCache(), RowExclusiveLock, SearchSysCache1(), SearchSysCacheCopy1, table_close(), table_open(), and WARNING.

Referenced by doDeletion().

RenameConstraintById()

void RenameConstraintById ( Oid  conId, const char *  newname  )

extern

Definition at line 1005 of file pg_constraint.c.

{
    Relation    conDesc;
    HeapTuple   tuple;
    Form_pg_constraint con;
 
    conDesc = table_open(ConstraintRelationId, RowExclusiveLock);
 
    tuple = SearchSysCacheCopy1(CONSTROID, ObjectIdGetDatum(conId));
    if (!HeapTupleIsValid(tuple))
        elog(ERROR, "cache lookup failed for constraint %u", conId);
    con = (Form_pg_constraint) GETSTRUCT(tuple);
 
    /*
     * For user-friendliness, check whether the name is already in use.
     */
    if (OidIsValid(con->conrelid) &&
        ConstraintNameIsUsed(CONSTRAINT_RELATION,
                             con->conrelid,
                             newname))
        ereport(ERROR,
                (errcode(ERRCODE_DUPLICATE_OBJECT),
                 errmsg("constraint \"%s\" for relation \"%s\" already exists",
                        newname, get_rel_name(con->conrelid))));
    if (OidIsValid(con->contypid) &&
        ConstraintNameIsUsed(CONSTRAINT_DOMAIN,
                             con->contypid,
                             newname))
        ereport(ERROR,
                (errcode(ERRCODE_DUPLICATE_OBJECT),
                 errmsg("constraint \"%s\" for domain %s already exists",
                        newname, format_type_be(con->contypid))));
 
    /* OK, do the rename --- tuple is a copy, so OK to scribble on it */
    namestrcpy(&(con->conname), newname);
 
    CatalogTupleUpdate(conDesc, &tuple->t_self, tuple);
 
    InvokeObjectPostAlterHook(ConstraintRelationId, conId, 0);
 
    heap_freetuple(tuple);
    table_close(conDesc, RowExclusiveLock);
}

References CatalogTupleUpdate(), CONSTRAINT_DOMAIN, CONSTRAINT_RELATION, ConstraintNameIsUsed(), elog, ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errmsg, ERROR, fb(), Form_pg_constraint, format_type_be(), get_rel_name(), GETSTRUCT(), heap_freetuple(), HeapTupleIsValid, InvokeObjectPostAlterHook, namestrcpy(), ObjectIdGetDatum(), OidIsValid, RowExclusiveLock, SearchSysCacheCopy1, HeapTupleData::t_self, table_close(), and table_open().

Referenced by rename_constraint_internal(), and RenameRelationInternal().

Variable Documentation

Form_pg_constraint

END_CATALOG_STRUCT typedef FormData_pg_constraint* Form_pg_constraint

Definition at line 179 of file pg_constraint.h.

Referenced by AdjustNotNullInheritance(), AfterTriggerSetState(), AlterConstraintNamespaces(), AlterConstrDeferrabilityRecurse(), AlterConstrUpdateConstraintEntry(), AlterDomainDropConstraint(), AlterDomainNotNull(), AlterDomainValidateConstraint(), AlterFKConstrEnforceabilityRecurse(), ATCheckCheckConstrHasEnforcedParent(), ATDetachCheckNoForeignKeyRefs(), ATExecAddIdentity(), ATExecAlterCheckConstrEnforceability(), ATExecAlterConstraint(), ATExecAlterConstraintInternal(), ATExecAlterConstrDeferrability(), ATExecAlterConstrInheritability(), ATExecAlterFKConstrEnforceability(), ATExecSetNotNull(), ATExecValidateConstraint(), ATPostAlterTypeCleanup(), ATPrepChangePersistence(), AttachPartitionForeignKey(), CacheInvalidateHeapTupleCommon(), check_object_ownership(), CheckNNConstraintFetch(), CloneFkReferenced(), CloneFkReferencing(), constraints_equivalent(), ConstraintSetParentConstraint(), copy_index_constraints(), decompile_conbin(), DetachPartitionFinalize(), dropconstraint_internal(), extractNotNullColumn(), findDomainNotNullConstraint(), findNotNullConstraintAttnum(), generateClonedIndexStmt(), get_constraint_index(), get_constraint_name(), get_constraint_type(), get_domain_constraint_oid(), get_primary_key_attnos(), get_relation_constraint_attnos(), get_relation_constraint_oid(), get_relation_idx_constraint_oid(), get_ri_constraint_root(), getConstraintTypeDescription(), getObjectDescription(), getObjectIdentityParts(), GetParentedForeignKeyRefs(), heap_truncate_find_FKs(), index_concurrently_swap(), load_domaintype_info(), MergeAttributesIntoExisting(), MergeConstraintsIntoExisting(), MergeWithExistingConstraint(), pg_get_constraintdef_worker(), QueueCheckConstraintValidation(), QueueFKConstraintValidation(), QueueNNConstraintValidation(), RelationGetExclusionInfo(), RelationGetFKeyList(), RelationGetNotNullConstraints(), RememberWholeRowDependentForRebuilding(), RemoveConstraintById(), RemoveInheritance(), RemoveInheritedConstraint(), rename_constraint_internal(), RenameConstraintById(), ri_LoadConstraintInfo(), tryAttachPartitionForeignKey(), and verifyNotNullPKCompatible().

FormData_pg_constraint

FormData_pg_constraint

Definition at line 170 of file pg_constraint.h.