aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* 9.3 release notes: apply fixes suggested by AlvaroBruce Momjian2013-04-22
|
* 9.3 release notes: update streaming replication speedupsBruce Momjian2013-04-22
| | | | Andres Freund
* doc: Improve example formattingPeter Eisentraut2013-04-21
| | | | Erwin Brandstetter
* doc: Fix syntax in examplePeter Eisentraut2013-04-21
| | | | | | | LANGUAGE 'plpgsql' no longer works. The single quotes need to be removed. Erwin Brandstetter
* In 9.3 release notes, split up itemsBruce Momjian2013-04-21
| | | | | | Split log shipping speed improvement and fail-over speed improvement items. Per request from Simon
* 9.3 release note adjustments per request from Andres FreundBruce Momjian2013-04-21
|
* Remove 9.3 item about fixing DROP INDEX CONCURRENTLYBruce Momjian2013-04-21
| | | | Already fixed in back branch.
* 9.3 release note fixesBruce Momjian2013-04-21
| | | | | Move commit_delay, fix Zoltan's name, and adjust range type histogram text.
* Adjust 9.3 release notes per request from SimonBruce Momjian2013-04-21
|
* Reorder 9.3 release note itemsBruce Momjian2013-04-21
| | | | Typo fix from David Fetter.
* More 9.3 release note reorderingsBruce Momjian2013-04-20
|
* Fix Gilles Darold's name in 9.3 release notes.Bruce Momjian2013-04-20
|
* Fix longstanding race condition in plancache.c.Tom Lane2013-04-20
| | | | | | | | | | | | | | | | | | | 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.
* Reorder some 9.3 release item entriesBruce Momjian2013-04-20
| | | | More to go.
* Push 9.3 release SGML fileBruce Momjian2013-04-20
| | | | Forgotten in previous commit.
* Publish draft 9.3 release notesBruce Momjian2013-04-20
| | | | No links added yet.
* doc: Mention SATA alongside IDE for LinuxPeter Eisentraut2013-04-20
| | | | suggested by Jov
* Clean up references to SQL92Peter Eisentraut2013-04-20
| | | | | | In most cases, these were just references to the SQL standard in general. In a few cases, a contrast was made between SQL92 and later standards -- those have been kept unchanged.
* Improve error message when an FDW doesn't support WHERE CURRENT OF.Tom Lane2013-04-19
| | | | | | | If an FDW fails to take special measures with a CurrentOfExpr, we will end up trying to execute it as an ordinary qual, which was being treated as a purely internal failure condition. Provide a more user-oriented error message for such cases.
* Don't try to pass -I switch to postmaster in contrib/start-scripts/linux.Tom Lane2013-04-19
| | | | | Undo thinko in commit 87306184580c9c49717b00d48a2f9e717f21e0a8. Per bug #8098 from Catherine Devlin.
* Fix typo in comment.Robert Haas2013-04-19
| | | | Fabrízio de Royes Mello
* Standardize spelling of "nonblocking"Peter Eisentraut2013-04-18
| | | | | Only adjusted the user-exposed messages and documentation, not all source code comments.
* pg_upgrade: Add checksum C commentBruce Momjian2013-04-17
| | | | We might eventually allow checksum to no-checksum upgrades.
* sepgsql: Minor improvement to test script, doc fix.Robert Haas2013-04-17
| | | | KaiGai Kohei
* sepgsql: One more getObjectIdentity in lieu of getObjectDescription.Robert Haas2013-04-17
| | | | KaiGai Kohei, based on a suggestion from Álvaro Herrera
* doc: Update PQgetssl() documentationPeter Eisentraut2013-04-16
| | | | | The return type of PQgetssl() was changed from SSL* to void* a long time ago, but the documentation was not updated.
* pgindent: add newline to die() so script line number is not reported on ↵Bruce Momjian2013-04-16
| | | | failure.
* Remove some unused and seldom used fields from RelationAmInfo.Heikki Linnakangas2013-04-16
| | | | | | | This saves some memory from each index relcache entry. At least on a 64-bit machine, it saves just enough to shrink a typical relcache entry's memory usage from 2k to 1k. That's nice if you have a lot of backends and a lot of indexes.
* Fix function return type confusionPeter Eisentraut2013-04-15
| | | | | When parse_hba_line's return type was changed from bool to a pointer, the MANDATORY_AUTH_ARG macro wasn't adjusted.
* Mark json IO and extraction functions immutable.Andrew Dunstan2013-04-15
| | | | | | Per complaint from Hubert Depesz Lubaczewski. Catalog version bumped.
* Correct handling of NULL arguments in json funcs.Andrew Dunstan2013-04-15
| | | | Per gripe from Tom Lane.
* Improve GiST index search performance for trigram regex queries.Tom Lane2013-04-15
| | | | | | | | | | | The initial coding just descended the index if any of the target trigrams were possibly present at the next level down. But actually we can apply trigramsMatchGraph() so as to take advantage of AND requirements when there are some. The input data might contain false positive matches, but that can only result in a false positive result, not false negative, so it's safe to do it this way. Alexander Korotkov
* Add serial commaPeter Eisentraut2013-04-14
|
* pg_ctl: Add idempotent optionPeter Eisentraut2013-04-13
| | | | | | | | | | | | | This changes the behavior of the start and stop actions to exit successfully if the server was already started or stopped. This changes the default behavior of the start action: Before, if the server was already running, it would print a message and succeed. Now, that situation will result in an error. When running in idempotent mode, no message is printed and pg_ctl exits successfully. It was considered to just make the idempotent behavior the default and only option, but pg_upgrade needs the old behavior.
* Fix sporadic rebuilds for .pc filesPeter Eisentraut2013-04-12
| | | | | | | | | The build of .pc (pkg-config) files depends on all makefiles in use, and in dependency tracking mode, the previous coding ended up including /dev/null as a makefile. Apparently, on some platforms the modification time of /dev/null changes sporadically, and so the .pc files would end up being rebuilt every so often. Fix that by changing the makefile code to do without using /dev/null.
* Clean up the mess around EXPLAIN and materialized views.Tom Lane2013-04-12
| | | | | | | | | | | | | | | | | | | | | | | | | Revert the matview-related changes in explain.c's API, as per recent complaint from Robert Haas. The reason for these appears to have been principally some ill-considered choices around having intorel_startup do what ought to be parse-time checking, plus a poor arrangement for passing it the view parsetree it needs to store into pg_rewrite when creating a materialized view. Do the latter by having parse analysis stick a copy into the IntoClause, instead of doing it at runtime. (On the whole, I seriously question the choice to represent CREATE MATERIALIZED VIEW as a variant of SELECT INTO/CREATE TABLE AS, because that means injecting even more complexity into what was already a horrid legacy kluge. However, I didn't go so far as to rethink that choice ... yet.) I also moved several error checks into matview parse analysis, and made the check for external Params in a matview more accurate. In passing, clean things up a bit more around interpretOidsOption(), and fix things so that we can use that to force no-oids for views, sequences, etc, thereby eliminating the need to cons up "oids = false" options when creating them. catversion bump due to change in IntoClause. (I wonder though if we really need readfuncs/outfuncs support for IntoClause anymore.)
* pgindent: improve error messagesBruce Momjian2013-04-12
| | | | per suggestion from Gurjeet Singh
* pgindent: fix downloading of BSD indent binaryBruce Momjian2013-04-12
| | | | | | Also fix accessing pgentab binary and tar. Gurjeet Singh
* sepgsql: Enforce db_procedure:{execute} permission.Robert Haas2013-04-12
| | | | | | | To do this, we add an additional object access hook type, OAT_FUNCTION_EXECUTE. KaiGai Kohei
* Minor wording corrections for object-access hook stuff.Robert Haas2013-04-12
| | | | KaiGai Kohei
* sepgql: Use getObjectIdentity rather than getObjectDescription.Robert Haas2013-04-12
| | | | KaiGai Kohei, based on a suggestion from Álvaro Herrera
* Document that git_changelog needs updating for major version stamping.Bruce Momjian2013-04-11
|
* Remove quotes around SQL statement in error messageAlvaro Herrera2013-04-11
|
* Fix confusion between ObjectType and ObjectClassAlvaro Herrera2013-04-11
| | | | Per report by Will Leinweber and Peter Eisentraut
* doc: Update DTrace informationPeter Eisentraut2013-04-10
| | | | | The old web site link no longer worked, and some information was outdated.
* Update the description for the graphical installersMagnus Hagander2013-04-10
| | | | | Remove references to "one click", as we're not supposed to call them that anymore.
* Fix SIGUSR1 handling by unconnected bgworkersAlvaro Herrera2013-04-10
| | | | | | | | Latch activity was not being detected by non-database-connected workers; the SIGUSR1 signal handler which is normally in charge of that was set to SIG_IGN. Create a simple handler to call latch_sigusr1_handler instead. Robert Haas (bug report and suggested fix)
* Fix SIGHUP handling by unconnected bgworkersAlvaro Herrera2013-04-10
| | | | | | | | Add a SignalUnconnectedWorkers() call so that non-database-connected background workers are also notified when postmaster is SIGHUPped. Previously, only database-connected workers were. Michael Paquier (bug report and fix)
* Make contrib/pg_trgm also support regex searches with GiST indexes.Tom Lane2013-04-10
| | | | | | | | This wasn't addressed in the original patch, but it doesn't take very much additional code to cover the case, so let's get it done. Since pg_trgm 1.1 hasn't been released yet, I just changed the definition of what's in it, rather than inventing a 1.2.
* Make worker_spi sample code more completeAlvaro Herrera2013-04-10
| | | | | | | | Make use of some GUC variables, and add SIGHUP handling to reload the config file. Patch submitted by Guillaume Lelarge. Also, report to pg_stat_activity. Per report from Marc Cousin, add setting of statement start time.