I386LINUX/util/I386LINUX/doc/postgresql/html/catalog-pg-rewrite.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >pg_rewrite</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="UP"
  15 TITLE="System Catalogs"
  16 HREF="catalogs.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="pg_proc"
  19 HREF="catalog-pg-proc.html"><LINK
  20 REL="NEXT"
  21 TITLE="pg_shadow"
  22 HREF="catalog-pg-shadow.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="SECT1"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="catalog-pg-proc.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="catalogs.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 43. System Catalogs</TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="catalogs.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="catalog-pg-shadow.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><DIV
  91 CLASS="SECT1"
  92 ><H1
  93 CLASS="SECT1"
  94 ><A
  95 NAME="CATALOG-PG-REWRITE"
  96 >43.25. <TT
  97 CLASS="STRUCTNAME"
  98 >pg_rewrite</TT
  99 ></A
 100 ></H1
 101 ><A
 102 NAME="AEN51110"
 103 ></A
 104 ><P
 105 >   The catalog <TT
 106 CLASS="STRUCTNAME"
 107 >pg_rewrite</TT
 108 > stores rewrite rules for tables and views.
 109   </P
 110 ><DIV
 111 CLASS="TABLE"
 112 ><A
 113 NAME="AEN51114"
 114 ></A
 115 ><P
 116 ><B
 117 >Table 43-25. <TT
 118 CLASS="STRUCTNAME"
 119 >pg_rewrite</TT
 120 > Columns</B
 121 ></P
 122 ><TABLE
 123 BORDER="1"
 124 CLASS="CALSTABLE"
 125 ><COL><COL><COL><COL><THEAD
 126 ><TR
 127 ><TH
 128 >Name</TH
 129 ><TH
 130 >Type</TH
 131 ><TH
 132 >References</TH
 133 ><TH
 134 >Description</TH
 135 ></TR
 136 ></THEAD
 137 ><TBODY
 138 ><TR
 139 ><TD
 140 ><TT
 141 CLASS="STRUCTFIELD"
 142 >rulename</TT
 143 ></TD
 144 ><TD
 145 ><TT
 146 CLASS="TYPE"
 147 >name</TT
 148 ></TD
 149 ><TD
 150 >&nbsp;</TD
 151 ><TD
 152 >Rule name</TD
 153 ></TR
 154 ><TR
 155 ><TD
 156 ><TT
 157 CLASS="STRUCTFIELD"
 158 >ev_class</TT
 159 ></TD
 160 ><TD
 161 ><TT
 162 CLASS="TYPE"
 163 >oid</TT
 164 ></TD
 165 ><TD
 166 ><TT
 167 CLASS="LITERAL"
 168 ><A
 169 HREF="catalog-pg-class.html"
 170 ><TT
 171 CLASS="STRUCTNAME"
 172 >pg_class</TT
 173 ></A
 174 >.oid</TT
 175 ></TD
 176 ><TD
 177 >The table this rule is for</TD
 178 ></TR
 179 ><TR
 180 ><TD
 181 ><TT
 182 CLASS="STRUCTFIELD"
 183 >ev_attr</TT
 184 ></TD
 185 ><TD
 186 ><TT
 187 CLASS="TYPE"
 188 >int2</TT
 189 ></TD
 190 ><TD
 191 >&nbsp;</TD
 192 ><TD
 193 >The column this rule is for (currently, always zero to
 194       indicate the whole table)</TD
 195 ></TR
 196 ><TR
 197 ><TD
 198 ><TT
 199 CLASS="STRUCTFIELD"
 200 >ev_type</TT
 201 ></TD
 202 ><TD
 203 ><TT
 204 CLASS="TYPE"
 205 >char</TT
 206 ></TD
 207 ><TD
 208 >&nbsp;</TD
 209 ><TD
 210 >       Event type that the rule is for: 1 = <TT
 211 CLASS="COMMAND"
 212 >SELECT</TT
 213 >, 2 =
 214        <TT
 215 CLASS="COMMAND"
 216 >UPDATE</TT
 217 >, 3 = <TT
 218 CLASS="COMMAND"
 219 >INSERT</TT
 220 >, 4 =
 221        <TT
 222 CLASS="COMMAND"
 223 >DELETE</TT
 224 >
 225       </TD
 226 ></TR
 227 ><TR
 228 ><TD
 229 ><TT
 230 CLASS="STRUCTFIELD"
 231 >is_instead</TT
 232 ></TD
 233 ><TD
 234 ><TT
 235 CLASS="TYPE"
 236 >bool</TT
 237 ></TD
 238 ><TD
 239 >&nbsp;</TD
 240 ><TD
 241 >True if the rule is an <TT
 242 CLASS="LITERAL"
 243 >INSTEAD</TT
 244 > rule</TD
 245 ></TR
 246 ><TR
 247 ><TD
 248 ><TT
 249 CLASS="STRUCTFIELD"
 250 >ev_qual</TT
 251 ></TD
 252 ><TD
 253 ><TT
 254 CLASS="TYPE"
 255 >text</TT
 256 ></TD
 257 ><TD
 258 >&nbsp;</TD
 259 ><TD
 260 >       Expression tree (in the form of a
 261        <CODE
 262 CLASS="FUNCTION"
 263 >nodeToString()</CODE
 264 > representation) for the
 265        rule's qualifying condition
 266       </TD
 267 ></TR
 268 ><TR
 269 ><TD
 270 ><TT
 271 CLASS="STRUCTFIELD"
 272 >ev_action</TT
 273 ></TD
 274 ><TD
 275 ><TT
 276 CLASS="TYPE"
 277 >text</TT
 278 ></TD
 279 ><TD
 280 >&nbsp;</TD
 281 ><TD
 282 >       Query tree (in the form of a
 283        <CODE
 284 CLASS="FUNCTION"
 285 >nodeToString()</CODE
 286 > representation) for the
 287        rule's action
 288       </TD
 289 ></TR
 290 ></TBODY
 291 ></TABLE
 292 ></DIV
 293 ><DIV
 294 CLASS="NOTE"
 295 ><BLOCKQUOTE
 296 CLASS="NOTE"
 297 ><P
 298 ><B
 299 >Note: </B
 300 >    <TT
 301 CLASS="LITERAL"
 302 >pg_class.relhasrules</TT
 303 >
 304     must be true if a table has any rules in this catalog.
 305    </P
 306 ></BLOCKQUOTE
 307 ></DIV
 308 ></DIV
 309 ><DIV
 310 CLASS="NAVFOOTER"
 311 ><HR
 312 ALIGN="LEFT"
 313 WIDTH="100%"><TABLE
 314 SUMMARY="Footer navigation table"
 315 WIDTH="100%"
 316 BORDER="0"
 317 CELLPADDING="0"
 318 CELLSPACING="0"
 319 ><TR
 320 ><TD
 321 WIDTH="33%"
 322 ALIGN="left"
 323 VALIGN="top"
 324 ><A
 325 HREF="catalog-pg-proc.html"
 326 ACCESSKEY="P"
 327 >Prev</A
 328 ></TD
 329 ><TD
 330 WIDTH="34%"
 331 ALIGN="center"
 332 VALIGN="top"
 333 ><A
 334 HREF="index.html"
 335 ACCESSKEY="H"
 336 >Home</A
 337 ></TD
 338 ><TD
 339 WIDTH="33%"
 340 ALIGN="right"
 341 VALIGN="top"
 342 ><A
 343 HREF="catalog-pg-shadow.html"
 344 ACCESSKEY="N"
 345 >Next</A
 346 ></TD
 347 ></TR
 348 ><TR
 349 ><TD
 350 WIDTH="33%"
 351 ALIGN="left"
 352 VALIGN="top"
 353 ><TT
 354 CLASS="STRUCTNAME"
 355 >pg_proc</TT
 356 ></TD
 357 ><TD
 358 WIDTH="34%"
 359 ALIGN="center"
 360 VALIGN="top"
 361 ><A
 362 HREF="catalogs.html"
 363 ACCESSKEY="U"
 364 >Up</A
 365 ></TD
 366 ><TD
 367 WIDTH="33%"
 368 ALIGN="right"
 369 VALIGN="top"
 370 ><TT
 371 CLASS="STRUCTNAME"
 372 >pg_shadow</TT
 373 ></TD
 374 ></TR
 375 ></TABLE
 376 ></DIV
 377 ></BODY
 378 ></HTML
 379 >