Stamp release 8.2.1. Update FAQs.

13 files changed, 130 insertions, 81 deletions

diff --git a/doc/FAQ b/doc/FAQ
index f539aa3d031..8d3a77413dc 100644
--- a/doc/FAQ
+++ b/doc/FAQ
@@ -1,7 +1,7 @@
 
                 Frequently Asked Questions (FAQ) for PostgreSQL
                                        
-   Last updated: Mon Dec 11 17:45:54 EST 2006
+   Last updated: Fri Jan 5 15:40:20 EST 2007
    
    Current maintainer: Bruce Momjian (bruce@momjian.us)
    
@@ -171,7 +171,7 @@
    
   1.6) What is the most recent release?
   
-   The latest release of PostgreSQL is version 8.2.0.
+   The latest release of PostgreSQL is version 8.2.1.
    
    We plan to have a major release every year, with minor releases every
    few months.
diff --git a/doc/FAQ_AIX b/doc/FAQ_AIX
index 35183a0fee9..6cf79a2686c 100644
--- a/doc/FAQ_AIX
+++ b/doc/FAQ_AIX
@@ -3,7 +3,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL
 AIX Specific
 TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
 =======================================================
-Last updated:        $Date: 2006/12/11 22:48:07 $
+Last updated:        $Date: 2007/01/05 20:55:28 $
 
 Topics
 
@@ -16,7 +16,7 @@ Topics
 -----
 
 From: Zeugswetter Andreas <ZeugswetterA@spardat.at>
-$Date: 2006/12/11 22:48:07 $
+$Date: 2007/01/05 20:55:28 $
 
 On AIX 4.3.2 PostgreSQL compiled with the native IBM compiler xlc
 (vac.C 5.0.1) passes all regression tests.  Other versions of OS and
diff --git a/doc/FAQ_DEV b/doc/FAQ_DEV
index b24141ca767..8abc9c541db 100644
--- a/doc/FAQ_DEV
+++ b/doc/FAQ_DEV
@@ -1,7 +1,7 @@
 
           Developer's Frequently Asked Questions (FAQ) for PostgreSQL
                                        
-   Last updated: Mon Nov 13 23:18:46 EST 2006
+   Last updated: Thu Jan 4 16:00:00 EST 2007
    
    Current maintainer: Bruce Momjian (bruce@momjian.us)
    
@@ -30,6 +30,7 @@ General Questions
    1.16) Where can I get a copy of the SQL standards?
    1.17) Where can I get technical assistance?
    1.18) How do I get involved in PostgreSQL web site development?
+   1.19) What is the timeline for the next major PostgreSQL release?
    
 Technical Questions
 
@@ -99,7 +100,9 @@ General Questions
    both the internal implementation method you plan to use, and any
    user-visible changes (new syntax, etc). For complex patches, it is
    important to get community feeback on your proposal before starting
-   work. Failure to do so might mean your patch is rejected.
+   work. Failure to do so might mean your patch is rejected. If your work
+   is being sponsored by a company, read this article for tips on being
+   more effective.
    
    A web site is maintained for patches awaiting review,
    http://momjian.postgresql.org/cgi-bin/pgpatches, and those that are
@@ -225,7 +228,7 @@ General Questions
     ccsym           find standard defines made by your compiler
      copyright       fixes copyright notices
 
-    entab           converts tabs to spaces, used by pgindent
+    entab           converts spaces to tabs, used by pgindent
     find_static     finds functions that could be made static
     find_typedef    finds typedefs in the source code
     find_badmacros  finds macros that use braces incorrectly
@@ -796,3 +799,24 @@ typedef struct nameData
    pgsql/data directory. The client profile file will be put in the
    client's current directory. Linux requires a compile with
    -DLINUX_PROFILE for proper profiling.
