← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/infoschema-referential-constraints.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/infoschema-referential-constraints.html
 
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
2
<HTML
 
3
><HEAD
 
4
><TITLE
 
5
>referential_constraints</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REV="MADE"
 
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
 
11
REL="HOME"
 
12
TITLE="PostgreSQL 9.1beta1 Documentation"
 
13
HREF="index.html"><LINK
 
14
REL="UP"
 
15
TITLE="The Information Schema"
 
16
HREF="information-schema.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="parameters"
 
19
HREF="infoschema-parameters.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="role_column_grants"
 
22
HREF="infoschema-role-column-grants.html"><LINK
 
23
REL="STYLESHEET"
 
24
TYPE="text/css"
 
25
HREF="stylesheet.css"><META
 
26
HTTP-EQUIV="Content-Type"
 
27
CONTENT="text/html; charset=ISO-8859-1"><META
 
28
NAME="creation"
 
29
CONTENT="2011-04-27T21:20:33"></HEAD
 
30
><BODY
 
31
CLASS="SECT1"
 
32
><DIV
 
33
CLASS="NAVHEADER"
 
34
><TABLE
 
35
SUMMARY="Header navigation table"
 
36
WIDTH="100%"
 
37
BORDER="0"
 
38
CELLPADDING="0"
 
39
CELLSPACING="0"
 
40
><TR
 
41
><TH
 
42
COLSPAN="5"
 
43
ALIGN="center"
 
44
VALIGN="bottom"
 
45
><A
 
46
HREF="index.html"
 
47
>PostgreSQL 9.1beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="parameters"
 
57
HREF="infoschema-parameters.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
TITLE="The Information Schema"
 
67
HREF="information-schema.html"
 
68
>Fast Backward</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
>Chapter 34. The Information Schema</TD
 
75
><TD
 
76
WIDTH="10%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="The Information Schema"
 
81
HREF="information-schema.html"
 
82
>Fast Forward</A
 
83
></TD
 
84
><TD
 
85
WIDTH="10%"
 
86
ALIGN="right"
 
87
VALIGN="top"
 
88
><A
 
89
TITLE="role_column_grants"
 
90
HREF="infoschema-role-column-grants.html"
 
91
ACCESSKEY="N"
 
92
>Next</A
 
93
></TD
 
94
></TR
 
95
></TABLE
 
96
><HR
 
97
ALIGN="LEFT"
 
98
WIDTH="100%"></DIV
 
99
><DIV
 
100
CLASS="SECT1"
 
101
><H1
 
102
CLASS="SECT1"
 
103
><A
 
104
NAME="INFOSCHEMA-REFERENTIAL-CONSTRAINTS"
 
105
>34.32. <TT
 
106
CLASS="LITERAL"
 
107
>referential_constraints</TT
 
108
></A
 
109
></H1
 
110
><P
 
111
>   The view <TT
 
112
CLASS="LITERAL"
 
113
>referential_constraints</TT
 
114
> contains all
 
115
   referential (foreign key) constraints in the current database.
 
116
   Only those constraints are shown for which the current user has
 
117
   write access to the referencing table (by way of being the
 
118
   owner or having some privilege other than SELECT).
 
119
  </P
 
120
><DIV
 
121
CLASS="TABLE"
 
122
><A
 
123
NAME="AEN46927"
 
124
></A
 
125
><P
 
126
><B
 
127
>Table 34-30. <TT
 
128
CLASS="LITERAL"
 
129
>referential_constraints</TT
 
130
> Columns</B
 
131
></P
 
132
><TABLE
 
133
BORDER="1"
 
134
CLASS="CALSTABLE"
 
135
><COL><COL><COL><THEAD
 
136
><TR
 
137
><TH
 
138
>Name</TH
 
139
><TH
 
140
>Data Type</TH
 
141
><TH
 
142
>Description</TH
 
143
></TR
 
144
></THEAD
 
145
><TBODY
 
146
><TR
 
147
><TD
 
148
><TT
 
149
CLASS="LITERAL"
 
150
>constraint_catalog</TT
 
151
></TD
 
152
><TD
 
153
><TT
 
154
CLASS="LITERAL"
 
155
>sql_identifier</TT
 
156
></TD
 
157
><TD
 
158
>Name of the database containing the constraint (always the current database)</TD
 
159
></TR
 
160
><TR
 
161
><TD
 
162
><TT
 
163
CLASS="LITERAL"
 
164
>constraint_schema</TT
 
165
></TD
 
166
><TD
 
167
><TT
 
168
CLASS="LITERAL"
 
169
>sql_identifier</TT
 
170
></TD
 
171
><TD
 
172
>Name of the schema containing the constraint</TD
 
173
></TR
 
174
><TR
 
175
><TD
 
176
><TT
 
177
CLASS="LITERAL"
 
178
>constraint_name</TT
 
179
></TD
 
180
><TD
 
181
><TT
 
182
CLASS="LITERAL"
 
183
>sql_identifier</TT
 
184
></TD
 
185
><TD
 
186
>Name of the constraint</TD
 
187
></TR
 
188
><TR
 
189
><TD
 
190
><TT
 
191
CLASS="LITERAL"
 
192
>unique_constraint_catalog</TT
 
193
></TD
 
194
><TD
 
195
><TT
 
196
CLASS="LITERAL"
 
197
>sql_identifier</TT
 
198
></TD
 
199
><TD
 
200
>       Name of the database that contains the unique or primary key
 
201
       constraint that the foreign key constraint references (always
 
202
       the current database)
 
203
      </TD
 
204
></TR
 
205
><TR
 
206
><TD
 
207
><TT
 
208
CLASS="LITERAL"
 
