1 /*-------------------------------------------------------------------------
4 * definition of the system "amproc" relation (pg_amproc)
5 * along with the relation's initial contents.
7 * The amproc table identifies support procedures associated with index
8 * opclasses. These procedures can't be listed in pg_amop since they are
9 * not the implementation of any indexable operator for the opclass.
11 * The primary key for this table is <amopclaid, amprocsubtype, amprocnum>.
12 * amprocsubtype is equal to zero for an opclass's "default" procedures.
13 * Usually a nondefault amprocsubtype indicates a support procedure to be
14 * used with operators having the same nondefault amopsubtype. The exact
15 * behavior depends on the index AM, however, and some don't pay attention
19 * Portions Copyright (c) 1996-2006, PostgreSQL Global Development Group
20 * Portions Copyright (c) 1994, Regents of the University of California
22 * $PostgreSQL: pgsql/src/include/catalog/pg_amproc.h,v 1.56 2006/03/05 15:58:54 momjian Exp $
25 * the genbki.sh script reads this file and generates .bki
26 * information from the DATA() statements.
28 *-------------------------------------------------------------------------
34 * postgres.h contains the system type definitions and the
35 * CATALOG(), BKI_BOOTSTRAP and DATA() sugar words so this file
36 * can be read by both genbki.sh and the C compiler.
41 * pg_amproc definition. cpp turns this into
42 * typedef struct FormData_pg_amproc
45 #define AccessMethodProcedureRelationId 2603
47 CATALOG(pg_amproc,2603) BKI_WITHOUT_OIDS
49 Oid amopclaid; /* the index opclass this entry is for */
50 Oid amprocsubtype; /* procedure subtype, or zero if default */
51 int2 amprocnum; /* support procedure index */
52 regproc amproc; /* OID of the proc */
56 * Form_pg_amproc corresponds to a pointer to a tuple with
57 * the format of pg_amproc relation.
60 typedef FormData_pg_amproc *Form_pg_amproc;
63 * compiler constants for pg_amproc
66 #define Natts_pg_amproc 4
67 #define Anum_pg_amproc_amopclaid 1
68 #define Anum_pg_amproc_amprocsubtype 2
69 #define Anum_pg_amproc_amprocnum 3
70 #define Anum_pg_amproc_amproc 4
73 * initial contents of pg_amproc
78 DATA(insert ( 397 0 1 382 ));
79 DATA(insert ( 421 0 1 357 ));
80 DATA(insert ( 423 0 1 1596 ));
81 DATA(insert ( 424 0 1 1693 ));
82 DATA(insert ( 426 0 1 1078 ));
83 DATA(insert ( 428 0 1 1954 ));
84 DATA(insert ( 429 0 1 358 ));
85 DATA(insert ( 432 0 1 926 ));
86 DATA(insert ( 434 0 1 1092 ));
87 DATA(insert ( 434 1114 1 2344 ));
88 DATA(insert ( 434 1184 1 2357 ));
89 DATA(insert ( 1970 0 1 354 ));
90 DATA(insert ( 1970 701 1 2194 ));
91 DATA(insert ( 1972 0 1 355 ));
92 DATA(insert ( 1972 700 1 2195 ));
93 DATA(insert ( 1974 0 1 926 ));
94 DATA(insert ( 1976 0 1 350 ));
95 DATA(insert ( 1976 23 1 2190 ));
96 DATA(insert ( 1976 20 1 2192 ));
97 DATA(insert ( 1978 0 1 351 ));
98 DATA(insert ( 1978 20 1 2188 ));
99 DATA(insert ( 1978 21 1 2191 ));
100 DATA(insert ( 1980 0 1 842 ));
101 DATA(insert ( 1980 23 1 2189 ));
102 DATA(insert ( 1980 21 1 2193 ));
103 DATA(insert ( 1982 0 1 1315 ));
104 DATA(insert ( 1984 0 1 836 ));
105 DATA(insert ( 1986 0 1 359 ));
106 DATA(insert ( 1988 0 1 1769 ));
107 DATA(insert ( 1989 0 1 356 ));
108 DATA(insert ( 1991 0 1 404 ));
109 DATA(insert ( 1994 0 1 360 ));
110 DATA(insert ( 1996 0 1 1107 ));
111 DATA(insert ( 1998 0 1 1314 ));
112 DATA(insert ( 1998 1082 1 2383 ));
113 DATA(insert ( 1998 1114 1 2533 ));
114 DATA(insert ( 2000 0 1 1358 ));
115 DATA(insert ( 2002 0 1 1672 ));
116 DATA(insert ( 2003 0 1 360 ));
117 DATA(insert ( 2039 0 1 2045 ));
118 DATA(insert ( 2039 1082 1 2370 ));
119 DATA(insert ( 2039 1184 1 2526 ));
120 DATA(insert ( 2095 0 1 2166 ));
121 DATA(insert ( 2096 0 1 2166 ));
122 DATA(insert ( 2097 0 1 2180 ));
123 DATA(insert ( 2098 0 1 2187 ));
124 DATA(insert ( 2099 0 1 377 ));
125 DATA(insert ( 2233 0 1 380 ));
126 DATA(insert ( 2234 0 1 381 ));
130 DATA(insert ( 427 0 1 1080 ));
131 DATA(insert ( 431 0 1 454 ));
132 DATA(insert ( 433 0 1 422 ));
133 DATA(insert ( 435 0 1 450 ));
134 DATA(insert ( 1971 0 1 451 ));
135 DATA(insert ( 1973 0 1 452 ));
136 DATA(insert ( 1975 0 1 422 ));
137 DATA(insert ( 1977 0 1 449 ));
138 DATA(insert ( 1979 0 1 450 ));
139 DATA(insert ( 1981 0 1 949 ));
140 DATA(insert ( 1983 0 1 1697 ));
141 DATA(insert ( 1985 0 1 399 ));
142 DATA(insert ( 1987 0 1 455 ));
143 DATA(insert ( 1990 0 1 453 ));
144 DATA(insert ( 1992 0 1 457 ));
145 DATA(insert ( 1995 0 1 400 ));
146 DATA(insert ( 1997 0 1 452 ));
147 DATA(insert ( 1999 0 1 452 ));
148 DATA(insert ( 2001 0 1 1696 ));
149 DATA(insert ( 2004 0 1 400 ));
150 DATA(insert ( 2040 0 1 452 ));
151 DATA(insert ( 2222 0 1 454 ));
152 DATA(insert ( 2223 0 1 456 ));
153 DATA(insert ( 2224 0 1 398 ));
154 DATA(insert ( 2225 0 1 450 ));
155 DATA(insert ( 2226 0 1 450 ));
156 DATA(insert ( 2227 0 1 450 ));
157 DATA(insert ( 2228 0 1 450 ));
158 DATA(insert ( 2229 0 1 456 ));
159 DATA(insert ( 2230 0 1 456 ));
160 DATA(insert ( 2231 0 1 456 ));
161 DATA(insert ( 2232 0 1 455 ));
162 DATA(insert ( 2235 0 1 329 ));
166 DATA(insert ( 2593 0 1 2578 ));
167 DATA(insert ( 2593 0 2 2583 ));
168 DATA(insert ( 2593 0 3 2579 ));
169 DATA(insert ( 2593 0 4 2580 ));
170 DATA(insert ( 2593 0 5 2581 ));
171 DATA(insert ( 2593 0 6 2582 ));
172 DATA(insert ( 2593 0 7 2584 ));
173 DATA(insert ( 2594 0 1 2585 ));
174 DATA(insert ( 2594 0 2 2583 ));
175 DATA(insert ( 2594 0 3 2586 ));
176 DATA(insert ( 2594 0 4 2580 ));
177 DATA(insert ( 2594 0 5 2581 ));
178 DATA(insert ( 2594 0 6 2582 ));
179 DATA(insert ( 2594 0 7 2584 ));
180 DATA(insert ( 2595 0 1 2591 ));
181 DATA(insert ( 2595 0 2 2583 ));
182 DATA(insert ( 2595 0 3 2592 ));
183 DATA(insert ( 2595 0 4 2580 ));
184 DATA(insert ( 2595 0 5 2581 ));
185 DATA(insert ( 2595 0 6 2582 ));
186 DATA(insert ( 2595 0 7 2584 ));
188 #endif /* PG_AMPROC_H */