+   
+  2.9) What is the timeline for the next major PostgreSQL release?
+  
+   The development schedule for the 8.3 release is:
+   
+          March 1, 2007
+          
+   Initial community review of all major feature patches
+          April 1, 2007
+          
+   Feature freeze, all patches must be submitted for review and
+          application
+          mid-May, 2007
+          
+   All patches applied, beta testing begins
+          July, 2007
+          
+   Release of 8.3.0
+          
+   Patches that appear after appropriate dates are typically not applied
+   but held for the next major release.
diff --git a/doc/FAQ_HPUX b/doc/FAQ_HPUX
index 3df23654e37..c66b7f9ec85 100644
--- a/doc/FAQ_HPUX
+++ b/doc/FAQ_HPUX
@@ -3,7 +3,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL
 HP-UX Specific
 TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
 =======================================================
-last updated:           $Date: 2006/12/11 22:48:07 $
+last updated:           $Date: 2007/01/05 20:55:28 $
 
 current maintainer:     Tom Lane (tgl@sss.pgh.pa.us)
 original author:        Tom Lane (tgl@sss.pgh.pa.us)
diff --git a/doc/FAQ_IRIX b/doc/FAQ_IRIX
index 98a473f34ae..dbddc32c5be 100644
--- a/doc/FAQ_IRIX
+++ b/doc/FAQ_IRIX
@@ -3,7 +3,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL
 IRIX Specific
 TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
 =======================================================
-last updated:           $Date: 2006/12/11 22:48:07 $
+last updated:           $Date: 2007/01/05 20:55:28 $
 
 current maintainer:     Luis Amigo (lamigo@atc.unican.es)
 original author:        Luis Amigo (lamigo@atc.unican.es)
diff --git a/doc/FAQ_SCO b/doc/FAQ_SCO
index ce2cbea3638..309b66b656f 100644
--- a/doc/FAQ_SCO
+++ b/doc/FAQ_SCO
@@ -3,7 +3,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL
 IRIX Specific
 TO BE READ IN CONJUNCTION WITH THE NORMAL FAQ
 =======================================================
-last updated:           $Date: 2006/12/11 22:48:07 $
+last updated:           $Date: 2007/01/05 20:55:28 $
 
 current maintainer:     Billy G. Allie (Bill.Allie@mug.org)
 original author:        Andrew Merrill (andrew@compclass.com)
diff --git a/doc/FAQ_Solaris b/doc/FAQ_Solaris
index e44ffa05135..e08902970e7 100644
--- a/doc/FAQ_Solaris
+++ b/doc/FAQ_Solaris
@@ -3,7 +3,7 @@ Frequently Asked Questions (FAQ) for PostgreSQL
 Sun Solaris specific
 To be read in conjunction with the installation instructions.
 ============================================================
-Last updated:        $Date: 2006/12/11 22:48:07 $
+Last updated:        $Date: 2007/01/05 20:55:28 $
 
 
 Contents:
diff --git a/doc/bug.template b/doc/bug.template
index b842d3eebb3..7bad79fdb11 100644
--- a/doc/bug.template
+++ b/doc/bug.template
@@ -31,7 +31,7 @@ System Configuration:
 
   Operating System (example: Linux 2.4.18)	:
 
-  PostgreSQL version (example: PostgreSQL 8.2)  :  PostgreSQL 8.2
+  PostgreSQL version (example: PostgreSQL 8.2.1):  PostgreSQL 8.2.1
 
   Compiler used (example: gcc 3.3.5)		:
 
diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html
index b04db6b4748..868c87e58a2 100644
--- a/doc/src/FAQ/FAQ.html
+++ b/doc/src/FAQ/FAQ.html
@@ -10,7 +10,7 @@
   alink="#0000ff">
     <H1>Frequently Asked Questions (FAQ) for PostgreSQL</H1>
 
-    <P>Last updated: Mon Dec 11 17:45:54 EST 2006</P>
+    <P>Last updated: Fri Jan  5 15:40:20 EST 2007</P>
 
     <P>Current maintainer: Bruce Momjian (<A href=
     "mailto:bruce@momjian.us">bruce@momjian.us</A>)