209
>unique_constraint_schema</TT
 
210
></TD
 
211
><TD
 
212
><TT
 
213
CLASS="LITERAL"
 
214
>sql_identifier</TT
 
215
></TD
 
216
><TD
 
217
>       Name of the schema that contains the unique or primary key
 
218
       constraint that the foreign key constraint references
 
219
      </TD
 
220
></TR
 
221
><TR
 
222
><TD
 
223
><TT
 
224
CLASS="LITERAL"
 
225
>unique_constraint_name</TT
 
226
></TD
 
227
><TD
 
228
><TT
 
229
CLASS="LITERAL"
 
230
>sql_identifier</TT
 
231
></TD
 
232
><TD
 
233
>       Name of the unique or primary key constraint that the foreign
 
234
       key constraint references
 
235
      </TD
 
236
></TR
 
237
><TR
 
238
><TD
 
239
><TT
 
240
CLASS="LITERAL"
 
241
>match_option</TT
 
242
></TD
 
243
><TD
 
244
><TT
 
245
CLASS="LITERAL"
 
246
>character_data</TT
 
247
></TD
 
248
><TD
 
249
>       Match option of the foreign key constraint:
 
250
       <TT
 
251
CLASS="LITERAL"
 
252
>FULL</TT
 
253
>, <TT
 
254
CLASS="LITERAL"
 
255
>PARTIAL</TT
 
256
>, or
 
257
       <TT
 
258
CLASS="LITERAL"
 
259
>NONE</TT
 
260
>.
 
261
      </TD
 
262
></TR
 
263
><TR
 
264
><TD
 
265
><TT
 
266
CLASS="LITERAL"
 
267
>update_rule</TT
 
268
></TD
 
269
><TD
 
270
><TT
 
271
CLASS="LITERAL"
 
272
>character_data</TT
 
273
></TD
 
274
><TD
 
275
>       Update rule of the foreign key constraint:
 
276
       <TT
 
277
CLASS="LITERAL"
 
278
>CASCADE</TT
 
279
>, <TT
 
280
CLASS="LITERAL"
 
281
>SET NULL</TT
 
282
>,
 
283
       <TT
 
284
CLASS="LITERAL"
 
285
>SET DEFAULT</TT
 
286
>, <TT
 
287
CLASS="LITERAL"
 
288
>RESTRICT</TT
 
289
>, or
 
290
       <TT
 
291
CLASS="LITERAL"
 
292
>NO ACTION</TT
 
293
>.
 
294
      </TD
 
295
></TR
 
296
><TR
 
297
><TD
 
298
><TT
 
299
CLASS="LITERAL"
 
300
>delete_rule</TT
 
301
></TD
 
302
><TD
 
303
><TT
 
304
CLASS="LITERAL"
 
305
>character_data</TT
 
306
></TD
 
307
><TD
 
308
>       Delete rule of the foreign key constraint:
 
309
       <TT
 
310
CLASS="LITERAL"
 
311
>CASCADE</TT
 
312
>, <TT
 
313
CLASS="LITERAL"
 
314
>SET NULL</TT
 
315
>,
 
316
       <TT
 
317
CLASS="LITERAL"
 
318
>SET DEFAULT</TT
 
319
>, <TT
 
320
CLASS="LITERAL"
 
321
>RESTRICT</TT
 
322
>, or
 
323
       <TT
 
324
CLASS="LITERAL"
 
325
>NO ACTION</TT
 
326
>.
 
327
      </TD
 
328
></TR
 
329
></TBODY
 
330
></TABLE
 
331
></DIV
 
332
></DIV
 
333
><DIV
 
334
CLASS="NAVFOOTER"
 
335
><HR
 
336
ALIGN="LEFT"
 
337
WIDTH="100%"><TABLE
 
338
SUMMARY="Footer navigation table"
 
339
WIDTH="100%"
 
340
BORDER="0"
 
341
CELLPADDING="0"
 
342
CELLSPACING="0"
 
343
><TR
 
344
><TD
 
345
WIDTH="33%"
 
346
ALIGN="left"
 
347
VALIGN="top"
 
348
><A
 
349
HREF="infoschema-parameters.html"
 
350
ACCESSKEY="P"
 
351
>Prev</A
 
352
></TD
 
353
><TD
 
354
WIDTH="34%"
 
355
ALIGN="center"
 
356
VALIGN="top"
 
357
><A
 
358
HREF="index.html"
 
359
ACCESSKEY="H"
 
360
>Home</A
 
361
></TD
 
362
><TD
 
363
WIDTH="33%"
 
364
ALIGN="right"
 
365
VALIGN="top"
 
366
><A
 
367
HREF="infoschema-role-column-grants.html"
 
368
ACCESSKEY="N"
 
369
>Next</A
 
370
></TD
 
371
></TR
 
372
><TR
 
373
><TD
 
374
WIDTH="33%"
 
375
ALIGN="left"
 
376
VALIGN="top"
 
377
><TT
 
378
CLASS="LITERAL"
 
379
>parameters</TT
 
380
></TD
 
381
><TD
 
382
WIDTH="34%"
 
383
ALIGN="center"
 
384
VALIGN="top"
 
385
><A
 
386
HREF="information-schema.html"
 
387
ACCESSKEY="U"
 
388
>Up</A
 
389
></TD
 
390
><TD
 
391
WIDTH="33%"
 
392
ALIGN="right"
 
393
VALIGN="top"
 
394
><TT
 
395
CLASS="LITERAL"
 
396
>role_column_grants</TT
 
397
></TD
 
398
></TR
 
399
></TABLE
 
400
></DIV
 
401
></BODY
 
402
></HTML
 
403
>
 
 
b'\\ No newline at end of file'