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
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
|
pgsqlPgProcTable OBJECT-TYPE
SYNTAX SEQUENCE OF pgsqlPgProcEntry
MAX-ACCESS not-accessible
STATUS current
DESCRIPTION
"The catalog pg_proc stores information about functions (or procedures). The table contains data for aggregate functions as well as plain functions. If proisagg is true, there should be a matching row in pg_aggregate."
::= { pgsqlCatalogTables 26 }
pgsqlPgProcEntry OBJECT-TYPE
SYNTAX PgsqlPgProcEntry
MAX-ACCESS not-accessible
STATUS current
DESCRIPTION
"Represents a single stored procedure"
INDEX { pgsnmpdConnID, rdbmsDbIndex, pgsqlPgProcEntryOID }
::= { pgsqlPgProcTable 1 }
PgsqlPgProcEntry ::=
SEQUENCE {
pgsqlPgProcEntryOID INTEGER,
pgsqlPgProcProname DisplayString,
pgsqlPgProcPronamespace INTEGER,
pgsqlPgProcProowner INTEGER,
pgsqlPgProcProlang INTEGER,
pgsqlPgProcProisagg TruthValue,
pgsqlPgProcProsecdef TruthValue,
pgsqlPgProcProisstrict TruthValue,
pgsqlPgProcProretset TruthValue,
pgsqlPgProcProvolatile DisplayString,
pgsqlPgProcPronargs INTEGER,
pgsqlPgProcProrettype INTEGER,
pgsqlPgProcProargtypes DisplayString,
pgsqlPgProcProallargtypes DisplayString,
pgsqlPgProcProargmodes DisplayString,
pgsqlPgProcProargnames DisplayString,
pgsqlPgProcProsrc DisplayString,
pgsqlPgProcProbin DisplayString,
pgsqlPgProcProacl DisplayString
}
pgsqlPgProcEntryOID OBJECT-TYPE
SYNTAX INTEGER
MAX-ACCESS not-accessible
STATUS current
DESCRIPTION
"OID of this entry"
::= { pgsqlPgProcEntry 1 }
pgsqlPgProcProname OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Name of the function"
::= { pgsqlPgProcEntry 2 }
pgsqlPgProcPronamespace OBJECT-TYPE
SYNTAX INTEGER
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"The OID of the namespace that contains this function"
::= { pgsqlPgProcEntry 3 }
pgsqlPgProcProowner OBJECT-TYPE
SYNTAX INTEGER
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Owner of the function"
::= { pgsqlPgProcEntry 4 }
pgsqlPgProcProlang OBJECT-TYPE
SYNTAX INTEGER
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Implementation language or call interface of this function"
::= { pgsqlPgProcEntry 5 }
pgsqlPgProcProisagg OBJECT-TYPE
SYNTAX TruthValue
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Function is an aggregate function"
::= { pgsqlPgProcEntry 6 }
pgsqlPgProcProsecdef OBJECT-TYPE
SYNTAX TruthValue
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Function is a security definer (i.e., a "
::= { pgsqlPgProcEntry 7 }
pgsqlPgProcProisstrict OBJECT-TYPE
SYNTAX TruthValue
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Function returns null if any call argument is null. In that case the function won't actually be called at all. Functions that are not "
::= { pgsqlPgProcEntry 8 }
pgsqlPgProcProretset OBJECT-TYPE
SYNTAX TruthValue
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Function returns a set (i.e., multiple values of the specified data type)"
::= { pgsqlPgProcEntry 9 }
pgsqlPgProcProvolatile OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"provolatile tells whether the function's result depends only on its input arguments, or is affected by outside factors. It is i for "
::= { pgsqlPgProcEntry 10 }
pgsqlPgProcPronargs OBJECT-TYPE
SYNTAX INTEGER
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Number of arguments"
::= { pgsqlPgProcEntry 11 }
pgsqlPgProcProrettype OBJECT-TYPE
SYNTAX INTEGER
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Data type of the return value"
::= { pgsqlPgProcEntry 12 }
pgsqlPgProcProargtypes OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"An array with the data types of the function arguments. This includes only input arguments (including INOUT arguments), and thus represents the call signature of the function"
::= { pgsqlPgProcEntry 13 }
pgsqlPgProcProallargtypes OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"An array with the data types of the function arguments. This includes all arguments (including OUT and INOUT arguments); however, if all the arguments are IN arguments, this field will be null. Note that subscripting is 1-based, whereas for historical reasons proargtypes is subscripted from 0"
::= { pgsqlPgProcEntry 14 }
pgsqlPgProcProargmodes OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"An array with the modes of the function arguments, encoded as i for IN arguments, o for OUT arguments, b for INOUT arguments. If all the arguments are IN arguments, this field will be null. Note that subscripts correspond to positions of proallargtypes not proargtypes"
::= { pgsqlPgProcEntry 15 }
pgsqlPgProcProargnames OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"An array with the names of the function arguments. Arguments without a name are set to empty strings in the array. If none of the arguments have a name, this field will be null. Note that subscripts correspond to positions of proallargtypes not proargtypes"
::= { pgsqlPgProcEntry 16 }
pgsqlPgProcProsrc OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"This tells the function handler how to invoke the function. It might be the actual source code of the function for interpreted languages, a link symbol, a file name, or just about anything else, depending on the implementation language/call convention"
::= { pgsqlPgProcEntry 17 }
pgsqlPgProcProbin OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Additional information about how to invoke the function. Again, the interpretation is language-specific"
::= { pgsqlPgProcEntry 18 }
pgsqlPgProcProacl OBJECT-TYPE
SYNTAX DisplayString
MAX-ACCESS read-only
STATUS current
DESCRIPTION
"Access privileges; see GRANT and REVOKE for details"
::= { pgsqlPgProcEntry 19 }
---------------------------------------
|