@@ -219,7 +219,7 @@
 
     <H3 id="item1.6">1.6) What is the most recent release?</H3>
 
-    <P>The latest release of PostgreSQL is version 8.2.0.</P>
+    <P>The latest release of PostgreSQL is version 8.2.1.</P>
 
     <P>We plan to have a major release every year, with minor releases
     every few months.</P>
diff --git a/doc/src/FAQ/FAQ_DEV.html b/doc/src/FAQ/FAQ_DEV.html
index ad3358fe976..0cdffa28722 100644
--- a/doc/src/FAQ/FAQ_DEV.html
+++ b/doc/src/FAQ/FAQ_DEV.html
@@ -13,7 +13,7 @@
     <H1>Developer's Frequently Asked Questions (FAQ) for
     PostgreSQL</H1>
 
-    <P>Last updated: Mon Nov 13 23:18:46 EST 2006</P>
+    <P>Last updated: Thu Jan  4 16:00:00 EST 2007</P>
 
     <P>Current maintainer: Bruce Momjian (<A href=
     "mailto:bruce@momjian.us">bruce@momjian.us</A>)<BR>
@@ -24,7 +24,7 @@
     "http://www.postgresql.org/docs/faqs.FAQ_DEV.html">http://www.postgresql.org/docs/faqs.FAQ_DEV.html</A>.</P>
     <HR>
     <BR>
-     
+
 
       <H2>General Questions</H2>
     <A href="#item1.1">1.1</A>) How do I get involved in PostgreSQL
@@ -55,7 +55,9 @@
     assistance?<BR>
      <A href="#item1.18">1.18</A>) How do I get involved in PostgreSQL web
     site development?<BR>
-     
+     <A href="#item1.19">1.19</A>) What is the timeline for the next major
+    PostgreSQL release?<BR>
+
 
       <H2>Technical Questions</H2>
     <A href="#item2.1">2.1</A>) How do I efficiently access information in
@@ -74,7 +76,7 @@
      <A href="#item2.8">2.8</A>) What debugging features are available?<BR>
 
      <BR>
-     
+
     <HR>
 
     <H2>General Questions</H2>
@@ -128,7 +130,7 @@
     in <I>doc/TODO</I> in the source distribution or at <A href=
     "http://www.postgresql.org/docs/faqs.TODO.html">
     http://www.postgresql.org/docs/faqs.TODO.html</A>.
-    
+
 
     <P>You can learn more about these features by consulting the
     archives, the SQL standards and the recommend texts (see <A href=
@@ -145,7 +147,9 @@
     use, and any user-visible changes (new syntax, etc). For complex
     patches, it is important to get community feeback on your proposal
     before starting work. Failure to do so might mean your patch is
-    rejected.</P>
+    rejected.  If your work is being sponsored by a company, read this
+    <a href="http://momjian.us/main/writings/pgsql/company_contributions/">
+    article</a> for tips on being more effective.</P>
 
     <P>A web site is maintained for patches awaiting review,
     <a href="http://momjian.postgresql.org/cgi-bin/pgpatches">
@@ -153,7 +157,7 @@
     those that are being kept for the next release,
     <a href="http://momjian.postgresql.org/cgi-bin/pgpatches_hold">
     http://momjian.postgresql.org/cgi-bin/pgpatches_hold</a>.</P>
-    
+
     <H3 id="item1.5">1.5) I've developed a patch, what next?</H3>
 
     <P>You will need to submit the patch to pgsql-patches@postgresql.org. It
@@ -180,7 +184,7 @@
     <I>src/tools/make_diff/difforig</I> useful. (Unified diffs are only
     preferable if the file changes are single-line changes and do not
     rely on surrounding lines.)</li>
