postgresql.git
12 years agoFix assertion failure for REFRESH MATERIALIZED VIEW in PL.
Kevin Grittner [Wed, 24 Apr 2013 13:39:06 +0000 (08:39 -0500)]
Fix assertion failure for REFRESH MATERIALIZED VIEW in PL.

This was due to incomplete implementation of rowcount reporting
for RMV, which was due to initial waffling on whether it should
be provided.  It seems unlikely to be a useful or universally
available  number as more sophisticated techniques for maintaining
matviews are added, so remove the partial support rather than
completing it.

Per report of Jeevan Chalke, but with a different fix

12 years agoMake fast promotion the default promotion mode.
Simon Riggs [Wed, 24 Apr 2013 11:21:18 +0000 (12:21 +0100)]
Make fast promotion the default promotion mode.
Continue to allow a request for synchronous
checkpoints as a mechanism in case of problems.

12 years ago9.3 release notes: adjustments per Alvaro
Bruce Momjian [Wed, 24 Apr 2013 03:21:09 +0000 (23:21 -0400)]
9.3 release notes:  adjustments per Alvaro

12 years ago9.3 release note updates from Dean Rasheed, Jov, Heikki Linnakangas,
Bruce Momjian [Tue, 23 Apr 2013 21:06:17 +0000 (17:06 -0400)]
9.3 release note updates from Dean Rasheed, Jov, Heikki Linnakangas,
Erikjan Rijkers

12 years agoRemove prototype for cube(text) function that doesn't exist anymore.
Heikki Linnakangas [Tue, 23 Apr 2013 10:48:14 +0000 (13:48 +0300)]
Remove prototype for cube(text) function that doesn't exist anymore.

Adrian Schreyer

12 years ago9.3 release notes: add diacritics
Bruce Momjian [Mon, 22 Apr 2013 21:17:00 +0000 (17:17 -0400)]
9.3 release notes: add diacritics

Alvaro Herrera

12 years ago9.3 release notes: adjustments per Alvaro and Robert
Bruce Momjian [Mon, 22 Apr 2013 20:05:06 +0000 (16:05 -0400)]
9.3 release notes:  adjustments per Alvaro and Robert

12 years agoMention in docs that you can create SP-GiST indexes on range types.
Heikki Linnakangas [Mon, 22 Apr 2013 18:51:14 +0000 (21:51 +0300)]
Mention in docs that you can create SP-GiST indexes on range types.

This is new in 9.3devel.

12 years ago9.3 release notes: apply fixes suggested by Alvaro
Bruce Momjian [Mon, 22 Apr 2013 18:33:28 +0000 (14:33 -0400)]
9.3 release notes:  apply fixes suggested by Alvaro

12 years ago9.3 release notes: update streaming replication speedups
Bruce Momjian [Mon, 22 Apr 2013 14:22:43 +0000 (10:22 -0400)]
9.3 release notes:  update streaming replication speedups

Andres Freund

12 years agodoc: Improve example formatting
Peter Eisentraut [Mon, 22 Apr 2013 02:21:29 +0000 (22:21 -0400)]
doc: Improve example formatting

Erwin Brandstetter

12 years agodoc: Fix syntax in example
Peter Eisentraut [Mon, 22 Apr 2013 02:16:12 +0000 (22:16 -0400)]
doc: Fix syntax in example

LANGUAGE 'plpgsql' no longer works.  The single quotes need to be
removed.

Erwin Brandstetter

12 years agoIn 9.3 release notes, split up items
Bruce Momjian [Mon, 22 Apr 2013 01:05:31 +0000 (21:05 -0400)]
In 9.3 release notes, split up items

Split log shipping speed improvement and fail-over speed improvement items.

Per request from Simon

12 years ago9.3 release note adjustments per request from Andres Freund
Bruce Momjian [Sun, 21 Apr 2013 14:08:58 +0000 (10:08 -0400)]
9.3 release note adjustments per request from Andres Freund

12 years agoRemove 9.3 item about fixing DROP INDEX CONCURRENTLY
Bruce Momjian [Sun, 21 Apr 2013 13:16:23 +0000 (09:16 -0400)]
Remove 9.3 item about fixing DROP INDEX CONCURRENTLY

Already fixed in back branch.

12 years ago9.3 release note fixes
Bruce Momjian [Sun, 21 Apr 2013 13:14:34 +0000 (09:14 -0400)]
9.3 release note fixes

Move commit_delay, fix Zoltan's name, and adjust range type histogram
text.

12 years agoAdjust 9.3 release notes per request from Simon
Bruce Momjian [Sun, 21 Apr 2013 13:05:16 +0000 (09:05 -0400)]
Adjust 9.3 release notes per request from Simon

12 years agoReorder 9.3 release note items
Bruce Momjian [Sun, 21 Apr 2013 04:57:18 +0000 (00:57 -0400)]
Reorder 9.3 release note items

Typo fix from David Fetter.

12 years agoMore 9.3 release note reorderings
Bruce Momjian [Sat, 20 Apr 2013 21:31:06 +0000 (17:31 -0400)]
More 9.3 release note reorderings

12 years agoFix Gilles Darold's name in 9.3 release notes.
Bruce Momjian [Sat, 20 Apr 2013 21:09:10 +0000 (17:09 -0400)]
Fix Gilles Darold's name in 9.3 release notes.

12 years agoFix longstanding race condition in plancache.c.
Tom Lane [Sat, 20 Apr 2013 20:59:21 +0000 (16:59 -0400)]
Fix longstanding race condition in plancache.c.

When creating or manipulating a cached plan for a transaction control
command (particularly ROLLBACK), we must not perform any catalog accesses,
since we might be in an aborted transaction.  However, plancache.c busily
saved or examined the search_path for every cached plan.  If we were
unlucky enough to do this at a moment where the path's expansion into
schema OIDs wasn't already cached, we'd do some catalog accesses; and with
some more bad luck such as an ill-timed signal arrival, that could lead to
crashes or Assert failures, as exhibited in bug #8095 from Nachiket Vaidya.
Fortunately, there's no real need to consider the search path for such
commands, so we can just skip the relevant steps when the subject statement
is a TransactionStmt.  This is somewhat related to bug #5269, though the
failure happens during initial cached-plan creation rather than
revalidation.

This bug has been there since the plan cache was invented, so back-patch
to all supported branches.

12 years agoReorder some 9.3 release item entries
Bruce Momjian [Sat, 20 Apr 2013 20:50:56 +0000 (16:50 -0400)]
Reorder some 9.3 release item entries

More to go.

12 years agoPush 9.3 release SGML file
Bruce Momjian [Sat, 20 Apr 2013 20:32:32 +0000 (16:32 -0400)]
Push 9.3 release SGML file

Forgotten in previous commit.

12 years agoPublish draft 9.3 release notes
Bruce Momjian [Sat, 20 Apr 2013 20:29:58 +0000 (16:29 -0400)]
Publish draft 9.3 release notes

No links added yet.

12 years agodoc: Mention SATA alongside IDE for Linux