Skip to content

Commit 2d7b93c

Browse files
vadim4ovadim4o
committed
Welcome, triggers
1 parent 6a061da commit 2d7b93c

File tree

5 files changed

+153
-30
lines changed

5 files changed

+153
-30
lines changed

‎src/include/catalog/indexing.h

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
*
88
* Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: indexing.h,v 1.3 1997/08/21 01:37:48 vadim Exp $
10+
* $Id: indexing.h,v 1.4 1997/08/31 09:55:20 vadim Exp $
1111
*
1212
*-------------------------------------------------------------------------
1313
*/
@@ -26,6 +26,7 @@
2626
#define Num_pg_class_indices 2
2727
#define Num_pg_attrdef_indices 1
2828
#define Num_pg_relcheck_indices 1
29+
#define Num_pg_trigger_indices 1
2930

3031

3132
/*
@@ -43,13 +44,15 @@
4344
#define ClassOidIndex "pg_classoidind"
4445
#define AttrDefaultIndex "pg_attrdefind"
4546
#define RelCheckIndex "pg_relcheckind"
47+
#define TriggerRelidIndex "pg_trigrelidind"
4648

4749
extern char *Name_pg_attr_indices[];
4850
extern char *Name_pg_proc_indices[];
4951
extern char *Name_pg_type_indices[];
5052
extern char *Name_pg_class_indices[];
5153
extern char *Name_pg_attrdef_indices[];
5254
extern char *Name_pg_relcheck_indices[];
55+
extern char *Name_pg_trigger_indices[];
5356

5457
extern char *IndexedCatalogNames[];
5558

@@ -107,6 +110,8 @@ DECLARE_INDEX(pg_classoidind on pg_class using btree (Oid oid_ops));
107110
DECLARE_INDEX(pg_attrdefind on pg_attrdef using btree (adrelid oid_ops));
108111
DECLARE_INDEX(pg_relcheckind on pg_relcheck using btree (rcrelid oid_ops));
109112

113+
DECLARE_INDEX(pg_trigrelidind on pg_trigger using btree (tgrelid oid_ops));
114+
110115
/* now build indices in the initialization scripts */
111116
BUILD_INDICES
112117

‎src/include/catalog/pg_attribute.h

Lines changed: 34 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
*
88
* Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: pg_attribute.h,v 1.12 1997/08/22 04:04:18 vadim Exp $
10+
* $Id: pg_attribute.h,v 1.13 1997/08/31 09:55:21 vadim Exp $
1111
*
1212
* NOTES
1313
* the genbki.sh script reads this file and generates .bki
@@ -417,9 +417,10 @@ DATA(insert OID = 0 ( 1249 vtype 18 0 1 -11 0 -1 t f c f f));
417417
{ 1259l, {"relarch"}, 18, 0l, 1, 11, 0l, -1l, '\001', '\0', 'c', '\0', '\0' }, \
418418
{ 1259l, {"relnatts"}, 21, 0l, 2, 12, 0l, -1l, '\001', '\0', 's', '\0', '\0' }, \
419419
{ 1259l, {"relsmgr"}, 210l, 0l, 2, 13, 0l, -1l, '\001', '\0', 's', '\0', '\0' }, \
420-
{ 1259l, {"relchecks"}, 21l, 0l, 2, 14, 0l, -1l, '\001', '\0', 's', '\0', '\0' }, \
421-
{ 1259l, {"relhasrules"}, 16, 0l, 1, 15, 0l, -1l, '\001', '\0', 'c', '\0', '\0' }, \
422-
{ 1259l, {"relacl"}, 1034l, 0l, -1, 16, 0l, -1l, '\0', '\0', 'i', '\0', '\0' }
420+
{ 1259l, {"relchecks"}, 21l, 0l, 2, 14, 0l, -1l, '\001', '\0', 's', '\0', '\0' }, \
421+
{ 1259l, {"reltriggers"}, 21l, 0l, 2, 15, 0l, -1l, '\001', '\0', 's', '\0', '\0' }, \
422+
{ 1259l, {"relhasrules"}, 16, 0l, 1, 16, 0l, -1l, '\001', '\0', 'c', '\0', '\0' }, \
423+
{ 1259l, {"relacl"}, 1034l, 0l, -1, 17, 0l, -1l, '\0', '\0', 'i', '\0', '\0' }
423424

