1
1
<!--
2
- $Header: /cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v 2.22 2002/01/20 22:19:56 petere Exp $
2
+ $Header: /cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v 2.23 2002/02/18 16:13:10 tgl Exp $
3
3
-->
4
4
5
5
<chapter id="mvcc">
@@ -40,7 +40,7 @@ $Header: /cvsroot/pgsql/doc/src/sgml/mvcc.sgml,v 2.22 2002/01/20 22:19:56 petere
40
40
<para>
41
41
The main difference between multiversion and lock models is that
42
42
in MVCC locks acquired for querying (reading) data don't conflict
43
- with locks acquired for writing data and so reading never blocks
43
+ with locks acquired for writing data, and so reading never blocks
44
44
writing and writing never blocks reading.
45
45
</para>
46
46
</sect1>
@@ -415,7 +415,7 @@ ERROR: Can't serialize access due to concurrent update
415
415
<para>
416
416
Acquired by <command>SELECT FOR UPDATE</command>
417
417
and <command>LOCK TABLE</command>
418
- for <option>IN ROW SHARE MODE</option> statements.
418
+ <option>IN ROW SHARE MODE</option> statements.
419
419
</para>
420
420
421
421
<para>
@@ -432,7 +432,7 @@ ERROR: Can't serialize access due to concurrent update
432
432
<para>
433
433
Acquired by <command>UPDATE</command>, <command>DELETE</command>,
434
434
<command>INSERT</command> and <command>LOCK TABLE</command>
435
- for <option>IN ROW EXCLUSIVE MODE</option> statements.
435
+ <option>IN ROW EXCLUSIVE MODE</option> statements.
436
436
</para>
437
437
438
438
<para>
@@ -449,8 +449,8 @@ ERROR: Can't serialize access due to concurrent update
449
449
<listitem>
450
450
<para>
451
451
Acquired by <command>VACUUM</command> (without <option>FULL</option>)
452
- and <command>LOCK TABLE</command> table
453
- for <option>IN SHARE UPDATE EXCLUSIVE MODE</option>
452
+ and <command>LOCK TABLE</command>
453
+ <option>IN SHARE UPDATE EXCLUSIVE MODE</option>
454
454
statements.
455
455
</para>
456
456
@@ -468,8 +468,8 @@ ERROR: Can't serialize access due to concurrent update
468
468
<listitem>
469
469
<para>
470
470
Acquired by <command>CREATE INDEX</command>
471
- and <command>LOCK TABLE</command> table
472
- for <option>IN SHARE MODE</option>
471
+ and <command>LOCK TABLE</command>
472
+ <option>IN SHARE MODE</option>
473
473
statements.
474
474
</para>
475
475
@@ -487,7 +487,7 @@ ERROR: Can't serialize access due to concurrent update
487
487
</term>
488
488
<listitem>
489
489
<para>
490
- Acquired by <command>LOCK TABLE</command> for
490
+ Acquired by <command>LOCK TABLE</command>
491
491
<option>IN SHARE ROW EXCLUSIVE MODE</option> statements.
492
492
</para>
493
493
@@ -505,8 +505,8 @@ ERROR: Can't serialize access due to concurrent update
505
505
</term>
506
506
<listitem>
507
507
<para>
508
- Acquired by <command>LOCK TABLE</command> table
509
- for <option>IN EXCLUSIVE MODE</option> statements.
508
+ Acquired by <command>LOCK TABLE</command>
509
+ <option>IN EXCLUSIVE MODE</option> statements.
510
510
</para>
511
511
512
512
<para>
@@ -527,7 +527,8 @@ ERROR: Can't serialize access due to concurrent update
527
527
Acquired by <command>ALTER TABLE</command>,
528
528
<command>DROP TABLE</command>,
529
529
<command>VACUUM FULL</command> and <command>LOCK TABLE</command>
530
- statements.
530
+ <option>IN ACCESS EXCLUSIVE MODE</option> (or plain
531
+ <command>LOCK TABLE</command>) statements.
531
532
</para>
532
533
533
534
<para>
0 commit comments