Gecko [ www.finalhopeacademy.com ]

Name	Size	Permission
catalog.h	2.05 KB	-rw-r--r--
catversion.h	2.53 KB	-rw-r--r--
dependency.h	9.44 KB	-rw-r--r--
genbki.h	1.75 KB	-rw-r--r--
heap.h	3.81 KB	-rw-r--r--
index.h	3.03 KB	-rw-r--r--
indexing.h	16.29 KB	-rw-r--r--
namespace.h	5.71 KB	-rw-r--r--
objectaccess.h	1.62 KB	-rw-r--r--
objectaddress.h	1.21 KB	-rw-r--r--
pg_aggregate.h	10.36 KB	-rw-r--r--
pg_am.h	5.8 KB	-rw-r--r--
pg_amop.h	24.52 KB	-rw-r--r--
pg_amproc.h	14.01 KB	-rw-r--r--
pg_attrdef.h	1.63 KB	-rw-r--r--
pg_attribute.h	6.79 KB	-rw-r--r--
pg_auth_members.h	1.75 KB	-rw-r--r--
pg_authid.h	3.19 KB	-rw-r--r--
pg_cast.h	11.48 KB	-rw-r--r--
pg_class.h	5.93 KB	-rw-r--r--
pg_collation.h	2.23 KB	-rw-r--r--
pg_collation_fn.h	735 B	-rw-r--r--
pg_constraint.h	8.11 KB	-rw-r--r--
pg_control.h	7.98 KB	-rw-r--r--
pg_conversion.h	2.12 KB	-rw-r--r--
pg_conversion_fn.h	833 B	-rw-r--r--
pg_database.h	2.63 KB	-rw-r--r--
pg_db_role_setting.h	1.96 KB	-rw-r--r--
pg_default_acl.h	2.1 KB	-rw-r--r--
pg_depend.h	2.73 KB	-rw-r--r--
pg_description.h	2.92 KB	-rw-r--r--
pg_enum.h	1.82 KB	-rw-r--r--
pg_extension.h	2.09 KB	-rw-r--r--
pg_foreign_data_wrapper.h	2.02 KB	-rw-r--r--
pg_foreign_server.h	1.87 KB	-rw-r--r--
pg_foreign_table.h	1.59 KB	-rw-r--r--
pg_index.h	3.76 KB	-rw-r--r--
pg_inherits.h	1.46 KB	-rw-r--r--
pg_inherits_fn.h	850 B	-rw-r--r--
pg_language.h	2.38 KB	-rw-r--r--
pg_largeobject.h	1.79 KB	-rw-r--r--
pg_largeobject_metadata.h	1.67 KB	-rw-r--r--
pg_namespace.h	2.23 KB	-rw-r--r--
pg_opclass.h	11.43 KB	-rw-r--r--
pg_operator.h	95.73 KB	-rw-r--r--
pg_opfamily.h	6.34 KB	-rw-r--r--
pg_pltemplate.h	3.11 KB	-rw-r--r--
pg_proc.h	450.69 KB	-rw-r--r--
pg_proc_fn.h	1.14 KB	-rw-r--r--
pg_range.h	2.53 KB	-rw-r--r--
pg_rewrite.h	1.85 KB	-rw-r--r--
pg_seclabel.h	1.33 KB	-rw-r--r--
pg_shdepend.h	2.75 KB	-rw-r--r--
pg_shdescription.h	2.39 KB	-rw-r--r--
pg_shseclabel.h	1.31 KB	-rw-r--r--
pg_statistic.h	11.19 KB	-rw-r--r--
pg_tablespace.h	1.85 KB	-rw-r--r--
pg_trigger.h	5.61 KB	-rw-r--r--
pg_ts_config.h	1.61 KB	-rw-r--r--
pg_ts_config_map.h	2.28 KB	-rw-r--r--
pg_ts_dict.h	1.78 KB	-rw-r--r--
pg_ts_parser.h	1.95 KB	-rw-r--r--
pg_ts_template.h	2.1 KB	-rw-r--r--
pg_type.h	41.38 KB	-rw-r--r--
pg_type_fn.h	2.08 KB	-rw-r--r--
pg_user_mapping.h	1.59 KB	-rw-r--r--
schemapg.h	15.78 KB	-rw-r--r--
storage.h	1.33 KB	-rw-r--r--
toasting.h	1.91 KB	-rw-r--r--

Code Editor : pg_constraint.h

/*-------------------------------------------------------------------------
 *
 * pg_constraint.h
 *	  definition of the system "constraint" relation (pg_constraint)
 *	  along with the relation's initial contents.
 *
 *
 * Portions Copyright (c) 1996-2012, PostgreSQL Global Development Group
 * Portions Copyright (c) 1994, Regents of the University of California
 *
 * src/include/catalog/pg_constraint.h
 *
 * NOTES
 *	  the genbki.pl script reads this file and generates .bki
 *	  information from the DATA() statements.
 *
 *-------------------------------------------------------------------------
 */
#ifndef PG_CONSTRAINT_H
#define PG_CONSTRAINT_H

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

/* ----------------
 *		pg_constraint definition.  cpp turns this into
 *		typedef struct FormData_pg_constraint
 * ----------------
 */
#define ConstraintRelationId  2606

