1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
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 }
---------------------------------------
|
