diff options
Diffstat (limited to 'pgsql_mib_pieces/pg_constraint.mib')
-rw-r--r-- | pgsql_mib_pieces/pg_constraint.mib | 167 |
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 } + + +--------------------------------------- |