|
1 | 1 | <!-- |
2 | | -$Header: /cvsroot/pgsql/doc/src/sgml/ref/lock.sgml,v 1.18 2000/03/2401:20:09 momjian Exp $ |
| 2 | +$Header: /cvsroot/pgsql/doc/src/sgml/ref/lock.sgml,v 1.19 2000/03/2403:57:06 momjian Exp $ |
3 | 3 | Postgres documentation |
4 | 4 | --> |
5 | 5 |
|
@@ -33,67 +33,6 @@ LOCK [ TABLE ] <replaceable class="PARAMETER">name</replaceable> IN SHARE ROW EX |
33 | 33 | <date>1999-06-09</date> |
34 | 34 | </refsect2info> |
35 | 35 |
|
36 | | - <title> |
37 | | - Terms |
38 | | - </title> |
39 | | - <para> |
40 | | - <variablelist> |
41 | | - <varlistentry> |
42 | | - <term>EXCLUSIVE</term> |
43 | | - <listitem> |
44 | | - <para> |
45 | | -Exclusive lock that prevents other locks from being granted. |
46 | | - </para> |
47 | | - </listitem> |
48 | | - </varlistentry> |
49 | | - </variablelist> |
50 | | - |
51 | | - <variablelist> |
52 | | - <varlistentry> |
53 | | - <term>SHARE</term> |
54 | | - <listitem> |
55 | | - <para> |
56 | | -Allows others to share lock. Prevents EXCLUSIVE locks. |
57 | | - </para> |
58 | | - </listitem> |
59 | | - </varlistentry> |
60 | | - </variablelist> |
61 | | - |
62 | | - <variablelist> |
63 | | - <varlistentry> |
64 | | - <term>ACCESS</term> |
65 | | - <listitem> |
66 | | - <para> |
67 | | -Locks table schema. |
68 | | - </para> |
69 | | - </listitem> |
70 | | - </varlistentry> |
71 | | - </variablelist> |
72 | | - |
73 | | - <variablelist> |
74 | | - <varlistentry> |
75 | | - <term>ROW</term> |
76 | | - <listitem> |
77 | | - <para> |
78 | | -Locks individual rows. |
79 | | - </para> |
80 | | - </listitem> |
81 | | - </varlistentry> |
82 | | - </variablelist> |
83 | | - |
84 | | - <variablelist> |
85 | | - <varlistentry> |
86 | | - <term>Notes</term> |
87 | | - <listitem> |
88 | | - <para> |
89 | | -If EXCLUSIVE or SHARE are not specified, EXCLUSIVE is assumed. |
90 | | -Locks exist for the duration of the transaction. |
91 | | - </para> |
92 | | - </listitem> |
93 | | - </varlistentry> |
94 | | - </variablelist> |
95 | | - |
96 | | - </para> |
97 | 36 |
|
98 | 37 | <title> |
99 | 38 | Inputs |
@@ -285,6 +224,68 @@ ERROR <replaceable class="PARAMETER">name</replaceable>: Table does not exist. |
285 | 224 | <title> |
286 | 225 | Description |
287 | 226 | </title> |
| 227 | + <title> |
| 228 | + Terms |
| 229 | + </title> |
| 230 | + <para> |
| 231 | + <variablelist> |
| 232 | + <varlistentry> |
| 233 | + <term>EXCLUSIVE</term> |
| 234 | + <listitem> |
| 235 | + <para> |
| 236 | +Exclusive lock that prevents other locks from being granted. |
| 237 | + </para> |
| 238 | + </listitem> |
| 239 | + </varlistentry> |
| 240 | + </variablelist> |
| 241 | + |
| 242 | + <variablelist> |
| 243 | + <varlistentry> |
| 244 | + <term>SHARE</term> |
| 245 | + <listitem> |
| 246 | + <para> |
| 247 | +Allows others to share lock. Prevents EXCLUSIVE locks. |
| 248 | + </para> |
| 249 | + </listitem> |
| 250 | + </varlistentry> |
| 251 | + </variablelist> |
| 252 | + |
| 253 | + <variablelist> |
| 254 | + <varlistentry> |
| 255 | + <term>ACCESS</term> |
| 256 | + <listitem> |
| 257 | + <para> |
| 258 | +Locks table schema. |
| 259 | + </para> |
| 260 | + </listitem> |
| 261 | + </varlistentry> |
| 262 | + </variablelist> |
| 263 | + |
| 264 | + <variablelist> |
| 265 | + <varlistentry> |
| 266 | + <term>ROW</term> |
| 267 | + <listitem> |
| 268 | + <para> |
| 269 | +Locks individual rows. |
| 270 | + </para> |
| 271 | + </listitem> |
| 272 | + </varlistentry> |
| 273 | + </variablelist> |
| 274 | + |
| 275 | + <variablelist> |
| 276 | + <varlistentry> |
| 277 | + <term>Notes</term> |
| 278 | + <listitem> |
| 279 | + <para> |
| 280 | +If EXCLUSIVE or SHARE are not specified, EXCLUSIVE is assumed. |
| 281 | +Locks exist for the duration of the transaction. |
| 282 | + </para> |
| 283 | + </listitem> |
| 284 | + </varlistentry> |
| 285 | + </variablelist> |
| 286 | + |
| 287 | + </para> |
| 288 | + |
288 | 289 | <para> |
289 | 290 | <productname>Postgres</productname> always uses the least restrictive |
290 | 291 | lock mode whenever possible. <command>LOCK TABLE</command> |
|