[DOCS] patch for doubled words
Hello, Here is a patch for some doubled words in the manual (e.g. "the the"). I'm in the process of producing a printed version of the documentation in book format. If anyone from the PostgreSQL team would like to see the proofs before they go to press I'll be glad to make them available. -- best regards, Brian Gough Network Theory Ltd, Publishing Free Software Manuals --- http://www.network-theory.co.uk/ Index: doc/src/sgml/datatype.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/datatype.sgml,v retrieving revision 1.198 diff -u -r1.198 datatype.sgml --- doc/src/sgml/datatype.sgml 21 Apr 2007 17:26:17 - 1.198 +++ doc/src/sgml/datatype.sgml 3 May 2007 13:57:46 - @@ -3376,7 +3376,7 @@ When using the binary mode to pass query parameters to the server -and query results back the the client, no character set conversion +and query results back to the client, no character set conversion is performed, so the situation is different. In this case, an encoding declaration in the XML data will be observed, and if it is absent, the data will be assumed to be in UTF-8 (as required by Index: doc/src/sgml/ddl.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ddl.sgml,v retrieving revision 1.73 diff -u -r1.73 ddl.sgml --- doc/src/sgml/ddl.sgml 1 Feb 2007 00:28:16 - 1.73 +++ doc/src/sgml/ddl.sgml 3 May 2007 13:57:48 - @@ -2233,7 +2233,7 @@ - When queries or updates access a large percentage of a a single + When queries or updates access a large percentage of a single partition, performance can be improved by taking advantage of sequential scan of that partition instead of using an index and random access reads scattered across the whole table. @@ -2556,7 +2556,7 @@ Note that the WHERE clause in each rule -exactly matches the the CHECK +exactly matches the CHECK constraint for its partition. Index: doc/src/sgml/plperl.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/plperl.sgml,v retrieving revision 2.64 diff -u -r2.64 plperl.sgml --- doc/src/sgml/plperl.sgml16 Feb 2007 03:50:29 - 2.64 +++ doc/src/sgml/plperl.sgml3 May 2007 13:57:52 - @@ -20,7 +20,7 @@ The usual advantage to using PL/Perl is that this allows use, within stored functions, of the manyfold string munging operators and functions available for Perl. Parsing - complex strings might be be easier using Perl than it is with the + complex strings might be easier using Perl than it is with the string functions and control structures provided in PL/pgSQL. @@ -619,7 +619,7 @@ $$ LANGUAGE plperl; The creation of this function will fail as its use of a forbidden -operation will be be caught by the validator. +operation will be caught by the validator. Index: doc/src/sgml/spi.sgml === RCS file: /projects/cvsroot/pgsql/doc/src/sgml/spi.sgml,v retrieving revision 1.56 diff -u -r1.56 spi.sgml --- doc/src/sgml/spi.sgml 16 Apr 2007 01:14:55 - 1.56 +++ doc/src/sgml/spi.sgml 3 May 2007 13:57:54 - @@ -2233,7 +2233,7 @@ Column value, or NULL if the column is null, colnumber is out of range (SPI_result is set to - SPI_ERROR_NOATTRIBUTE), or no no output function + SPI_ERROR_NOATTRIBUTE), or no output function is available (SPI_result is set to SPI_ERROR_NOOUTFUNC). ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
Re: [DOCS] patch for doubled words
On Thu, 2007-03-05 at 15:32 +0100, Brian Gough wrote: > Here is a patch for some doubled words in the manual > (e.g. "the the"). Applied, thanks for the patch. -Neil ---(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 cleanly
Re: [DOCS] patch for doubled words
Neil Conway wrote:
> On Thu, 2007-03-05 at 15:32 +0100, Brian Gough wrote:
> > Here is a patch for some doubled words in the manual
> > (e.g. "the the").
>
> Applied, thanks for the patch.
There are a few more in this patch.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
Index: doc/src/sgml/external-projects.sgml
===
RCS file: /home/alvherre/Code/cvs/pgsql/doc/src/sgml/external-projects.sgml,v
retrieving revision 1.15
diff -c -p -r1.15 external-projects.sgml
*** doc/src/sgml/external-projects.sgml 31 Jan 2007 20:56:17 - 1.15
--- doc/src/sgml/external-projects.sgml 3 May 2007 14:56:16 -
***
*** 31,37
currently closed to new projects in favor of PgFoundry, it still
contains many active and relevant projects. Other popular
PostgreSQL-related projects are hosted
! independently, or on other project-hosting sites such such as http://sourceforge.net/";>SourceForge.net. You should search
the web if you don't find the project you are looking for.
--- 31,37
currently closed to new projects in favor of PgFoundry, it still
contains many active and relevant projects. Other popular
PostgreSQL-related projects are hosted
! independently, or on other project-hosting sites such as http://sourceforge.net/";>SourceForge.net. You should search
the web if you don't find the project you are looking for.
Index: doc/src/sgml/maintenance.sgml
===
RCS file: /home/alvherre/Code/cvs/pgsql/doc/src/sgml/maintenance.sgml,v
retrieving revision 1.72
diff -c -p -r1.72 maintenance.sgml
*** doc/src/sgml/maintenance.sgml 18 Apr 2007 20:44:53 - 1.72
--- doc/src/sgml/maintenance.sgml 3 May 2007 14:56:28 -
*** HINT: Stop the postmaster and use a sta
*** 490,496
There is a limit of worker
! processes that may be running at at any time, so if the VACUUM
and ANALYZE work to do takes too long to run, the deadline may
be failed to meet for other databases. Also, if a particular database
takes long to process, more than one worker may be processing it
--- 490,496
There is a limit of worker
! processes that may be running at any time, so if the VACUUM
and ANALYZE work to do takes too long to run, the deadline may
be failed to meet for other databases. Also, if a particular database
takes long to process, more than one worker may be processing it
Index: doc/src/sgml/release.sgml
===
RCS file: /home/alvherre/Code/cvs/pgsql/doc/src/sgml/release.sgml,v
retrieving revision 1.502
diff -c -p -r1.502 release.sgml
*** doc/src/sgml/release.sgml 20 Apr 2007 03:27:23 - 1.502
--- doc/src/sgml/release.sgml 3 May 2007 14:57:16 -
*** Fix for SELECT timespan('21:11:26'::time
*** 16463,16469
netmask('x.x.x.x/0') is 255.255.255.255 instead of 0.0.0.0 (Oleg Sharoiko)
Add btree index on NUMERIC (Jan)
Perl fix for large objects containing NUL characters (Douglas Thomson)
! ODBC fix for for large objects (free)
Fix indexing of cidr data type
Fix for Ethernet MAC addresses (macaddr type) comparisons
Fix for date/time types when overflows happened in computations (Tom)
--- 16463,16469
netmask('x.x.x.x/0') is 255.255.255.255 instead of 0.0.0.0 (Oleg Sharoiko)
Add btree index on NUMERIC (Jan)
Perl fix for large objects containing NUL characters (Douglas Thomson)
! ODBC fix for large objects (free)
Fix indexing of cidr data type
Fix for Ethernet MAC addresses (macaddr type) comparisons
Fix for date/time types when overflows happened in computations (Tom)
*** more compliant to the SQL-92 standard):
*** 19056,19062
"WITH GRANT OPTION" is not supported. Only class owners can change
access control
!- The default access control is to to grant users readonly access.
You must explicitly grant insert/update access to users. To change
this, modify the line in
src/backend/utils/acl.h
--- 19056,19062
"WITH GRANT OPTION" is not supported. Only class owners can change
access control
!- The default access control is to grant users readonly access.
You must explicitly grant insert/update access to users. To change
this, modify the line in
src/backend/utils/acl.h
Index: doc/src/sgml/ref/psql-ref.sgml
===
RCS file: /home/alvherre/Code/cvs/pgsql/doc/src/sgml/ref/psql-ref.sgml,v
retrieving revision 1.190
diff -c -p -r1.190 psql-ref.sgml
*** doc/src/sgml/ref/psql-ref.sgml 26 Mar 2007 17:23:37 - 1.190
--- doc/src/sgml/ref/psql-ref.sgml 3 May 2007 14:58:13 -
*
Re: [DOCS] row-level stats and last analyze time
On Thu, 2007-26-04 at 18:07 -0400, Neil Conway wrote: > (1) I believe the reasoning for Tom's earlier change was not to reduce > the I/O between the backend and the pgstat process [...] Tom, any comments on this? Your change introduced an undocumented regression into 8.2. I think you're on the hook for a documentation update at the very least, if not a revert. -Neil ---(end of broadcast)--- TIP 6: explain analyze is your friend