CATALOG(pg_constraint,2606)
{
	/*
	 * 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.
	 */
	NameData	conname;		/* name of this constraint */
	Oid			connamespace;	/* OID of namespace containing constraint */
	char		contype;		/* constraint type; see codes below */
	bool		condeferrable;	/* deferrable constraint? */
	bool		condeferred;	/* deferred by default? */
	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;		/* 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;		/* 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;		/* index supporting this 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;		/* 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) */
	int4		coninhcount;

/* Has a local definition and cannot be inherited */
	bool		connoinherit;

#ifdef CATALOG_VARLEN			/* variable-length fields start here */

/*
	 * Columns of conrelid that the constraint applies to, if known (this is
	 * NULL for trigger constraints)
	 */
	int2		conkey[1];

/*
	 * If a foreign key, the referenced columns of confrelid
	 */
	int2		confkey[1];

/*
	 * If a foreign key, the OIDs of the PK = FK equality operators for each
	 * column of the constraint
	 */
	Oid			conpfeqop[1];

/*
	 * If a foreign key, the OIDs of the PK = PK equality operators for each
	 * column of the constraint (i.e., equality for the referenced columns)
	 */
	Oid			conppeqop[1];

/*
	 * If a foreign key, the OIDs of the FK = FK equality operators for each
	 * column of the constraint (i.e., equality for the referencing columns)
	 */
	Oid			conffeqop[1];

/*
	 * If an exclusion constraint, the OIDs of the exclusion operators for
	 * each column of the constraint
	 */
	Oid			conexclop[1];

/*
	 * If a check constraint, nodeToString representation of expression
	 */
	pg_node_tree conbin;

/*
	 * If a check constraint, source-text representation of expression
	 */
	text		consrc;
#endif
} FormData_pg_constraint;

/* ----------------
 *		Form_pg_constraint corresponds to a pointer to a tuple with
 *		the format of pg_constraint relation.
 * ----------------
 */
typedef FormData_pg_constraint *Form_pg_constraint;

/* ----------------
 *		compiler constants for pg_constraint
 * ----------------
 */
#define Natts_pg_constraint					24
#define Anum_pg_constraint_conname			1
#define Anum_pg_constraint_connamespace		2
#define Anum_pg_constraint_contype			3
#define Anum_pg_constraint_condeferrable	4
#define Anum_pg_constraint_condeferred		5
#define Anum_pg_constraint_convalidated		6
#define Anum_pg_constraint_conrelid			7
#define Anum_pg_constraint_contypid			8
#define Anum_pg_constraint_conindid			9
#define Anum_pg_constraint_confrelid		10
#define Anum_pg_constraint_confupdtype		11
#define Anum_pg_constraint_confdeltype		12
#define Anum_pg_constraint_confmatchtype	13
#define Anum_pg_constraint_conislocal		14
#define Anum_pg_constraint_coninhcount		15
#define Anum_pg_constraint_connoinherit		16
#define Anum_pg_constraint_conkey			17
#define Anum_pg_constraint_confkey			18
#define Anum_pg_constraint_conpfeqop		19
#define Anum_pg_constraint_conppeqop		20
#define Anum_pg_constraint_conffeqop		21
#define Anum_pg_constraint_conexclop		22
#define Anum_pg_constraint_conbin			23
#define Anum_pg_constraint_consrc			24

/* Valid values for contype */
#define CONSTRAINT_CHECK			'c'
#define CONSTRAINT_FOREIGN			'f'
#define CONSTRAINT_PRIMARY			'p'
#define CONSTRAINT_UNIQUE			'u'
#define CONSTRAINT_TRIGGER			't'
#define CONSTRAINT_EXCLUSION		'x'

/*
 * Valid values for confupdtype and confdeltype are the FKCONSTR_ACTION_xxx
 * constants defined in parsenodes.h.  Valid values for confmatchtype are
 * the FKCONSTR_MATCH_xxx constants defined in parsenodes.h.
 */

/*
 * Identify constraint type for lookup purposes
 */
typedef enum ConstraintCategory
{
	CONSTRAINT_RELATION,
	CONSTRAINT_DOMAIN,
	CONSTRAINT_ASSERTION		/* for future expansion */
} ConstraintCategory;

/*
 * prototypes for functions in pg_constraint.c
 */
extern Oid CreateConstraintEntry(const char *constraintName,
					  Oid constraintNamespace,
					  char constraintType,
					  bool isDeferrable,
					  bool isDeferred,
					  bool isValidated,
					  Oid relId,
					  const int16 *constraintKey,
					  int constraintNKeys,
					  Oid domainId,
					  Oid indexRelId,
					  Oid foreignRelId,
					  const int16 *foreignKey,
					  const Oid *pfEqOp,
					  const Oid *ppEqOp,
					  const Oid *ffEqOp,
					  int foreignNKeys,
					  char foreignUpdateType,
					  char foreignDeleteType,
					  char foreignMatchType,
					  const Oid *exclOp,
					  Node *conExpr,
					  const char *conBin,
					  const char *conSrc,
					  bool conIsLocal,
					  int conInhCount,
					  bool conNoInherit);

extern void RemoveConstraintById(Oid conId);
extern void RenameConstraintById(Oid conId, const char *newname);
extern void SetValidatedConstraintById(Oid conId);

extern bool ConstraintNameIsUsed(ConstraintCategory conCat, Oid objId,
					 Oid objNamespace, const char *conname);
extern char *ChooseConstraintName(const char *name1, const char *name2,
					 const char *label, Oid namespaceid,
					 List *others);

extern void AlterConstraintNamespaces(Oid ownerId, Oid oldNspId,
						  Oid newNspId, bool isType, ObjectAddresses *objsMoved);
extern void get_constraint_relation_oids(Oid constraint_oid, Oid *conrelid, Oid *confrelid);
extern Oid	get_relation_constraint_oid(Oid relid, const char *conname, bool missing_ok);
extern Oid	get_domain_constraint_oid(Oid typid, const char *conname, bool missing_ok);

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

#endif   /* PG_CONSTRAINT_H */

${this.title}

Code Editor : pg_constraint.h