Correct several typos in the documentation.
I took the liberty of making the following spelling changes for
consistency with the rest of the documentation, even though the
originals are the preferred spellings in some parts of the English-
speaking world. I found only one or two instances of each; the
latter forms were far more common.
behaviour => behavior
organisation => organization
recognised => recognized
recognises => recognizes
--
Michael Fuhr
Index: doc/src/sgml/config.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/config.sgml,v
retrieving revision 1.25
diff -c -r1.25 config.sgml
*** doc/src/sgml/config.sgml 8 Oct 2005 20:27:25 -0000 1.25
--- doc/src/sgml/config.sgml 13 Oct 2005 06:15:38 -0000
***************
*** 2600,2606 ****
Each recognized escape is replaced as outlined
below - anything else that looks like an escape is ignored. Other
characters are copied straight to the log line. Some escapes are
! only recognised by session processes, and do not apply to
background processes such as the postmaster. <application>Syslog</>
produces its own
time stamp and process ID information, so you probably do not want to
--- 2600,2606 ----
Each recognized escape is replaced as outlined
below - anything else that looks like an escape is ignored. Other
characters are copied straight to the log line. Some escapes are
! only recognized by session processes, and do not apply to
background processes such as the postmaster. <application>Syslog</>
produces its own
time stamp and process ID information, so you probably do not want to
Index: doc/src/sgml/cvs.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/cvs.sgml,v
retrieving revision 1.34
diff -c -r1.34 cvs.sgml
*** doc/src/sgml/cvs.sgml 11 Aug 2005 13:52:33 -0000 1.34
--- doc/src/sgml/cvs.sgml 13 Oct 2005 06:15:38 -0000
***************
*** 849,855 ****
to you the malloc code and an additional installation e-mail from John.
The Modula-3 installation takes a good bit of room (~50MB?) and the
! build environment is unique to Modula-3, but suprisingly enough it
pretty much works.
The cvsup Makefiles do not work on my machine (they are not portable
--- 849,855 ----
to you the malloc code and an additional installation e-mail from John.
The Modula-3 installation takes a good bit of room (~50MB?) and the
! build environment is unique to Modula-3, but surprisingly enough it
pretty much works.
The cvsup Makefiles do not work on my machine (they are not portable
Index: doc/src/sgml/information_schema.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/information_schema.sgml,v
retrieving revision 1.21
diff -c -r1.21 information_schema.sgml
*** doc/src/sgml/information_schema.sgml 27 Aug 2005 14:13:21 -0000
1.21
--- doc/src/sgml/information_schema.sgml 13 Oct 2005 06:15:39 -0000
***************
*** 3272,3278 ****
</row>
<row>
! <entry><literal>sql_language_comformance</literal></entry>
<entry><type>character_data</type></entry>
<entry>
The standard conformance level for the language binding. For
--- 3272,3278 ----
</row>
<row>
! <entry><literal>sql_language_conformance</literal></entry>
<entry><type>character_data</type></entry>
<entry>
The standard conformance level for the language binding. For
Index: doc/src/sgml/planstats.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/planstats.sgml,v
retrieving revision 1.3
diff -c -r1.3 planstats.sgml
*** doc/src/sgml/planstats.sgml 14 Mar 2005 06:49:48 -0000 1.3
--- doc/src/sgml/planstats.sgml 13 Oct 2005 06:15:39 -0000
***************
*** 23,29 ****
<para>
The outputs and algorithms shown below are taken from version 8.0.
! The behaviour of earlier (or later) versions may vary.
</para>
<sect1 id="row-estimation-examples">
--- 23,29 ----
<para>
The outputs and algorithms shown below are taken from version 8.0.
! The behavior of earlier (or later) versions may vary.
</para>
<sect1 id="row-estimation-examples">
Index: doc/src/sgml/release.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/release.sgml,v
retrieving revision 1.390
diff -c -r1.390 release.sgml
*** doc/src/sgml/release.sgml 11 Oct 2005 21:17:11 -0000 1.390
--- doc/src/sgml/release.sgml 13 Oct 2005 06:15:44 -0000
***************
*** 5631,5637 ****
<listitem><para>Fix information schema view
<literal>constraint_column_usage</literal> for foreign keys
(Peter)</para></listitem>
<listitem><para>ECPG fixes (Michael)</para></listitem>
<listitem><para>Fix bug with multiple <literal>IN</literal> subqueries and
joins in the subqueries (Tom)</para></listitem>
! <listitem><para>Alllow <literal>COUNT('x')</literal> to work
(Tom)</para></listitem>
<listitem><para>Install ECPG include files for Informix compatibility into
separate directory (Peter)</para>
<para>
Some names of ECPG include files for Informix compatibility conflicted with
operating system include files.
--- 5631,5637 ----
<listitem><para>Fix information schema view
<literal>constraint_column_usage</literal> for foreign keys
(Peter)</para></listitem>
<listitem><para>ECPG fixes (Michael)</para></listitem>
<listitem><para>Fix bug with multiple <literal>IN</literal> subqueries and
joins in the subqueries (Tom)</para></listitem>
! <listitem><para>Allow <literal>COUNT('x')</literal> to work
(Tom)</para></listitem>
<listitem><para>Install ECPG include files for Informix compatibility into
separate directory (Peter)</para>
<para>
Some names of ECPG include files for Informix compatibility conflicted with
operating system include files.
***************
*** 7262,7268 ****
<listitem>
<para>
! Have pg_dumpall use <command>GRANT</>/<command>REVOKE</> to dump
database-level privleges (Tom)
</para>
</listitem>
--- 7262,7268 ----
<listitem>
<para>
! Have pg_dumpall use <command>GRANT</>/<command>REVOKE</> to dump
database-level privileges (Tom)
</para>
</listitem>
***************
*** 9782,9788 ****
<para>
<programlisting>
! Remove unused WAL segements of large transactions (Tom)
Multiaction rule fix (Tom)
PL/pgSQL memory allocation fix (Jan)
VACUUM buffer fix (Tom)
--- 9782,9788 ----
<para>
<programlisting>
! Remove unused WAL segments of large transactions (Tom)
Multiaction rule fix (Tom)
PL/pgSQL memory allocation fix (Jan)
VACUUM buffer fix (Tom)
***************
*** 10219,10225 ****
Allow PL/pgSQL to accept non ascii identifiers (Tatsuo)
Make vacuum always flush buffers (Tom)
Fix to allow cancel while waiting for a lock (Hiroshi)
! Fix for memory aloocation problem in user authentication code (Tom)
Remove bogus use of int4out() (Tom)
Fixes for multiple subqueries in COALESCE or BETWEEN (Tom)
Fix for failure of triggers on heap open in certain cases (Jeroen van
--- 10219,10225 ----
Allow PL/pgSQL to accept non ascii identifiers (Tatsuo)
Make vacuum always flush buffers (Tom)
Fix to allow cancel while waiting for a lock (Hiroshi)
! Fix for memory allocation problem in user authentication code (Tom)
Remove bogus use of int4out() (Tom)
Fixes for multiple subqueries in COALESCE or BETWEEN (Tom)
Fix for failure of triggers on heap open in certain cases (Jeroen van
***************
*** 10938,10950 ****
Patch to allow vacuum on multisegment tables(Hiroshi)
R-Tree optimizer selectivity fix(Tom)
ACL file descriptor leak fix(Atsushi Ogawa)
! New expresssion subtree code(Tom)
Avoid disk writes for read-only transactions(Vadim)
Fix for removal of temp tables if last transaction was aborted(Bruce)
Fix to prevent too large row from being created(Bruce)
plpgsql fixes
Allow port numbers 32k - 64k(Bruce)
! Add ^ precidence(Bruce)
Rename sort files called pg_temp to pg_sorttemp(Bruce)
Fix for microseconds in time values(Tom)
Tutorial source cleanup
--- 10938,10950 ----
Patch to allow vacuum on multisegment tables(Hiroshi)
R-Tree optimizer selectivity fix(Tom)
ACL file descriptor leak fix(Atsushi Ogawa)
! New expression subtree code(Tom)
Avoid disk writes for read-only transactions(Vadim)
Fix for removal of temp tables if last transaction was aborted(Bruce)
Fix to prevent too large row from being created(Bruce)
plpgsql fixes
Allow port numbers 32k - 64k(Bruce)
! Add ^ precedence(Bruce)
Rename sort files called pg_temp to pg_sorttemp(Bruce)
Fix for microseconds in time values(Tom)
Tutorial source cleanup
***************
*** 11326,11332 ****
Better optimization statistics for system table access(Tom)
Better handling of non-default block sizes(Massimo)
Improve GEQO optimizer memory consumption(Tom)
! UNION now suppports ORDER BY of columns not in target list(Jan)
Major libpq++ improvements(Vince Vielhaber)
pg_dump now uses -z(ACL's) as default(Bruce)
backend cache, memory speedups(Tom)
--- 11326,11332 ----
Better optimization statistics for system table access(Tom)
Better handling of non-default block sizes(Massimo)
Improve GEQO optimizer memory consumption(Tom)
! UNION now supports ORDER BY of columns not in target list(Jan)
Major libpq++ improvements(Vince Vielhaber)
pg_dump now uses -z(ACL's) as default(Bruce)
backend cache, memory speedups(Tom)
***************
*** 11700,11706 ****
psql and libpq now compile under Windows using win32.mak(Magnus)
Lo_read no longer stores trailing NULL(Bruce)
Identifiers are now truncated to 31 characters internally(Bruce)
! Createuser options now availble on the command line
Code for 64-bit integer supported added, configure tested, int8 type(Thomas)
Prevent file descriptor leaf from failed COPY(Bruce)
New pg_upgrade command(Bruce)
--- 11700,11706 ----
psql and libpq now compile under Windows using win32.mak(Magnus)
Lo_read no longer stores trailing NULL(Bruce)
Identifiers are now truncated to 31 characters internally(Bruce)
! Createuser options now available on the command line
Code for 64-bit integer supported added, configure tested, int8 type(Thomas)
Prevent file descriptor leaf from failed COPY(Bruce)
New pg_upgrade command(Bruce)
***************
*** 11711,11717 ****
libpq's internal structures now not exported(Tom)
Allow up to 8 key indexes(Bruce)
Remove ARCHIVE key word, that is no longer used(Thomas)
! pg_dump -n flag to supress quotes around indentifiers
disable system columns for views(Jan)
new INET and CIDR types for network addresses(TomH, Paul)
no more double quotes in psql output
--- 11711,11717 ----
libpq's internal structures now not exported(Tom)
Allow up to 8 key indexes(Bruce)
Remove ARCHIVE key word, that is no longer used(Thomas)
! pg_dump -n flag to suppress quotes around indentifiers
disable system columns for views(Jan)
new INET and CIDR types for network addresses(TomH, Paul)
no more double quotes in psql output
***************
*** 11740,11746 ****
SCO 7/UnixWare 2.x fixes(Billy,others)
Sparc/Solaris 2.5 fixes(Ryan)
Pgbuiltin.3 is obsolete, move to doc files(Thomas)
! Even more documention(Thomas)
Nextstep support(Jacek)
Aix support(David)
pginterface manual page(Bruce)
--- 11740,11746 ----
SCO 7/UnixWare 2.x fixes(Billy,others)
Sparc/Solaris 2.5 fixes(Ryan)
Pgbuiltin.3 is obsolete, move to doc files(Thomas)
! Even more documentation(Thomas)
Nextstep support(Jacek)
Aix support(David)
pginterface manual page(Bruce)
***************
*** 12088,12094 ****
and throw elog(ERROR) if unrecognized(Thomas)
Major large objects fix
Fix for GROUP BY showing duplicates(Vadim)
! Fix for index scans in MergeJion(Vadim)
Enhancements
------------
--- 12088,12094 ----
and throw elog(ERROR) if unrecognized(Thomas)
Major large objects fix
Fix for GROUP BY showing duplicates(Vadim)
! Fix for index scans in MergeJoin(Vadim)
Enhancements
------------
***************
*** 12713,12719 ****
<programlisting>
Bug Fixes
---------
! ALTER TABLE bug - running postgress process needs to re-read table definition
Allow vacuum to be run on one table or entire database(Bruce)
Array fixes
Fix array over-runs of memory writes(Kurt)
--- 12713,12719 ----
<programlisting>
Bug Fixes
---------
! ALTER TABLE bug - running postgres process needs to re-read table definition
Allow vacuum to be run on one table or entire database(Bruce)
Array fixes
Fix array over-runs of memory writes(Kurt)
***************
*** 12721,12727 ****
Fix for hash indexes on some types like time and date
Fix for pg_log size explosion
Fix permissions on lo_export()(Bruce)
! Fix unitialized reads of memory(Kurt)
Fixed ALTER TABLE ... char(3) bug(Bruce)
Fixed a few small memory leaks
Fixed EXPLAIN handling of options and changed full_path option name
--- 12721,12727 ----
Fix for hash indexes on some types like time and date
Fix for pg_log size explosion
Fix permissions on lo_export()(Bruce)
! Fix uninitialized reads of memory(Kurt)
Fixed ALTER TABLE ... char(3) bug(Bruce)
Fixed a few small memory leaks
Fixed EXPLAIN handling of options and changed full_path option name
***************
*** 12765,12771 ****
European date format now set when postmaster is started
Execute lowercase function names if not found with exact case
Fixes for aggregate/GROUP processing, allow 'select sum(func(x),sum(x+y) from
z'
! Gist now included in the distrubution(Marc)
Idend authentication of local users(Bryan)
Implement BETWEEN qualifier(Bruce)
Implement IN qualifier(Bruce)
--- 12765,12771 ----
European date format now set when postmaster is started
Execute lowercase function names if not found with exact case
Fixes for aggregate/GROUP processing, allow 'select sum(func(x),sum(x+y) from
z'
! Gist now included in the distribution(Marc)
Idend authentication of local users(Bryan)
Implement BETWEEN qualifier(Bruce)
Implement IN qualifier(Bruce)
***************
*** 12794,12800 ****
Source tree changes
-------------------
All functions now have prototypes that are compared against the calls
! Allow asserts to be disabled easly from Makefile.global(Bruce)
Change oid constants used in code to #define names
Decoupled sparc and solaris defines(Kurt)
Gcc -Wall compiles cleanly with warnings only from unfixable constructs
--- 12794,12800 ----
Source tree changes
-------------------
All functions now have prototypes that are compared against the calls
! Allow asserts to be disabled easily from Makefile.global(Bruce)
Change oid constants used in code to #define names
Decoupled sparc and solaris defines(Kurt)
Gcc -Wall compiles cleanly with warnings only from unfixable constructs
***************
*** 12807,12819 ****
New config.h file(Marc, Bryan)
PG_VERSION now set to 6.0 and used by postmaster
Portability additions, including Ultrix, DG/UX, AIX, and Solaris
! Reduced the number of #define's, centeralized #define's
Remove duplicate OIDS in system tables(Dan)
Remove duplicate system catalog info or report mismatches(Dan)
Removed many os-specific #define's
Restructured object file generation/location(Bryan, Marc)
Restructured port-specific file locations(Bryan, Marc)
! Unused/uninialized variables corrected
</programlisting>
</para>
</sect2>
--- 12807,12819 ----
New config.h file(Marc, Bryan)
PG_VERSION now set to 6.0 and used by postmaster
Portability additions, including Ultrix, DG/UX, AIX, and Solaris
! Reduced the number of #define's, centralized #define's
Remove duplicate OIDS in system tables(Dan)
Remove duplicate system catalog info or report mismatches(Dan)
Removed many os-specific #define's
Restructured object file generation/location(Bryan, Marc)
Restructured port-specific file locations(Bryan, Marc)
! Unused/uninitialized variables corrected
</programlisting>
</para>
</sect2>
***************
*** 12953,12959 ****
</programlisting>
</para>
<!--
! Contributors (appologies to any missed)
* Kurt J. Lidl <[EMAIL PROTECTED]>
(missed in first run, but no less important)
* Erich Stamberger <[EMAIL PROTECTED]>
--- 12953,12959 ----
</programlisting>
</para>
<!--
! Contributors (apologies to any missed)
* Kurt J. Lidl <[EMAIL PROTECTED]>
(missed in first run, but no less important)
* Erich Stamberger <[EMAIL PROTECTED]>
Index: doc/src/sgml/rules.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/rules.sgml,v
retrieving revision 1.42
diff -c -r1.42 rules.sgml
*** doc/src/sgml/rules.sgml 20 May 2005 01:37:08 -0000 1.42
--- doc/src/sgml/rules.sgml 13 Oct 2005 06:15:45 -0000
***************
*** 2012,2018 ****
The last command we look at is
<programlisting>
! DELETE FROM computer WHERE manufacurer = 'bim';
</programlisting>
Again this could result in many rows to be deleted from
--- 2012,2018 ----
The last command we look at is
<programlisting>
! DELETE FROM computer WHERE manufacturer = 'bim';
</programlisting>
Again this could result in many rows to be deleted from
***************
*** 2020,2026 ****
through the executor. The command generated by the rule will be
<programlisting>
! DELETE FROM software WHERE computer.manufacurer = 'bim'
AND software.hostname = computer.hostname;
</programlisting>
--- 2020,2026 ----
through the executor. The command generated by the rule will be
<programlisting>
! DELETE FROM software WHERE computer.manufacturer = 'bim'
AND software.hostname = computer.hostname;
</programlisting>
Index: doc/src/sgml/runtime.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/runtime.sgml,v
retrieving revision 1.353
diff -c -r1.353 runtime.sgml
*** doc/src/sgml/runtime.sgml 12 Sep 2005 22:11:38 -0000 1.353
--- doc/src/sgml/runtime.sgml 13 Oct 2005 06:15:45 -0000
***************
*** 747,753 ****
</para>
<para>
! The remaining sempahore settings are read-only as far as
<command>sysctl</command> is concerned, but can be changed
before boot using the <command>loader</command> prompt:
<screen>
--- 747,753 ----
</para>
<para>
! The remaining semaphore settings are read-only as far as
<command>sysctl</command> is concerned, but can be changed
before boot using the <command>loader</command> prompt:
<screen>
Index: doc/src/sgml/user-manag.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/user-manag.sgml,v
retrieving revision 1.30
diff -c -r1.30 user-manag.sgml
*** doc/src/sgml/user-manag.sgml 14 Aug 2005 23:35:37 -0000 1.30
--- doc/src/sgml/user-manag.sgml 13 Oct 2005 06:15:45 -0000
***************
*** 464,470 ****
<para>
Functions run inside the backend
server process with the operating system permissions of the
! database server daemon. If the programmming language
used for the function allows unchecked memory accesses, it is
possible to change the server's internal data structures.
Hence, among many other things, such functions can circumvent any
--- 464,470 ----
<para>
Functions run inside the backend
server process with the operating system permissions of the
! database server daemon. If the programming language
used for the function allows unchecked memory accesses, it is
possible to change the server's internal data structures.
Hence, among many other things, such functions can circumvent any
Index: doc/src/sgml/xfunc.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/xfunc.sgml,v
retrieving revision 1.104
diff -c -r1.104 xfunc.sgml
*** doc/src/sgml/xfunc.sgml 14 Sep 2005 21:14:26 -0000 1.104
--- doc/src/sgml/xfunc.sgml 13 Oct 2005 06:15:46 -0000
***************
*** 1209,1215 ****
<indexterm zone="xfunc-c-basetype">
<primary>data type</primary>
! <secondary>internal organisation</secondary>
</indexterm>
<para>
--- 1209,1215 ----
<indexterm zone="xfunc-c-basetype">
<primary>data type</primary>
! <secondary>internal organization</secondary>
</indexterm>
<para>
Index: doc/src/sgml/ref/alter_sequence.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/alter_sequence.sgml,v
retrieving revision 1.11
diff -c -r1.11 alter_sequence.sgml
*** doc/src/sgml/ref/alter_sequence.sgml 13 Sep 2005 15:24:57 -0000
1.11
--- doc/src/sgml/ref/alter_sequence.sgml 13 Oct 2005 06:15:46 -0000
***************
*** 157,163 ****
specified, any calls to <function>nextval</function> after the
sequence has reached its maximum value will return an error.
If neither <literal>CYCLE</literal> or <literal>NO
! CYCLE</literal> are specified, the old cycle behaviour will be
maintained.
</para>
</listitem>
--- 157,163 ----
specified, any calls to <function>nextval</function> after the
sequence has reached its maximum value will return an error.
If neither <literal>CYCLE</literal> or <literal>NO
! CYCLE</literal> are specified, the old cycle behavior will be
maintained.
</para>
</listitem>
Index: doc/src/sgml/ref/copy.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/copy.sgml,v
retrieving revision 1.68
diff -c -r1.68 copy.sgml
*** doc/src/sgml/ref/copy.sgml 13 Oct 2005 02:00:09 -0000 1.68
--- doc/src/sgml/ref/copy.sgml 13 Oct 2005 06:15:47 -0000
***************
*** 482,488 ****
Separated Value (<literal>CSV</>) file format used by many other
programs, such as spreadsheets. Instead of the escaping used by
<productname>PostgreSQL</productname>'s standard text mode, it
! produces and recognises the common CSV escaping mechanism.
</para>
<para>
--- 482,488 ----
Separated Value (<literal>CSV</>) file format used by many other
programs, such as spreadsheets. Instead of the escaping used by
<productname>PostgreSQL</productname>'s standard text mode, it
! produces and recognizes the common CSV escaping mechanism.
</para>
<para>
Index: doc/src/sgml/ref/create_table_as.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/create_table_as.sgml,v
retrieving revision 1.29
diff -c -r1.29 create_table_as.sgml
*** doc/src/sgml/ref/create_table_as.sgml 9 Jan 2005 05:57:45 -0000
1.29
--- doc/src/sgml/ref/create_table_as.sgml 13 Oct 2005 06:15:47 -0000
***************
*** 143,149 ****
<para>
Prior to <productname>PostgreSQL</productname> 8.0, <command>CREATE
TABLE AS</command> always included OIDs in the table it
! produced. As of <productname>PostgresSQL</productname> 8.0,
the <command>CREATE TABLE AS</command> command allows the user to
explicitly specify whether OIDs should be included. If the
presence of OIDs is not explicitly specified,
--- 143,149 ----
<para>
Prior to <productname>PostgreSQL</productname> 8.0, <command>CREATE
TABLE AS</command> always included OIDs in the table it
! produced. As of <productname>PostgreSQL</productname> 8.0,
the <command>CREATE TABLE AS</command> command allows the user to
explicitly specify whether OIDs should be included. If the
presence of OIDs is not explicitly specified,
Index: doc/src/sgml/ref/pg_dumpall.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql/doc/src/sgml/ref/pg_dumpall.sgml,v
retrieving revision 1.53
diff -c -r1.53 pg_dumpall.sgml
*** doc/src/sgml/ref/pg_dumpall.sgml 10 Oct 2005 22:29:47 -0000 1.53
--- doc/src/sgml/ref/pg_dumpall.sgml 13 Oct 2005 06:15:47 -0000
***************
*** 406,412 ****
<para>
<xref linkend="app-pgdump">. Check there for details on possible
! error conditions. Also see suppored environment variables
(<xref linkend="libpq-envars">).
</para>
</refsect1>
--- 406,412 ----
<para>
<xref linkend="app-pgdump">. Check there for details on possible
! error conditions. Also see supported environment variables
(<xref linkend="libpq-envars">).
</para>
</refsect1>
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