-    
+
     <li>PostgreSQL is licensed under a BSD license, so any submissions must 
     conform to the BSD license to be included. If you use code that is 
     available under some other license that is BSD compatible (eg. public 
@@ -300,7 +304,7 @@
     ccsym           find standard defines made by your compiler
      copyright       fixes copyright notices
 
-    entab           converts tabs to spaces, used by pgindent
+    entab           converts spaces to tabs, used by pgindent
     find_static     finds functions that could be made static
     find_typedef    finds typedefs in the source code
     find_badmacros  finds macros that use braces incorrectly
@@ -523,7 +527,7 @@
    <P>We try to build on as many different canonical distributions as we can. 
    Currently we are able to build on Red Hat Linux 9, RHEL 3 and above, 
    and all Fedora Core Linux releases.</P>
-   
+
    <P>To test the binaries, we install them on our local machines and run
    regression tests. If the package builders uses postgres user to build the
    rpms, then it is possible to run regression tests during RPM builds.</P>
@@ -545,14 +549,14 @@
    is possible. Only the standard released 'official to that release'
    compiler is used -- and only the standard official kernel is used as
    well.</P>
-   
+
    <P>PGDG RPM Building Project does not build RPMs for Mandrake .</P>
 
    <P>We usually have only one SRPM for all platforms. This is because of our 
    limited resources. However, on some cases, we may distribute different 
    SRPMs for different platforms, depending on possible compilation problems,
    especially on older distros.</P>
-   
+
    <P>Please note that this is a volunteered job -- We are doing our best to 
    keep  packages up to date. We, at least, provide SRPMs for all platforms. 
    For example, if you do not find a RHEL 4 x86_64 RPM in our FTP site, it 
@@ -834,7 +838,7 @@
 <PRE>
 <CODE> List                *list;
     ListCell    *i;
-    
+
     foreach(i, list)
     {
         Var *var = lfirst(i);
@@ -937,57 +941,78 @@
 
     <H3 id="item2.7">2.7) What is CommandCounterIncrement()?</H3>
 
-    <P>Normally, transactions can not see the rows they modify. This
-    allows <CODE>UPDATE foo SET x = x + 1</CODE> to work correctly.</P>
+    <P>Normally, transactions can not see the rows they modify.
+    This allows <CODE>UPDATE foo SET x = x + 1</CODE> to work
+    correctly.</P>
 
-    <P>However, there are cases where a transactions needs to see rows
-    affected in previous parts of the transaction. This is accomplished
-    using a Command Counter. Incrementing the counter allows
-    transactions to be broken into pieces so each piece can see rows
-    modified by previous pieces. <I>CommandCounterIncrement()</I>
+    <P>However, there are cases where a transactions needs to see
+    rows affected in previous parts of the transaction. This is
+    accomplished using a Command Counter. Incrementing the counter
+    allows transactions to be broken into pieces so each piece can
+    see rows modified by previous pieces. <I>CommandCounterIncrement()</I>
     increments the Command Counter, creating a new part of the
     transaction.</P>
 
-    <H3 id="item2.8">2.8) What debugging features are
-    available?</H3>
+    <H3 id="item2.8">2.8) What debugging features are available?</H3>
 
     <P>First, try running <I>configure</I> with the --enable-cassert
