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

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/catalog-pg-language.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:
 
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
>pg_language</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="System Catalogs"
 
16
HREF="catalogs.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="pg_inherits"
 
19
HREF="catalog-pg-inherits.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="pg_largeobject"
 
22
HREF="catalog-pg-largeobject.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="pg_inherits"
 
57
HREF="catalog-pg-inherits.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
TITLE="System Catalogs"
 
67
HREF="catalogs.html"
 
68
>Fast Backward</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
>Chapter 45. System Catalogs</TD
 
75
><TD
 
76
WIDTH="10%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="System Catalogs"
 
81
HREF="catalogs.html"
 
82
>Fast Forward</A
 
83
></TD
 
84
><TD
 
85
WIDTH="10%"
 
86
ALIGN="right"
 
87
VALIGN="top"
 
88
><A
 
89
TITLE="pg_largeobject"
 
90
HREF="catalog-pg-largeobject.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="CATALOG-PG-LANGUAGE"
 
105
>45.27. <TT
 
106
CLASS="STRUCTNAME"
 
107
>pg_language</TT
 
108
></A
 
109
></H1
 
110
><P
 
111
>   The catalog <TT
 
112
CLASS="STRUCTNAME"
 
113
>pg_language</TT
 
114
> registers
 
115
   languages in which you can write functions or stored procedures.
 
116
   See <A
 
117
HREF="sql-createlanguage.html"
 
118
>CREATE LANGUAGE</A
 
119
>
 
120
   and <A
 
121
HREF="xplang.html"
 
122
>Chapter 38</A
 
123
> for more information about language handlers.
 
124
  </P
 
125
><DIV
 
126
CLASS="TABLE"
 
127
><A
 
128
NAME="AEN86960"
 
129
></A
 
130
><P
 
131
><B
 
132
>Table 45-27. <TT
 
133
CLASS="STRUCTNAME"
 
134
>pg_language</TT
 
135
> Columns</B
 
136
></P
 
137
><TABLE
 
138
BORDER="1"
 
139
CLASS="CALSTABLE"
 
140
><COL><COL><COL><COL><THEAD
 
141
><TR
 
142
><TH
 
143
>Name</TH
 
144
><TH
 
145
>Type</TH
 
146
><TH
 
147
>References</TH
 
148
><TH
 
149
>Description</TH
 
150
></TR
 
151
></THEAD
 
152
><TBODY
 
153
><TR
 
154
><TD
 
155
><TT
 
156
CLASS="STRUCTFIELD"
 
157
>lanname</TT
 
158
></TD
 
159
><TD
 
160
><TT
 
161
CLASS="TYPE"
 
162
>name</TT
 
163
></TD
 
164
><TD
 
165
>&nbsp;</TD
 
166
><TD
 
167
>Name of the language</TD
 
168
></TR
 
169
><TR
 
170
><TD
 
171
><TT
 
172
CLASS="STRUCTFIELD"
 
173
>lanowner</TT
 
174
></TD
 
175
><TD
 
176
><TT
 
177
CLASS="TYPE"
 
178
>oid</TT
 
179
></TD
 
180
><TD
 
181
><TT
 
182
CLASS="LITERAL"
 
183
><A
 
184
HREF="catalog-pg-authid.html"
 
185
><TT
 
186
CLASS="STRUCTNAME"
 
187
>pg_authid</TT
 
188
></A
 
189
>.oid</TT
 
190
></TD
 
191
><TD
 
192
>Owner of the language</TD
 
193
></TR
 
194
><TR
 
195
><TD
 
196
><TT
 
197
CLASS="STRUCTFIELD"
 
198
>lanispl</TT
 
199
></TD
 
200
><TD
 
201
><TT
 
202
CLASS="TYPE"
 
203
>bool</TT
 
204
></TD
 
205
><TD
 
206
>&nbsp;</TD
 
207
><TD
 
208
>       This is false for internal languages (such as
 
209
       <ACRONYM
 
210
CLASS="ACRONYM"
 
211
>SQL</ACRONYM
 
212
>) and true for user-defined languages.
 
213
       Currently, <SPAN
 
214
CLASS="APPLICATION"
 
215
>pg_dump</SPAN
 
216
> still uses this
 
217
       to determine which languages need to be dumped, but this might be
 
218
       replaced by a different mechanism in the future.
 
219
      </TD
 
220
></TR
 
221
><TR
 
222
><TD
 
223
><TT
 
224
CLASS="STRUCTFIELD"
 
225
>lanpltrusted</TT
 
226
></TD
 
227
><TD
 
228
><TT
 
229
CLASS="TYPE"
 
230
>bool</TT
 
231
></TD
 
232
><TD
 
233
>&nbsp;</TD
 
234
><TD
 
235
>       True if this is a trusted language, which means that it is believed
 
236
       not to grant access to anything outside the normal SQL execution
 
237
       environment.  Only superusers can create functions in untrusted
 
238
       languages.
 
239
      </TD
 
240
></TR
 
241
><TR
 
242
><TD
 
243
><TT
 
244
CLASS="STRUCTFIELD"
 
245
>lanplcallfoid</TT
 
246
></TD
 
247
><TD
 
248
><TT
 
249
CLASS="TYPE"
 
250
>oid</TT
 
251
></TD
 
252
><TD
 
253
><TT
 
