Michael Glaesemann

Marko Kreen

can create or modify rules for the table.  Do setRuleCheckAsUser() while
loading rules into the relcache, rather than when defining a rule.  This
ensures that permission checks for tables referenced in a rule are done with
respect to the current owner of the rule's table, whereas formerly ALTER TABLE
OWNER would fail to update the permission checking for associated rules.
Removal of separate RULE privilege is needed to prevent various scenarios
in which a grantee of RULE privilege could effectively have any privilege
of the table owner.  For backwards compatibility, GRANT/REVOKE RULE is still
accepted, but it doesn't do anything.  Per discussion here:
http://archives.postgresql.org/pgsql-hackers/2006-04/msg01138.php

fix suggestion from Peter.

'GIN FailedAssertions on Itanium2 with Intel compiler' in pgsql-hackers,
http://archives.postgresql.org/pgsql-hackers/2006-08/msg01914.php

Per discussion
http://archives.postgresql.org/pgsql-hackers/2006-08/msg01409.php

dbase, dbmirror, fulltextindex, mac, userlock; or abandoned: mSQL-interface,
tips.

Added some interval checks to regression suite.

Fixed ecpglib trying to read one character after end-of-string.
Fixed port number setting in regression suite.

Christopher Kings-Lynne

Bruce, Michael Glaesemann

Jun Kuwamura

position_in_unique_constraint (column newly added per SQL2003).
Greg Mullane

Albe Laurenz

second scan of table).

Gregory Stark

Magnus Hagander

the target relation(s).  There might be some cases where we could discard
the pending event instead, but for the moment a conservative approach
seems sufficient.  Per report from Markus Schiltknecht and subsequent
discussion.

of 'S', and the views were not checking for table visibility with
regards to temporary tables and sequences.

Greg Sabino Mullane

Christopher Kings-Lynne

Simon Riggs

some platforms.

working in a multibyte encoding.  This fixes the problems exhibited in
bug #1931 and other reports of ILIKE misbehavior in UTF8 encoding.
It's a pretty grotty solution though --- should rethink how to do it
after we install better locale support, someday.

Author: Victor Wagner <vitus@cryptocom.ru>

unportable elog(NOTICE) report, fix install/uninstall sequence.
Itagaki Takahiro

cascaded first to days and only what is leftover into seconds.  This
seems to satisfy the principle of least surprise given the general
conversion to three-part interval values --- it was an oversight that
these cases weren't dealt with in 8.1.  Michael Glaesemann

of the syntax as this fundamentally dead-end approach can, in particular
combinations of single and multi column assignments.  Improve rather
inadequate documentation and provide some regression tests.

is only invoked on completed WAL segments, period --- there's no 'by
default' about it.

PGPROC array into snapshots, and use this information to avoid visits
to pg_subtrans in HeapTupleSatisfiesSnapshot.  This appears to solve
the pg_subtrans-related context swap storm problem that's been reported
by several people for 8.1.  While at it, modify GetSnapshotData to not
take an exclusive lock on ProcArrayLock, as closer analysis shows that
shared lock is always sufficient.
Itagaki Takahiro and Tom Lane