-    option, many <I>assert()</I>s monitor the progress of the backend
-    and halt the program when something unexpected occurs.</P>
-
-    <P>The <I>postmaster</I> has a <I>-d</I> option that allows even more
-    detailed information to be reported. The <I>-d</I> option takes a
-    number that specifies the debug level. Be warned that high debug
-    level values generate large log files.</P>
-
-    <P>If the <I>postmaster</I> is not running, you can actually run the
-    <I>postgres</I> backend from the command line, and type your
-    <SMALL>SQL</SMALL> statement directly. This is recommended
-    <B>only</B> for debugging purposes. If you have compiled with debugging
-    symbols, you can use a debugger to see what is happening. Because
-    the backend was not started from <I>postmaster</I>, it is not
-    running in an identical environment and locking/backend interaction
-    problems might not be duplicated.</P>
-
-    <P>If the <I>postmaster</I> is running, start <I>psql</I> in one
-    window, then find the <SMALL>PID</SMALL> of the <I>postgres</I>
+    option, many <I>assert()</I>s monitor the progress of the
+    backend and halt the program when something unexpected occurs.</P>
+
+    <P>The <I>postmaster</I> has a <I>-d</I> option that allows
+    even more detailed information to be reported. The <I>-d</I>
+    option takes a number that specifies the debug level. Be warned
+    that high debug level values generate large log files.</P>
+
+    <P>If the <I>postmaster</I> is not running, you can actually
+    run the <I>postgres</I> backend from the command line, and type
+    your <SMALL>SQL</SMALL> statement directly. This is recommended
+    <B>only</B> for debugging purposes. If you have compiled with
+    debugging symbols, you can use a debugger to see what is
+    happening. Because the backend was not started from <I>postmaster</I>,
+    it is not running in an identical environment and locking/backend
+    interaction problems might not be duplicated.</P>
+
+    <P>If the <I>postmaster</I> is running, start <I>psql</I> in
+    one window, then find the <SMALL>PID</SMALL> of the <I>postgres</I>
     process used by <I>psql</I> using <CODE>SELECT pg_backend_pid()</CODE>.
     Use a debugger to attach to the <I>postgres</I> <SMALL>PID</SMALL>.
-    You can set breakpoints in the debugger and issue queries from the
-    other.  If you are looking to find the location that is generating
-    an error or log message, set a breakpoint at <I>errfinish</I>.
-
-    <I>psql</I>. If you are debugging <I>postgres</I> startup, you can
-    set PGOPTIONS="-W n", then start <I>psql</I>. This will cause startup
-    to delay for <I>n</I> seconds so you can attach to the process with
-    the debugger, set any breakpoints, and continue through the startup
-    sequence.</P>
-
-    <P>You can also compile with profiling to see what functions are
-    taking execution time. The backend profile files will be deposited
-    in the <I>pgsql/data</I> directory. The client profile file will be
-    put in the client's current directory. Linux requires a compile with
-    <I>-DLINUX_PROFILE</I> for proper profiling.</P>
+    You can set breakpoints in the debugger and issue queries from
+    the other.  If you are looking to find the location that is
+    generating an error or log message, set a breakpoint at
+    <I>errfinish</I>.
+
+    <I>psql</I>. If you are debugging <I>postgres</I> startup, you
+    can set PGOPTIONS="-W n", then start <I>psql</I>. This will
+    cause startup to delay for <I>n</I> seconds so you can attach
+    to the process with the debugger, set any breakpoints, and
+    continue through the startup sequence.</P>
+
+    <P>You can also compile with profiling to see what functions
+    are taking execution time. The backend profile files will be
+    deposited in the <I>pgsql/data</I> directory. The client profile
+    file will be put in the client's current directory. Linux
+    requires a compile with <I>-DLINUX_PROFILE</I> for proper
+    profiling.</P>
+
+    <H3 id="item2.9">2.9) What is the timeline for the next major
+    PostgreSQL release?<BR>
+
+    <P>The development schedule for the 8.3 release is:</P>
+    <DL>
+    <DD>March 1, 2007</DD>
+    <DT>Initial community review of all major feature patches</DT>
+    <DD>April 1, 2007</DD>
+    <DT>Feature freeze, all patches must be submitted for review and application</DT>
+    <DD>mid-May, 2007</DD>
+    <DT>All patches applied, beta testing begins</DT>
+    <DD>July, 2007</DD>
+    <DT>Release of 8.3.0</DT>
+    </DL>
+
+    <P>Patches that appear after appropriate dates are typically
+    not applied but held for the next major release.</P>
+
   </BODY>
 </HTML>
 