254
CLASS="LITERAL"
 
255
><A
 
256
HREF="catalog-pg-proc.html"
 
257
><TT
 
258
CLASS="STRUCTNAME"
 
259
>pg_proc</TT
 
260
></A
 
261
>.oid</TT
 
262
></TD
 
263
><TD
 
264
>       For noninternal languages this references the language
 
265
       handler, which is a special function that is responsible for
 
266
       executing all functions that are written in the particular
 
267
       language
 
268
      </TD
 
269
></TR
 
270
><TR
 
271
><TD
 
272
><TT
 
273
CLASS="STRUCTFIELD"
 
274
>laninline</TT
 
275
></TD
 
276
><TD
 
277
><TT
 
278
CLASS="TYPE"
 
279
>oid</TT
 
280
></TD
 
281
><TD
 
282
><TT
 
283
CLASS="LITERAL"
 
284
><A
 
285
HREF="catalog-pg-proc.html"
 
286
><TT
 
287
CLASS="STRUCTNAME"
 
288
>pg_proc</TT
 
289
></A
 
290
>.oid</TT
 
291
></TD
 
292
><TD
 
293
>       This references a function that is responsible for executing
 
294
       <SPAN
 
295
CLASS="QUOTE"
 
296
>"inline"</SPAN
 
297
> anonymous code blocks
 
298
       (<A
 
299
HREF="sql-do.html"
 
300
>DO</A
 
301
> blocks).
 
302
       Zero if inline blocks are not supported.
 
303
      </TD
 
304
></TR
 
305
><TR
 
306
><TD
 
307
><TT
 
308
CLASS="STRUCTFIELD"
 
309
>lanvalidator</TT
 
310
></TD
 
311
><TD
 
312
><TT
 
313
CLASS="TYPE"
 
314
>oid</TT
 
315
></TD
 
316
><TD
 
317
><TT
 
318
CLASS="LITERAL"
 
319
><A
 
320
HREF="catalog-pg-proc.html"
 
321
><TT
 
322
CLASS="STRUCTNAME"
 
323
>pg_proc</TT
 
324
></A
 
325
>.oid</TT
 
326
></TD
 
327
><TD
 
328
>       This references a language validator function that is responsible
 
329
       for checking the syntax and validity of new functions when they
 
330
       are created.  Zero if no validator is provided.
 
331
      </TD
 
332
></TR
 
333
><TR
 
334
><TD
 
335
><TT
 
336
CLASS="STRUCTFIELD"
 
337
>lanacl</TT
 
338
></TD
 
339
><TD
 
340
><TT
 
341
CLASS="TYPE"
 
342
>aclitem[]</TT
 
343
></TD
 
344
><TD
 
345
>&nbsp;</TD
 
346
><TD
 
347
>       Access privileges; see
 
348
       <A
 
349
HREF="sql-grant.html"
 
350
>GRANT</A
 
351
> and
 
352
       <A
 
353
HREF="sql-revoke.html"
 
354
>REVOKE</A
 
355
>
 
356
       for details
 
357
      </TD
 
358
></TR
 
359
></TBODY
 
360
></TABLE
 
361
></DIV
 
362
></DIV
 
363
><DIV
 
364
CLASS="NAVFOOTER"
 
365
><HR
 
366
ALIGN="LEFT"
 
367
WIDTH="100%"><TABLE
 
368
SUMMARY="Footer navigation table"
 
369
WIDTH="100%"
 
370
BORDER="0"
 
371
CELLPADDING="0"
 
372
CELLSPACING="0"
 
373
><TR
 
374
><TD
 
375
WIDTH="33%"
 
376
ALIGN="left"
 
377
VALIGN="top"
 
378
><A
 
379
HREF="catalog-pg-inherits.html"
 
380
ACCESSKEY="P"
 
381
>Prev</A
 
382
></TD
 
383
><TD
 
384
WIDTH="34%"
 
385
ALIGN="center"
 
386
VALIGN="top"
 
387
><A
 
388
HREF="index.html"
 
389
ACCESSKEY="H"
 
390
>Home</A
 
391
></TD
 
392
><TD
 
393
WIDTH="33%"
 
394
ALIGN="right"
 
395
VALIGN="top"
 
396
><A
 
397
HREF="catalog-pg-largeobject.html"
 
398
ACCESSKEY="N"
 
399
>Next</A
 
400
></TD
 
401
></TR
 
402
><TR
 
403
><TD
 
404
WIDTH="33%"
 
405
ALIGN="left"
 
406
VALIGN="top"
 
407
><TT
 
408
CLASS="STRUCTNAME"
 
409
>pg_inherits</TT
 
410
></TD
 
411
><TD
 
412
WIDTH="34%"
 
413
ALIGN="center"
 
414
VALIGN="top"
 
415
><A
 
416
HREF="catalogs.html"
 
417
ACCESSKEY="U"
 
418
>Up</A
 
419
></TD
 
420
><TD
 
421
WIDTH="33%"
 
422
ALIGN="right"
 
423
VALIGN="top"
 
424
><TT
 
425
CLASS="STRUCTNAME"
 
426
>pg_largeobject</TT
 
427
></TD
 
428
></TR
 
429
></TABLE
 
430
></DIV
 
431
></BODY
 
432
></HTML
 
433
>
 
 
b'\\ No newline at end of file'