Update FAQ.

1 files changed, 16 insertions, 48 deletions

diff --git a/doc/src/FAQ/FAQ.html b/doc/src/FAQ/FAQ.html
index 4324be49e40..59ad51047f8 100644
--- a/doc/src/FAQ/FAQ.html
+++ b/doc/src/FAQ/FAQ.html
@@ -127,17 +127,15 @@
     <SMALL>TID</SMALL>?<BR>
      <A href="#4.18">4.18</A>) What is the meaning of some of the terms
     used in PostgreSQL?<BR>
-     <A href="#4.19">4.19</A>) Why do I get the error <I>"FATAL: palloc
-    failure: memory exhausted?"</I><BR>
-     <A href="#4.20">4.20</A>) How do I tell what PostgreSQL version I
+     <A href="#4.19">4.19</A>) How do I tell what PostgreSQL version I
     am running? <BR>
-     <A href="#4.21">4.21</A>) My large-object operations get
+     <A href="#4.20">4.20</A>) My large-object operations get
     <I>invalid large obj descriptor.</I> Why?<BR>
-     <A href="#4.22">4.22</A>) How do I create a column that will
+     <A href="#4.21">4.21</A>) How do I create a column that will
     default to the current time?<BR>
-     <A href="#4.23">4.23</A>) Why are my subqueries using
+     <A href="#4.22">4.22</A>) Why are my subqueries using
     <CODE><SMALL>IN</SMALL></CODE> so slow?<BR>
-     <A href="#4.24">4.24</A>) How do I perform an outer join?<BR>
+     <A href="#4.23">4.23</A>) How do I perform an outer join?<BR>
      
 
     <CENTER>
@@ -145,14 +143,11 @@
     </CENTER>
     <A href="#5.1">5.1</A>) I wrote a user-defined function. When I run
     it in <I>psql,</I> why does it dump core?<BR>
-     <A href="#5.2">5.2</A>) What does the message
-    <I>"NOTICE:PortalHeapMemoryFree: 0x402251d0 not in alloc set!"</I>
-    mean?<BR>
-     <A href="#5.3">5.3</A>) How can I contribute some nifty new types
+     <A href="#5.2">5.2</A>) How can I contribute some nifty new types
     and functions to PostgreSQL?<BR>
-     <A href="#5.4">5.4</A>) How do I write a C function to return a
+     <A href="#5.3">5.3</A>) How do I write a C function to return a
     tuple?<BR>
-     <A href="#5.5">5.5</A>) I have changed a source file. Why does the
+     <A href="#5.4">5.4</A>) I have changed a source file. Why does the
     recompile not see the change?<BR>
      
     <HR>
@@ -1137,32 +1132,13 @@ BYTEA           bytea           variable-length byte array (null-safe)
     <P>A list of general database terms can be found at: <A href=
     "http://www.comptechnews.com/~reaster/dbdesign.html">http://www.comptechnews.com/~reaster/dbdesign.html</A></P>
 
-    <H4><A name="4.19">4.19</A>) Why do I get the error <I>"FATAL:
-    palloc failure: memory exhausted?"</I><BR>
-    </H4>
-
-    <P>It is possible you have run out of virtual memory on your
-    system, or your kernel has a low limit for certain resources. Try
-    this before starting the <I>postmaster:</I></P>
-<PRE>
-    ulimit -d 65536
-    limit datasize 64m
-</PRE>
-    Depending on your shell, only one of these may succeed, but it will
-    set your process data segment limit much higher and perhaps allow
-    the query to complete. This command applies to the current process,
-    and all subprocesses created after the command is run. If you are
-    having a problem with the <SMALL>SQL</SMALL> client because the
-    backend is returning too much data, try it before starting the
-    client. 
-
-    <H4><A name="4.20">4.20</A>) How do I tell what PostgreSQL version
+    <H4><A name="4.19">4.19</A>) How do I tell what PostgreSQL version
     I am running?<BR>
     </H4>
 
     <P>From <I>psql,</I> type <CODE>select version();</CODE></P>
 
-    <H4><A name="4.21">4.21</A>) My large-object operations get
+    <H4><A name="4.20">4.20</A>) My large-object operations get
     <I>invalid large obj descriptor.</I> Why?<BR>
     </H4>
 
@@ -1179,7 +1155,7 @@ BYTEA           bytea           variable-length byte array (null-safe)
     <P>If you are using a client interface like <SMALL>ODBC</SMALL> you
     may need to set <CODE>auto-commit off.</CODE></P>
 
-    <H4><A name="4.22">4.22</A>) How do I create a column that will
+    <H4><A name="4.21">4.21</A>) How do I create a column that will
     default to the current time?<BR>
     </H4>
 
@@ -1189,7 +1165,7 @@ BYTEA           bytea           variable-length byte array (null-safe)
 </CODE>
 </PRE>
 
-    <H4><A name="4.23">4.23</A>) Why are my subqueries using
+    <H4><A name="4.22">4.22</A>) Why are my subqueries using
     <CODE><SMALL>IN</SMALL></CODE> so slow?<BR>
     </H4>
 
@@ -1212,7 +1188,7 @@ BYTEA           bytea           variable-length byte array (null-safe)
 </PRE>
     We hope to fix this limitation in a future release. 
 
-    <H4><A name="4.24">4.24</A>) How do I perform an outer join?<BR>
+    <H4><A name="4.23">4.23</A>) How do I perform an outer join?<BR>
     </H4>
 
     <P>PostgreSQL 7.1 and later supports outer joins using the SQL
@@ -1264,28 +1240,20 @@ BYTEA           bytea           variable-length byte array (null-safe)
     <P>The problem could be a number of things. Try testing your
     user-defined function in a stand-alone test program first.</P>
 
-    <H4><A name="5.2">5.2</A>) What does the message
-    <I>"NOTICE:PortalHeapMemoryFree: 0x402251d0 not in alloc set!"</I>
-    mean?</H4>
-
-    <P>You are <I>pfree'</I>ing something that was not
-    <I>palloc'</I>ed. Beware of mixing <I>malloc/free</I> and
-    <I>palloc/pfree.</I></P>
-
-    <H4><A name="5.3">5.3</A>) How can I contribute some nifty new
+    <H4><A name="5.2">5.2</A>) How can I contribute some nifty new
     types and functions to PostgreSQL?</H4>
 
     <P>Send your extensions to the <I>pgsql-hackers</I> mailing list,
     and they will eventually end up in the <I>contrib/</I>
     subdirectory.</P>
 
-    <H4><A name="5.4">5.4</A>) How do I write a C function to return a
+    <H4><A name="5.3">5.3</A>) How do I write a C function to return a
     tuple?</H4>
 
     <P>This requires wizardry so extreme that the authors have never
     tried it, though in principle it can be done.</P>
 
-    <H4><A name="5.5">5.5</A>) I have changed a source file. Why does
+    <H4><A name="5.4">5.4</A>) I have changed a source file. Why does
     the recompile not see the change?</H4>
 
     <P>The <I>Makefiles</I> do not have the proper dependencies for