summaryrefslogtreecommitdiff
path: root/pgsql_mib_pieces/pg_constraint.mib
diff options
context:
space:
mode:
Diffstat (limited to 'pgsql_mib_pieces/pg_constraint.mib')
-rw-r--r--pgsql_mib_pieces/pg_constraint.mib167
1 files changed, 167 insertions, 0 deletions
diff --git a/pgsql_mib_pieces/pg_constraint.mib b/pgsql_mib_pieces/pg_constraint.mib
new file mode 100644
index 0000000..82609a8
--- /dev/null
+++ b/pgsql_mib_pieces/pg_constraint.mib
@@ -0,0 +1,167 @@
+pgsqlPgConstraintTable OBJECT-TYPE
+ SYNTAX SEQUENCE OF pgsqlPgConstraintEntry
+ MAX-ACCESS not-accessible
+ STATUS current
+ DESCRIPTION
+ "The catalog pg_constraint stores check, primary key, unique, and foreign key constraints on tables. (Column constraints are not treated specially. Every column constraint is equivalent to some table constraint.) Not-null constraints are represented in the pg_attribute catalog."
+ ::= { pgsqlCatalogTables 12 }
+
+pgsqlPgConstraintEntry OBJECT-TYPE
+ SYNTAX PgsqlPgConstraintEntry
+ MAX-ACCESS not-accessible
+ STATUS current
+ DESCRIPTION
+ "A constraint entry"
+ INDEX { pgsnmpdConnID, rdbmsDbIndex, pgsqlPgConstraintEntryOID }
+ ::= { pgsqlPgConstraintTable 1 }
+
+PgsqlPgConstraintEntry ::=
+ SEQUENCE {
+ pgsqlPgConstraintEntryOID INTEGER,
+ pgsqlPgConstraintConname DisplayString,
+ pgsqlPgConstraintConnamespace INTEGER,
+ pgsqlPgConstraintContype DisplayString,
+ pgsqlPgConstraintCondeferrable TruthValue,
+ pgsqlPgConstraintCondeferred TruthValue,
+ pgsqlPgConstraintConrelid INTEGER,
+ pgsqlPgConstraintContypid INTEGER,
+ pgsqlPgConstraintConfrelid INTEGER,
+ pgsqlPgConstraintConfupdtype DisplayString,
+ pgsqlPgConstraintConfdeltype DisplayString,
+ pgsqlPgConstraintConfmatchtype DisplayString,
+ pgsqlPgConstraintConkey DisplayString,
+ pgsqlPgConstraintConfkey DisplayString,
+ pgsqlPgConstraintConbin DisplayString,
+ pgsqlPgConstraintConsrc DisplayString
+ }
+
+pgsqlPgConstraintEntryOID OBJECT-TYPE
+ SYNTAX INTEGER
+ MAX-ACCESS not-accessible
+ STATUS current
+ DESCRIPTION
+ "OID of this entry"
+ ::= { pgsqlPgConstraintEntry 1 }
+
+pgsqlPgConstraintConname OBJECT-TYPE
+ SYNTAX DisplayString
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "Constraint name (not necessarily unique!)"
+ ::= { pgsqlPgConstraintEntry 2 }
+
+pgsqlPgConstraintConnamespace OBJECT-TYPE
+ SYNTAX INTEGER
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "The OID of the namespace that contains this constraint"
+ ::= { pgsqlPgConstraintEntry 3 }
+
+pgsqlPgConstraintContype OBJECT-TYPE
+ SYNTAX DisplayString
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "c = check constraint, f = foreign key constraint, p = primary key constraint, u = unique constraint"
+ ::= { pgsqlPgConstraintEntry 4 }
+
+pgsqlPgConstraintCondeferrable OBJECT-TYPE
+ SYNTAX TruthValue
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "Is the constraint deferrable?"
+ ::= { pgsqlPgConstraintEntry 5 }
+
+pgsqlPgConstraintCondeferred OBJECT-TYPE
+ SYNTAX TruthValue
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "Is the constraint deferred by default?"
+ ::= { pgsqlPgConstraintEntry 6 }
+
+pgsqlPgConstraintConrelid OBJECT-TYPE
+ SYNTAX INTEGER
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "The table this constraint is on; 0 if not a table constraint"
+ ::= { pgsqlPgConstraintEntry 7 }
+
+pgsqlPgConstraintContypid OBJECT-TYPE
+ SYNTAX INTEGER
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "The domain this constraint is on; 0 if not a domain constraint"
+ ::= { pgsqlPgConstraintEntry 8 }
+
+pgsqlPgConstraintConfrelid OBJECT-TYPE
+ SYNTAX INTEGER
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "If a foreign key, the referenced table; else 0"
+ ::= { pgsqlPgConstraintEntry 9 }
+
+pgsqlPgConstraintConfupdtype OBJECT-TYPE
+ SYNTAX DisplayString
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "Foreign key update action code"
+ ::= { pgsqlPgConstraintEntry 10 }
+
+pgsqlPgConstraintConfdeltype OBJECT-TYPE
+ SYNTAX DisplayString
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "Foreign key deletion action code"
+ ::= { pgsqlPgConstraintEntry 11 }
+
+pgsqlPgConstraintConfmatchtype OBJECT-TYPE
+ SYNTAX DisplayString
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "Foreign key match type"
+ ::= { pgsqlPgConstraintEntry 12 }
+
+pgsqlPgConstraintConkey OBJECT-TYPE
+ SYNTAX DisplayString
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "If a table constraint, list of columns which the constraint constrains"
+ ::= { pgsqlPgConstraintEntry 13 }
+
+pgsqlPgConstraintConfkey OBJECT-TYPE
+ SYNTAX DisplayString
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "If a foreign key, list of the referenced columns"
+ ::= { pgsqlPgConstraintEntry 14 }
+
+pgsqlPgConstraintConbin OBJECT-TYPE
+ SYNTAX DisplayString
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "If a check constraint, an internal representation of the expression"
+ ::= { pgsqlPgConstraintEntry 15 }
+
+pgsqlPgConstraintConsrc OBJECT-TYPE
+ SYNTAX DisplayString
+ MAX-ACCESS read-only
+ STATUS current
+ DESCRIPTION
+ "If a check constraint, a human-readable representation of the expression"
+ ::= { pgsqlPgConstraintEntry 16 }
+
+
+---------------------------------------