Fix character string comparison for Windows locales that
consider different character combinations as equal
(Tom)

This fix applies only on Windows and only when using
UTF-8 database encoding. The same fix was made for all
other cases over two years ago, but Windows with UTF-8 uses
a separate code path that was not updated. If you are using
a locale that considers some non-identical strings as
equal, you may need to REINDEX to
fix existing indexes on textual columns.

Repair potential deadlock between concurrent VACUUM FULL operations on different system
catalogs (Tom)

Fix longstanding LISTEN/NOTIFY race
condition (Tom)

In rare cases a session that had just executed a
LISTEN might not get a
notification, even though one would be expected because the
concurrent transaction executing NOTIFY was observed to commit later.

A side effect of the fix is that a transaction that has
executed a not-yet-committed LISTEN command will not see any row in
pg_listener for the LISTEN, should it choose to look; formerly
it would have. This behavior was never documented one way
or the other, but it is possible that some applications
depend on the old behavior.

Disallow LISTEN and UNLISTEN within a prepared transaction
(Tom)

This was formerly allowed but trying to do it had
various unpleasant consequences, notably that the
originating backend could not exit as long as an UNLISTEN remained uncommitted.

Disallow dropping a temporary table within a prepared
transaction (Heikki)

This was correctly disallowed by 8.1, but the check was
inadvertently broken in 8.2.

Fix rare crash when an error occurs during a query using
a hash index (Heikki)

Submit correction

If you see anything in the documentation that is not correct, does not match
your experience with the particular feature or requires further clarification,
please use
this form
to report a documentation issue.