424425
DATA(insert OID = 0 ( 1259 relname 19 0 NAMEDATALEN 1 0 -1 f f i f f));
425426
DATA(insert OID = 0 ( 1259 reltype 26 0 4 2 0 -1 t f i f f));
@@ -436,8 +437,9 @@ DATA(insert OID = 0 ( 1259 relarch 18 0 1 11 0 -1 t f c f f));
436437
DATA(insert OID = 0 ( 1259 relnatts 21 0 2 12 0 -1 t f s f f));
437438
DATA(insert OID = 0 ( 1259 relsmgr 210 0 2 13 0 -1 t f s f f));
438439
DATA(insert OID = 0 ( 1259 relchecks 21 0 2 14 0 -1 t f s f f));
439-
DATA(insert OID = 0 ( 1259 relhasrules 16 0 1 15 0 -1 t f c f f));
440-
DATA(insert OID = 0 ( 1259 relacl 1034 0 -1 16 0 -1 f f i f f));
440+
DATA(insert OID = 0 ( 1259 reltriggers 21 0 2 15 0 -1 t f s f f));
441+
DATA(insert OID = 0 ( 1259 relhasrules 16 0 1 16 0 -1 t f c f f));
442+
DATA(insert OID = 0 ( 1259 relacl 1034 0 -1 17 0 -1 f f i f f));
441443
DATA(insert OID = 0 ( 1259 ctid 27 0 6 -1 0 -1 f f i f f));
442444
DATA(insert OID = 0 ( 1259 oid 26 0 4 -2 0 -1 t f i f f));
443445
DATA(insert OID = 0 ( 1259 xmin 28 0 4 -3 0 -1 f f i f f));
@@ -526,6 +528,32 @@ DATA(insert OID = 0 ( 1216 tmin 702 0 4 -9 0 -1 t f i f f));
526528
DATA(insert OID = 0 ( 1216 tmax 702 0 4 -10 0 -1 t f i f f));
527529
DATA(insert OID = 0 ( 1216 vtype 18 0 1 -11 0 -1 t f c f f));
528530

531+
/* ----------------
532+
* pg_trigger
533+
* ----------------
534+
*/
535+
DATA(insert OID = 0 ( 1219 tgrelid 26 0 4 1 0 -1 t f i f f));
536+
DATA(insert OID = 0 ( 1219 tgname 19 0 NAMEDATALEN 2 0 -1 f f i f f));
537+
DATA(insert OID = 0 ( 1219 tgfunc 19 0 NAMEDATALEN 3 0 -1 f f i f f));
538+
DATA(insert OID = 0 ( 1219 tglang 26 0 4 4 0 -1 t f i f f));
539+
DATA(insert OID = 0 ( 1219 tgtype 21 0 2 5 0 -1 t f s f f));
540+
DATA(insert OID = 0 ( 1219 tgnargs 21 0 2 6 0 -1 t f s f f));
541+
DATA(insert OID = 0 ( 1219 tgattr 22 0 16 7 0 -1 f f i f f));
542+
DATA(insert OID = 0 ( 1219 tgtext 17 0 -1 8 0 -1 f f i f f));
543+
DATA(insert OID = 0 ( 1219 tgargs 17 0 -1 9 0 -1 f f i f f));
544+
DATA(insert OID = 0 ( 1219 tgwhen 25 0 -1 10 0 -1 f f i f f));
545+
DATA(insert OID = 0 ( 1219 ctid 27 0 6 -1 0 -1 f f i f f));
546+
DATA(insert OID = 0 ( 1219 oid 26 0 4 -2 0 -1 t f i f f));
547+
DATA(insert OID = 0 ( 1219 xmin 28 0 4 -3 0 -1 f f i f f));
548+
DATA(insert OID = 0 ( 1219 cmin 29 0 2 -4 0 -1 t f s f f));
549+
DATA(insert OID = 0 ( 1219 xmax 28 0 4 -5 0 -1 f f i f f));
550+
DATA(insert OID = 0 ( 1219 cmax 29 0 2 -6 0 -1 t f s f f));
551+
DATA(insert OID = 0 ( 1219 chain 27 0 6 -7 0 -1 f f i f f));
552+
DATA(insert OID = 0 ( 1219 anchor 27 0 6 -8 0 -1 f f i f f));
553+
DATA(insert OID = 0 ( 1219 tmin 702 0 4 -9 0 -1 t f i f f));
554+
DATA(insert OID = 0 ( 1219 tmax 702 0 4 -10 0 -1 t f i f f));
555+
DATA(insert OID = 0 ( 1219 vtype 18 0 1 -11 0 -1 t f c f f));
556+
529557
/* ----------------
530558
* pg_hosts - this relation is used to store host based authentication
531559
* info

‎src/include/catalog/pg_class.h

Lines changed: 26 additions & 22 deletions
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
*
88
* Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: pg_class.h,v 1.7 1997/08/22 04:04:19 vadim Exp $
10+
* $Id: pg_class.h,v 1.8 1997/08/31 09:55:22 vadim Exp $
1111
*
1212
* NOTES
1313
* ``pg_relation'' is being replaced by ``pg_class''. currently
@@ -70,6 +70,7 @@ CATALOG(pg_class) BOOTSTRAP {
7070
*/
7171
int2 relsmgr;
7272
int2 relchecks; /* # of CHECK constraints */
73+
int2 reltriggers; /* # of TRIGGERs */
7374
bool relhasrules;
7475
aclitem relacl[1]; /* this is here for the catalog */
7576
} FormData_pg_class;
@@ -95,8 +96,8 @@ typedef FormData_pg_class *Form_pg_class;
9596
* relacl field.
9697
* ----------------
9798
*/
98-
#define Natts_pg_class_fixed 16
99-
#define Natts_pg_class 17
99+
#define Natts_pg_class_fixed 17
100+
#define Natts_pg_class 18
100101
#define Anum_pg_class_relname 1
101102
#define Anum_pg_class_reltype 2
102103
#define Anum_pg_class_relowner 3
@@ -112,31 +113,33 @@ typedef FormData_pg_class *Form_pg_class;
112113
#define Anum_pg_class_relnatts 13
113114
#define Anum_pg_class_relsmgr 14
114115
#define Anum_pg_class_relchecks 15
115-
#define Anum_pg_class_relhasrules 16
116-
#define Anum_pg_class_relacl 17
116+
#define Anum_pg_class_reltriggers 16
117+
#define Anum_pg_class_relhasrules 17
118+
#define Anum_pg_class_relacl 18
117119

