|
1 | | -<!-- $PostgreSQL: pgsql/doc/src/sgml/mvcc.sgml,v 2.66 2007/01/31 20:56:18 momjian Exp $ --> |
| 1 | +<!-- $PostgreSQL: pgsql/doc/src/sgml/mvcc.sgml,v 2.67 2007/02/08 15:32:11 momjian Exp $ --> |
2 | 2 |
|
3 | 3 | <chapter id="mvcc"> |
4 | 4 | <title>Concurrency Control</title> |
@@ -741,6 +741,123 @@ SELECT SUM(value) FROM mytab WHERE class = 2; |
741 | 741 | releases locks acquired within it. |
742 | 742 | </para> |
743 | 743 |
|
| 744 | + <table tocentry="1" id="table-lock-compatibility"> |
| 745 | + <title> Compatibility of lock modes</title> |
| 746 | + <tgroup cols="9"> |
| 747 | + <colspec colnum="1" colwidth="1*"> |
| 748 | + <colspec colnum="2" colwidth="1*"> |
| 749 | + <colspec colnum="3" colwidth="1*"> |
| 750 | + <colspec colnum="4" colwidth="1*"> |
| 751 | + <colspec colnum="5" colwidth="1*"> |
| 752 | + <colspec colnum="6" colwidth="1*"> |
| 753 | + <colspec colnum="7" colwidth="1*"> |
| 754 | + <colspec colnum="8" colwidth="1*"> |
| 755 | + <colspec colnum="9" colwidth="1*"> |
| 756 | + <thead> |
| 757 | + <row> |
| 758 | + <entry>Modes</entry> |
| 759 | + <entry>AS</entry> |
| 760 | + <entry>RS</entry> |
| 761 | + <entry>RE</entry> |
| 762 | + <entry>SUE</entry> |
| 763 | + <entry>S</entry> |
| 764 | + <entry>SRE</entry> |
| 765 | + <entry>E</entry> |
| 766 | + <entry>AE</entry> |
| 767 | + </row> |
| 768 | + </thead> |
| 769 | + <tbody> |
| 770 | + <row> |
| 771 | + <entry>AS</entry> |
| 772 | + <entry align="center">Y</entry> |
| 773 | + <entry align="center">Y</entry> |
| 774 | + <entry align="center">Y</entry> |
| 775 | + <entry align="center">Y</entry> |
| 776 | + <entry align="center">Y</entry> |
| 777 | + <entry align="center">Y</entry> |
| 778 | + <entry align="center">Y</entry> |
| 779 | + <entry align="center">N</entry> |
| 780 | + </row> |
| 781 | + <row> |
| 782 | + <entry>RS</entry> |
| 783 | + <entry align="center">Y</entry> |
| 784 | + <entry align="center">Y</entry> |
| 785 | + <entry align="center">Y</entry> |
| 786 | + <entry align="center">Y</entry> |
| 787 | + <entry align="center">Y</entry> |
| 788 | + <entry align="center">Y</entry> |
| 789 | + <entry align="center">N</entry> |
| 790 | + <entry align="center">N</entry> |
| 791 | + </row> |
| 792 | + <row> |
| 793 | + <entry>RE</entry> |
| 794 | + <entry align="center">Y</entry> |
| 795 | + <entry align="center">Y</entry> |
| 796 | + <entry align="center">Y</entry> |
| 797 | + <entry align="center">Y</entry> |
| 798 | + <entry align="center">N</entry> |
| 799 | + <entry align="center">N</entry> |
| 800 | + <entry align="center">N</entry> |
| 801 | + <entry align="center">N</entry> |
| 802 | + </row> |
| 803 | + <row> |
| 804 | + <entry>SUE</entry> |
| 805 | + <entry align="center">Y</entry> |
| 806 | + <entry align="center">Y</entry> |
| 807 | + <entry align="center">Y</entry> |
| 808 | + <entry align="center">N</entry> |
| 809 | + <entry align="center">N</entry> |
| 810 | + <entry align="center">N</entry> |
| 811 | + <entry align="center">N</entry> |
| 812 | + <entry align="center">N</entry> |
| 813 | + </row> |
| 814 | + <row> |
| 815 | + <entry>S</entry> |
| 816 | + <entry align="center">Y</entry> |
| 817 | + <entry align="center">Y</entry> |
| 818 | + <entry align="center">N</entry> |
| 819 | + <entry align="center">N</entry> |
| 820 | + <entry align="center">Y</entry> |
| 821 | + <entry align="center">N</entry> |
| 822 | + <entry align="center">N</entry> |
| 823 | + <entry align="center">N</entry> |
| 824 | + </row> |
| 825 | + <row> |
| 826 | + <entry>SRE</entry> |
| 827 | + <entry align="center">Y</entry> |
| 828 | + <entry align="center">Y</entry> |
| 829 | + <entry align="center">N</entry> |
| 830 | + <entry align="center">N</entry> |
| 831 | + <entry align="center">N</entry> |
| 832 | + <entry align="center">N</entry> |
| 833 | + <entry align="center">N</entry> |
| 834 | + <entry align="center">N</entry> |
| 835 | + </row> |
| 836 | + <row> |
| 837 | + <entry>E</entry> |
| 838 | + <entry align="center">Y</entry> |
| 839 | + <entry align="center">N</entry> |
| 840 | + <entry align="center">N</entry> |
| 841 | + <entry align="center">N</entry> |
| 842 | + <entry align="center">N</entry> |
| 843 | + <entry align="center">N</entry> |
| 844 | + <entry align="center">N</entry> |
| 845 | + <entry align="center">N</entry> |
| 846 | + </row> |
| 847 | + <row> |
| 848 | + <entry>AE</entry> |
| 849 | + <entry align="center">N</entry> |
| 850 | + <entry align="center">N</entry> |
| 851 | + <entry align="center">N</entry> |
| 852 | + <entry align="center">N</entry> |
| 853 | + <entry align="center">N</entry> |
| 854 | + <entry align="center">N</entry> |
| 855 | + <entry align="center">N</entry> |
| 856 | + <entry align="center">N</entry> |
| 857 | + </row> |
| 858 | + </tbody> |
| 859 | + </tgroup> |
| 860 | +</table> |
744 | 861 | </sect2> |
745 | 862 |
|
746 | 863 | <sect2 id="locking-rows"> |
|