as per bug #1249; and remove the last vestiges of using \connect to
change authorization.

rather than when returning to the idle loop.  This makes no particular
difference for interactively-issued queries, but it makes a big difference
for queries issued within functions: trigger execution now occurs before
the calling function is allowed to proceed.  This responds to numerous
complaints about nonintuitive behavior of foreign key checking, such as
http://archives.postgresql.org/pgsql-bugs/2004-09/msg00020.php, and
appears to be required by the SQL99 spec.
Also take the opportunity to simplify the data structures used for the
pending-trigger list, rename them for more clarity, and squeeze out a
bit of space.

> * Make row-wise comparisons work per SQL spec
>

> * Remove Win32 rename/unlink looping if unnecessary

-It fixes up some bugs with handling setval calls
-Adds upgrade instructions from prior versions
-Improved the sample config file
-Fixed some things in the clean_pending script

name first, make sure \di+ shows description last, and make \dl SQL look
a little more standard.

pgtest.

status.  In particular, I see no reason for deferredTriggerCheckState
to make an explicit entry to note that a particular trigger has its
default state --- that just clutters a list that should normally be
empty or very short.  I have plans to revise this module much more
heavily, but this is a simple separable improvement.

missing the ability to schema-qualify constraint names.

discussion.

deadlock on Win32.  Magnus Hagander

This prevented statement_timeout from working.
Magnus Hagander

Asserts would lead to a server core dump if an error occurred while
trying to abort a failed subtransaction (thereby leading to re-execution
of whatever parts of AbortSubTransaction had already run).  This of course
does not prevent such an error from creating an infinite loop, but at
least we don't make the situation worse.  Responds to an open item on
the subtransactions to-do list.

never worked, but it particularly doesn't work now.

during transaction abort.  Add a regression test case to catch related
mistakes in future.  Alvaro Herrera and Tom Lane.

FATAL when it detects a nonzero reference count.  Reduce to ERROR.

subtrans segments.  Per Greg Mullane and Chris K-L.

earned ...