118120
/* ----------------
119121
* initial contents of pg_class
120122
* ----------------
121123
*/
122124

123-
DATA(insert OID = 1247 ( pg_type 71 PGUID 0 0 0 0 0 f f r n 16 0 0 f _null_ ));
124-
DATA(insert OID = 1249 ( pg_attribute 75 PGUID 0 0 0 0 0 f f r n 16 0 0 f _null_ ));
125-
DATA(insert OID = 1251 ( pg_demon 76 PGUID 0 0 0 0 0 f t r n 4 0 0 f _null_ ));
126-
DATA(insert OID = 1253 ( pg_magic 80 PGUID 0 0 0 0 0 f t r n 2 0 0 f _null_ ));
127-
DATA(insert OID = 1255 ( pg_proc 81 PGUID 0 0 0 0 0 f f r n 16 0 0 f _null_ ));
128-
DATA(insert OID = 1257 ( pg_server 82 PGUID 0 0 0 0 0 f t r n 3 0 0 f _null_ ));
129-
DATA(insert OID = 1259 ( pg_class 83 PGUID 0 0 0 0 0 f f r n 18 0 0 f _null_ ));
130-
DATA(insert OID = 1260 ( pg_user 86 PGUID 0 0 0 0 0 f t r n 6 0 0 f _null_ ));
131-
DATA(insert OID = 1261 ( pg_group 87 PGUID 0 0 0 0 0 f t s n 3 0 0 f _null_ ));
132-
DATA(insert OID = 1262 ( pg_database 88 PGUID 0 0 0 0 0 f t r n 3 0 0 f _null_ ));
133-
DATA(insert OID = 1263 ( pg_defaults 89 PGUID 0 0 0 0 0 f t r n 2 0 0 f _null_ ));
134-
DATA(insert OID = 1264 ( pg_variable 90 PGUID 0 0 0 0 0 f t s n 2 0 0 f _null_ ));
135-
DATA(insert OID = 1269 ( pg_log 99 PGUID 0 0 0 0 0 f t s n 1 0 0 f _null_ ));
136-
DATA(insert OID = 1271 ( pg_time 100 PGUID 0 0 0 0 0 f t s n 1 0 0 f _null_ ));
137-
DATA(insert OID = 1273 ( pg_hosts 101 PGUID 0 0 0 0 0 f t s n 3 0 0 f _null_ ));
138-
DATA(insert OID = 1215 ( pg_attrdef 109 PGUID 0 0 0 0 0 t t r n 4 0 0 f _null_ ));
139-
DATA(insert OID = 1216 ( pg_relcheck 110 PGUID 0 0 0 0 0 t t r n 4 0 0 f _null_ ));
125+
DATA(insert OID = 1247 ( pg_type 71 PGUID 0 0 0 0 0 f f r n 16 0 0 0 f _null_ ));
126+
DATA(insert OID = 1249 ( pg_attribute 75 PGUID 0 0 0 0 0 f f r n 16 0 0 0 f _null_ ));
127+
DATA(insert OID = 1251 ( pg_demon 76 PGUID 0 0 0 0 0 f t r n 4 0 0 0 f _null_ ));
128+
DATA(insert OID = 1253 ( pg_magic 80 PGUID 0 0 0 0 0 f t r n 2 0 0 0 f _null_ ));
129+
DATA(insert OID = 1255 ( pg_proc 81 PGUID 0 0 0 0 0 f f r n 16 0 0 0 f _null_ ));
130+
DATA(insert OID = 1257 ( pg_server 82 PGUID 0 0 0 0 0 f t r n 3 0 0 0 f _null_ ));
131+
DATA(insert OID = 1259 ( pg_class 83 PGUID 0 0 0 0 0 f f r n 18 0 0 0 f _null_ ));
132+
DATA(insert OID = 1260 ( pg_user 86 PGUID 0 0 0 0 0 f t r n 6 0 0 0 f _null_ ));
133+
DATA(insert OID = 1261 ( pg_group 87 PGUID 0 0 0 0 0 f t s n 3 0 0 0 f _null_ ));
134+
DATA(insert OID = 1262 ( pg_database 88 PGUID 0 0 0 0 0 f t r n 3 0 0 0 f _null_ ));
135+
DATA(insert OID = 1263 ( pg_defaults 89 PGUID 0 0 0 0 0 f t r n 2 0 0 0 f _null_ ));
136+
DATA(insert OID = 1264 ( pg_variable 90 PGUID 0 0 0 0 0 f t s n 2 0 0 0 f _null_ ));
137+
DATA(insert OID = 1269 ( pg_log 99 PGUID 0 0 0 0 0 f t s n 1 0 0 0 f _null_ ));
138+
DATA(insert OID = 1271 ( pg_time 100 PGUID 0 0 0 0 0 f t s n 1 0 0 0 f _null_ ));
139+
DATA(insert OID = 1273 ( pg_hosts 101 PGUID 0 0 0 0 0 f t s n 3 0 0 0 f _null_ ));
140+
DATA(insert OID = 1215 ( pg_attrdef 109 PGUID 0 0 0 0 0 t t r n 4 0 0 0 f _null_ ));
141+
DATA(insert OID = 1216 ( pg_relcheck 110 PGUID 0 0 0 0 0 t t r n 4 0 0 0 f _null_ ));
142+
DATA(insert OID = 1219 ( pg_trigger 111 PGUID 0 0 0 0 0 t t r n 10 0 0 0 f _null_ ));
140143