diff --git a/src/include/pg_config.h.win32 b/src/include/pg_config.h.win32
index b279ef1186b..21e0cc1053f 100644
--- a/src/include/pg_config.h.win32
+++ b/src/include/pg_config.h.win32
@@ -568,16 +568,16 @@
 #define PACKAGE_NAME "PostgreSQL"
 
 /* Define to the full name and version of this package. */
-#define PACKAGE_STRING "PostgreSQL 8.2"
+#define PACKAGE_STRING "PostgreSQL 8.2.1"
 
 /* Define to the version of this package. */
-#define PACKAGE_VERSION "8.2"
+#define PACKAGE_VERSION "8.2.1"
 
 /* PostgreSQL version as a string */
-#define PG_VERSION "8.2"
+#define PG_VERSION "8.2.1"
 
 /* PostgreSQL version as a number */
-#define PG_VERSION_NUM 80200
+#define PG_VERSION_NUM 80201
 
 /* Define to the one symbol short name of this package. */
 #define PACKAGE_TARNAME "postgresql"
diff --git a/src/interfaces/libpq/libpq.rc.in b/src/interfaces/libpq/libpq.rc.in
index ed45a5fde3c..c438f760aa8 100644
--- a/src/interfaces/libpq/libpq.rc.in
+++ b/src/interfaces/libpq/libpq.rc.in
@@ -1,8 +1,8 @@
 #include <winver.h>
 
 VS_VERSION_INFO VERSIONINFO
- FILEVERSION 8,2,0,0
- PRODUCTVERSION 8,2,0,0
+ FILEVERSION 8,2,1,0
+ PRODUCTVERSION 8,2,1,0
  FILEFLAGSMASK 0x3fL
  FILEFLAGS 0
  FILEOS VOS__WINDOWS32
@@ -15,13 +15,13 @@ BEGIN
         BEGIN
             VALUE "CompanyName", "\0"
             VALUE "FileDescription", "PostgreSQL Access Library\0"
-            VALUE "FileVersion", "8.2.0\0"
+            VALUE "FileVersion", "8.2.1\0"
             VALUE "InternalName", "libpq\0"
             VALUE "LegalCopyright", "Copyright (C) 2005\0"
             VALUE "LegalTrademarks", "\0"
             VALUE "OriginalFilename", "libpq.dll\0"
             VALUE "ProductName", "PostgreSQL\0"
-            VALUE "ProductVersion", "8.2.0\0"
+            VALUE "ProductVersion", "8.2.1\0"
         END
     END
     BLOCK "VarFileInfo"
diff --git a/src/port/win32ver.rc b/src/port/win32ver.rc
index 154d81e5f93..3d8620be8e1 100644
--- a/src/port/win32ver.rc
+++ b/src/port/win32ver.rc
@@ -2,8 +2,8 @@
 #include "pg_config.h"
 
 VS_VERSION_INFO VERSIONINFO
- FILEVERSION    8,2,0,0
- PRODUCTVERSION 8,2,0,0
+ FILEVERSION    8,2,1,0
+ PRODUCTVERSION 8,2,1,0
  FILEFLAGSMASK  0x17L
  FILEFLAGS      0x0L
  FILEOS         VOS_NT_WINDOWS32
@@ -17,7 +17,7 @@ BEGIN
    VALUE "CompanyName",      "PostgreSQL Global Development Group"
    VALUE "FileDescription",  FILEDESC
    VALUE "FileVersion",      PG_VERSION
-   VALUE "LegalCopyright", "Portions Copyright (c) 1996-2006, PostgreSQL Global Development Group. Portions Copyright (c) 1994, Regents of the University of California."
+   VALUE "LegalCopyright", "Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group. Portions Copyright (c) 1994, Regents of the University of California."
    VALUE "ProductName",      "PostgreSQL"
    VALUE "ProductVersion",   PG_VERSION
   END