summaryrefslogtreecommitdiff
path: root/pgsql_mib_pieces/pg_trigger.mib
blob: 3713a3a142a1ee9f51baad2b075e29e33c86da05 (plain)
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
pgsqlPgTriggerTable		OBJECT-TYPE
	SYNTAX		SEQUENCE OF pgsqlPgTriggerEntry
	MAX-ACCESS	not-accessible
	STATUS		current
	DESCRIPTION
		"The catalog pg_trigger stores triggers on tables."
	::= { pgsqlCatalogTables 32 }

pgsqlPgTriggerEntry		OBJECT-TYPE
	SYNTAX		PgsqlPgTriggerEntry
	MAX-ACCESS	not-accessible
	STATUS		current
	DESCRIPTION
		"Represents a single trigger"
	INDEX  { pgsnmpdConnID, rdbmsDbIndex, pgsqlPgTriggerEntryOID }
	::= { pgsqlPgTriggerTable 1 }

PgsqlPgTriggerEntry ::=
	SEQUENCE {
		pgsqlPgTriggerEntryOID		INTEGER,
		pgsqlPgTriggerTgrelid		INTEGER,
		pgsqlPgTriggerTgname		DisplayString,
		pgsqlPgTriggerTgfoid		INTEGER,
		pgsqlPgTriggerTgtype		INTEGER,
		pgsqlPgTriggerTgenabled		TruthValue,
		pgsqlPgTriggerTgisconstraint		TruthValue,
		pgsqlPgTriggerTgconstrname		DisplayString,
		pgsqlPgTriggerTgconstrrelid		INTEGER,
		pgsqlPgTriggerTgdeferrable		TruthValue,
		pgsqlPgTriggerTginitdeferred		TruthValue,
		pgsqlPgTriggerTgnargs		INTEGER,
		pgsqlPgTriggerTgattr		DisplayString,
		pgsqlPgTriggerTgargs		DisplayString
	}

pgsqlPgTriggerEntryOID			OBJECT-TYPE
	SYNTAX		INTEGER
	MAX-ACCESS	not-accessible
	STATUS		current
	DESCRIPTION
		"OID of this entry"
	::= { pgsqlPgTriggerEntry 1 }

pgsqlPgTriggerTgrelid			OBJECT-TYPE
	SYNTAX		INTEGER
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"The table this trigger is on"
	::= { pgsqlPgTriggerEntry 2 }

pgsqlPgTriggerTgname			OBJECT-TYPE
	SYNTAX		DisplayString
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"Trigger name (must be unique among triggers of same table)"
	::= { pgsqlPgTriggerEntry 3 }

pgsqlPgTriggerTgfoid			OBJECT-TYPE
	SYNTAX		INTEGER
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"The function to be called"
	::= { pgsqlPgTriggerEntry 4 }

pgsqlPgTriggerTgtype			OBJECT-TYPE
	SYNTAX		INTEGER
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"Bit mask identifying trigger conditions"
	::= { pgsqlPgTriggerEntry 5 }

pgsqlPgTriggerTgenabled			OBJECT-TYPE
	SYNTAX		TruthValue
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"True if trigger is enabled"
	::= { pgsqlPgTriggerEntry 6 }

pgsqlPgTriggerTgisconstraint			OBJECT-TYPE
	SYNTAX		TruthValue
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"True if trigger implements a referential integrity constraint"
	::= { pgsqlPgTriggerEntry 7 }

pgsqlPgTriggerTgconstrname			OBJECT-TYPE
	SYNTAX		DisplayString
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"Referential integrity constraint name"
	::= { pgsqlPgTriggerEntry 8 }

pgsqlPgTriggerTgconstrrelid			OBJECT-TYPE
	SYNTAX		INTEGER
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"The table referenced by an referential integrity constraint"
	::= { pgsqlPgTriggerEntry 9 }

pgsqlPgTriggerTgdeferrable			OBJECT-TYPE
	SYNTAX		TruthValue
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"True if deferrable"
	::= { pgsqlPgTriggerEntry 10 }

pgsqlPgTriggerTginitdeferred			OBJECT-TYPE
	SYNTAX		TruthValue
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"True if initially deferred"
	::= { pgsqlPgTriggerEntry 11 }

pgsqlPgTriggerTgnargs			OBJECT-TYPE
	SYNTAX		INTEGER
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"Number of argument strings passed to trigger function"
	::= { pgsqlPgTriggerEntry 12 }

pgsqlPgTriggerTgattr			OBJECT-TYPE
	SYNTAX		DisplayString
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"Currently unused"
	::= { pgsqlPgTriggerEntry 13 }

pgsqlPgTriggerTgargs			OBJECT-TYPE
	SYNTAX		DisplayString
	MAX-ACCESS	read-only
	STATUS		current
	DESCRIPTION
		"Argument strings to pass to trigger, each NULL-terminated"
	::= { pgsqlPgTriggerEntry 14 }


---------------------------------------