141144
#define RelOid_pg_type 1247
142145
#define RelOid_pg_demon 1251
@@ -155,6 +158,7 @@ DATA(insert OID = 1216 ( pg_relcheck 110 PGUID 0 0 0 0 0 t t r n 4 0 0 f _n
155158
#define RelOid_pg_hosts 1273
156159
#define RelOid_pg_attrdef 1215
157160
#define RelOid_pg_relcheck 1216
161+
#define RelOid_pg_trigger 1219
158162

159163
#define MAX_SYSTEM_RELOID 1273 /* this does not seem to be used */
160164
/* anywhere */

‎src/include/catalog/pg_trigger.h

Lines changed: 85 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,85 @@
1+
/*-------------------------------------------------------------------------
2+
*
3+
* pg_trigger.h--
4+
*
5+
*
6+
* Copyright (c) 1994, Regents of the University of California
7+
*
8+
* NOTES
9+
* the genbki.sh script reads this file and generates .bki
10+
* information from the DATA() statements.
11+
*
12+
*-------------------------------------------------------------------------
13+
*/
14+
#ifndef PG_TRIGGER_H
15+
#define PG_TRIGGER_H
16+
17+
/* ----------------
18+
* postgres.h contains the system type definintions and the
19+
* CATALOG(), BOOTSTRAP and DATA() sugar words so this file
20+
* can be read by both genbki.sh and the C compiler.
21+
* ----------------
22+
*/
23+
24+
/* ----------------
25+
* pg_trigger definition. cpp turns this into
26+
* typedef struct FormData_pg_trigger
27+
* ----------------
28+
*/
29+
CATALOG(pg_trigger) BOOTSTRAP {
30+
Oid tgrelid; /* triggered relation */
31+
NameData tgname; /* trigger' name */
32+
NameData tgfunc; /* name of function to be called */
33+
Oid tglang; /* Language. Only ClanguageId currently */
34+
int2 tgtype; /* BEFORE/AFTER UPDATE/DELETE/INSERT ROW/STATEMENT */
35+
int2 tgnargs; /* # of extra arguments in tgargs */
36+
int28 tgattr; /* UPDATE of attr1, attr2 ... (NI) */
37+
bytea tgtext; /* currently, where to find .so */
38+
bytea tgargs; /* first\000second\000tgnargs\000 */
39+
text tgwhen; /* when (a > 10 or b = 3) fire trigger (NI) */
40+
} FormData_pg_trigger;
41+
42+
/* ----------------
43+
* Form_pg_trigger corresponds to a pointer to a tuple with
44+
* the format of pg_trigger relation.
45+
* ----------------
46+
*/
47+
typedef FormData_pg_trigger *Form_pg_trigger;
48+
49+
/* ----------------
50+
* compiler constants for pg_trigger
51+
* ----------------
52+
*/
53+
#define Natts_pg_trigger 10
54+
#define Anum_pg_trigger_tgrelid 1
55+
#define Anum_pg_trigger_tgname 2
56+
#define Anum_pg_trigger_tgfunc 3
57+
#define Anum_pg_trigger_tglang 4
58+
#define Anum_pg_trigger_tgtype 5
59+
#define Anum_pg_trigger_tgnargs 6
60+
#define Anum_pg_trigger_tgattr 7
61+
#define Anum_pg_trigger_tgtext 8
62+
#define Anum_pg_trigger_tgargs 9
63+
#define Anum_pg_trigger_tgwhen 10
64+
65+
#define TRIGGER_TYPE_ROW (1 << 0)
66+
#define TRIGGER_TYPE_BEFORE (1 << 1)
67+
#define TRIGGER_TYPE_INSERT (1 << 2)
68+
#define TRIGGER_TYPE_DELETE (1 << 3)
69+
#define TRIGGER_TYPE_UPDATE (1 << 4)
70+
71+
#define TRIGGER_CLEAR_TYPE(type) (type = 0)
72+
73+
#define TRIGGER_SETT_ROW(type) (type |= TRIGGER_TYPE_ROW)
74+
#define TRIGGER_SETT_BEFORE(type) (type |= TRIGGER_TYPE_BEFORE)
75+
#define TRIGGER_SETT_INSERT(type) (type |= TRIGGER_TYPE_INSERT)
76+
#define TRIGGER_SETT_DELETE(type) (type |= TRIGGER_TYPE_DELETE)
77+
#define TRIGGER_SETT_UPDATE(type) (type |= TRIGGER_TYPE_UPDATE)
78+
79+
#define TRIGGER_FOR_ROW(type) (type & TRIGGER_TYPE_ROW)
80+
#define TRIGGER_FOR_BEFORE(type) (type & TRIGGER_TYPE_BEFORE)
81+
#define TRIGGER_FOR_INSERT(type) (type & TRIGGER_TYPE_INSERT)
82+
#define TRIGGER_FOR_DELETE(type) (type & TRIGGER_TYPE_DELETE)
83+
#define TRIGGER_FOR_UPDATE(type) (type & TRIGGER_TYPE_UPDATE)
84+
85+
#endif /* PG_TRIGGER_H */

‎src/include/catalog/pg_type.h

Lines changed: 2 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -7,7 +7,7 @@
77
*
88
* Copyright (c) 1994, Regents of the University of California
99
*
10-
* $Id: pg_type.h,v 1.15 1997/08/22 00:02:19 momjian Exp $
10+
* $Id: pg_type.h,v 1.16 1997/08/31 09:55:24 vadim Exp $
1111
*
1212
* NOTES
1313
* the genbki.sh script reads this file and generates .bki
@@ -202,6 +202,7 @@ DATA(insert OID = 100 ( pg_time PGUID 1 1 t b t \054 1271 0 foo bar foo bar
202202
DATA(insert OID = 101 ( pg_hosts PGUID 1 1 t b t \054 1273 0 foo bar foo bar c _null_));
203203
DATA(insert OID = 109 ( pg_attrdef PGUID 1 1 t b t \054 1215 0 foo bar foo bar c _null_));
204204
DATA(insert OID = 110 ( pg_relcheck PGUID 1 1 t b t \054 1216 0 foo bar foo bar c _null_));
205+
DATA(insert OID = 111 ( pg_trigger PGUID 1 1 t b t \054 1219 0 foo bar foo bar c _null_));
205206

206207
/* OIDS 200 - 299 */
207208

0 commit comments

Comments
 (0)