[pgsql-patches] Docs improvements

2007-01-26 Thread Teodor Sigaev

1)  mvcc.sgml.patch
Update comments about installation of DocBook on FreeBSD. DocBook v4.2 is 
present in ports now.


2) docguide.sgml.patch
Table of compatibility of table-lock modes. IMHO, it's useful, clear for 
understanding. Text view of the table is:

|   AS  |   RS  |   RE  |   SUE |   S   |   SRE |   E   |   AE  |
+---+---+---+---+---+---+---+---+
AS  |   O   |   O   |   O   |   O   |   O   |   O   |   O   |   X   |
+---+---+---+---+---+---+---+---+
RS  |   O   |   O   |   O   |   O   |   O   |   O   |   X   |   X   |
+---+---+---+---+---+---+---+---+
RE  |   O   |   O   |   O   |   O   |   X   |   X   |   X   |   X   |
+---+---+---+---+---+---+---+---+
SUE |   O   |   O   |   O   |   X   |   X   |   X   |   X   |   X   |
+---+---+---+---+---+---+---+---+
S   |   O   |   O   |   X   |   X   |   O   |   X   |   X   |   X   |
+---+---+---+---+---+---+---+---+
SRE |   O   |   O   |   X   |   X   |   X   |   X   |   X   |   X   |
+---+---+---+---+---+---+---+---+
E   |   O   |   X   |   X   |   X   |   X   |   X   |   X   |   X   |
+---+---+---+---+---+---+---+---+
AE  |   X   |   X   |   X   |   X   |   X   |   X   |   X   |   X   |
+---+---+---+---+---+---+---+---+

Upper row and left column contain abbreviation of lock modes by the first 
characters( AS - ACCESS SHARE )

--
Teodor Sigaev   E-mail: [EMAIL PROTECTED]
   WWW: http://www.sigaev.ru/
*** mvcc.sgml.orig  Fri Jan 26 16:27:27 2007
--- mvcc.sgml   Fri Jan 26 17:49:29 2007
***
*** 741,746 
--- 741,863 
  releases locks acquired within it.
 
  
+ 
+   Compatibility of lock modes
+  
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+  
+ Modes
+ AS
+ RS
+ RE
+ SUE
+ S
+ SRE
+ E
+ AE
+  
+ 
+ 
+  
+ AS
+ Y
+ Y
+ Y
+ Y
+ Y
+ Y
+ Y
+ N
+  
+  
+ RS
+ Y
+ Y
+ Y
+ Y
+ Y
+ Y
+ N
+ N
+  
+  
+ RE
+ Y
+ Y
+ Y
+ Y
+ N
+ N
+ N
+ N
+  
+  
+ SUE
+ Y
+ Y
+ Y
+ N
+ N
+ N
+ N
+ N
+  
+  
+ S
+ Y
+ Y
+ N
+ N
+ Y
+ N
+ N
+ N
+  
+  
+ SRE
+ Y
+ Y
+ N
+ N
+ N
+ N
+ N
+ N
+  
+  
+ E
+ Y
+ N
+ N
+ N
+ N
+ N
+ N
+ N
+  
+  
+ AE
+ N
+ N
+ N
+ N
+ N
+ N
+ N
+ N
+  
+ 
+
+   
 
  
 
*** docguide.sgml.orig  Fri Jan 26 15:59:29 2007
--- docguide.sgml   Fri Jan 26 16:08:58 2007
***
*** 212,220 
   
textproc/dsssl-docbook-modular
   
  
- Apparently, there is no port for the DocBook V4.2 SGML DTD
- available right now.  You will need to install it manually.
 
  
 
--- 212,221 
   
textproc/dsssl-docbook-modular
   
+  
+   textproc/docbook-420
+  
  
 
  
 
***
*** 225,234 
  
 
  It's possible that the ports do not update the main catalog file
! in /usr/local/share/sgml/catalog.  Be sure to
! have the following line in there:
  
! CATALOG "/usr/local/share/sgml/docbook/4.2/docbook.cat"
  
  If you do not want to edit the file you can also set the
  environment variable SGML_CATALOG_FILES to a
--- 226,238 
  
 
  It's possible that the ports do not update the main catalog file
! in /usr/local/share/sgml/catalog.ports or order 
!   isn't proper .  Be sure to have the following lines in begining of file:
  
! CATALOG "openjade/catalog"
! CATALOG "iso8879/catalog"
! CATALOG "docbook/dsssl/modular/catalog"
! CATALOG "docbook/4.2/catalog"
  
  If you do not want to edit the file you can also set the
  environment variable SGML_CATALOG_FILES to a

---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list clea

Re: [pgsql-patches] Docs improvements

2007-01-26 Thread Alvaro Herrera
Teodor Sigaev wrote:

> 2) docguide.sgml.patch
> Table of compatibility of table-lock modes. IMHO, it's useful, clear for 
> understanding. Text view of the table is:
> |   AS  |   RS  |   RE  |   SUE |   S   |   SRE |   E   |   AE  |
> +---+---+---+---+---+---+---+---+
> AS  |   O   |   O   |   O   |   O   |   O   |   O   |   O   |   X   |
> +---+---+---+---+---+---+---+---+
> RS  |   O   |   O   |   O   |   O   |   O   |   O   |   X   |   X   |
> +---+---+---+---+---+---+---+---+
> RE  |   O   |   O   |   O   |   O   |   X   |   X   |   X   |   X   |
> +---+---+---+---+---+---+---+---+
> SUE |   O   |   O   |   O   |   X   |   X   |   X   |   X   |   X   |
> +---+---+---+---+---+---+---+---+
> S   |   O   |   O   |   X   |   X   |   O   |   X   |   X   |   X   |
> +---+---+---+---+---+---+---+---+
> SRE |   O   |   O   |   X   |   X   |   X   |   X   |   X   |   X   |
> +---+---+---+---+---+---+---+---+
> E   |   O   |   X   |   X   |   X   |   X   |   X   |   X   |   X   |
> +---+---+---+---+---+---+---+---+
> AE  |   X   |   X   |   X   |   X   |   X   |   X   |   X   |   X   |
> +---+---+---+---+---+---+---+---+

I agree this would be useful to have in some form.

-- 
Alvaro Herrerahttp://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings