summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2013-04-21Remove 9.3 item about fixing DROP INDEX CONCURRENTLYBruce Momjian
Already fixed in back branch.
2013-04-219.3 release note fixesBruce Momjian
Move commit_delay, fix Zoltan's name, and adjust range type histogram text.
2013-04-21Adjust 9.3 release notes per request from SimonBruce Momjian
2013-04-21Reorder 9.3 release note itemsBruce Momjian
Typo fix from David Fetter.
2013-04-20More 9.3 release note reorderingsBruce Momjian
2013-04-20Fix Gilles Darold's name in 9.3 release notes.Bruce Momjian
2013-04-20Reorder some 9.3 release item entriesBruce Momjian
More to go.
2013-04-20Push 9.3 release SGML fileBruce Momjian
Forgotten in previous commit.
2013-04-20Publish draft 9.3 release notesBruce Momjian
No links added yet.
2013-04-20doc: Mention SATA alongside IDE for LinuxPeter Eisentraut
suggested by Jov
2013-04-18Standardize spelling of "nonblocking"Peter Eisentraut
Only adjusted the user-exposed messages and documentation, not all source code comments.
2013-04-17sepgsql: Minor improvement to test script, doc fix.Robert Haas
KaiGai Kohei
2013-04-16doc: Update PQgetssl() documentationPeter Eisentraut
The return type of PQgetssl() was changed from SSL* to void* a long time ago, but the documentation was not updated.
2013-04-13pg_ctl: Add idempotent optionPeter Eisentraut
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.
2013-04-12sepgsql: Enforce db_procedure:{execute} permission.Robert Haas
To do this, we add an additional object access hook type, OAT_FUNCTION_EXECUTE. KaiGai Kohei
2013-04-10doc: Update DTrace informationPeter Eisentraut
The old web site link no longer worked, and some information was outdated.
2013-04-10Update the description for the graphical installersMagnus Hagander
Remove references to "one click", as we're not supposed to call them that anymore.
2013-04-10Make contrib/pg_trgm also support regex searches with GiST indexes.Tom Lane
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.
2013-04-10Fix hstore_to_json_loose example in docs.Andrew Dunstan
Marti Raudsepp.
2013-04-09Support indexing of regular-expression searches in contrib/pg_trgm.Tom Lane
This works by extracting trigrams from the given regular expression, in generally the same spirit as the previously-existing support for LIKE searches, though of course the details are far more complicated. Currently, only GIN indexes are supported. We might be able to make it work with GiST indexes later. The implementation includes adding API functions to backend/regex/ to provide a view of the search NFA created from a regular expression. These functions are meant to be generic enough to be supportable in a standalone version of the regex library, should that ever happen. Alexander Korotkov, reviewed by Heikki Linnakangas and Tom Lane
2013-04-05sepgsql: Enforce db_schema:search permission.Robert Haas
KaiGai Kohei, with comment and doc wordsmithing by me
2013-04-04Improve documentation about the relationship of extensions and schemas.Tom Lane
There's been some confusion expressed about this point, so clarify. Extended version of a patch by David Wheeler.
2013-04-04doc: Fix number of columns in tablePeter Eisentraut
2013-04-04Add \watch [SEC] command to psql.Tom Lane
This allows convenient re-execution of commands. Will Leinweber, reviewed by Peter Eisentraut, Daniel Farina, and Tom Lane
2013-04-04Fix a few thinkos in the JSON functions docs.Andrew Dunstan
Dickson S. Guedes
2013-04-03Fix typo in FDW docs.Tom Lane
Laurenz Albe
2013-04-01Update release notes for 9.2.4, 9.1.9, 9.0.13, 8.4.17.Tom Lane
Security: CVE-2013-1899, CVE-2013-1901
2013-03-31Update release notes for changes through today.Tom Lane
2013-03-31Add pkg-config files for libpq and ecpg librariesPeter Eisentraut
This will hopefully be easier to use than pg_config for users who are already used to the pkg-config interface. It also works better for multi-arch installations. reviewed by Tom Lane
2013-03-29Remove tab from SGML file.Bruce Momjian
2013-03-29Fix page title for JSON Functions and Operators.Andrew Dunstan
2013-03-29Add new JSON processing functions and parser API.Andrew Dunstan
The JSON parser is converted into a recursive descent parser, and exposed for use by other modules such as extensions. The API provides hooks for all the significant parser event such as the beginning and end of objects and arrays, and providing functions to handle these hooks allows for fairly simple construction of a wide variety of JSON processing functions. A set of new basic processing functions and operators is also added, which use this API, including operations to extract array elements, object fields, get the length of arrays and the set of keys of a field, deconstruct an object into a set of key/value pairs, and create records from JSON objects and arrays of objects. Catalog version bumped. Andrew Dunstan, with some documentation assistance from Merlin Moncure.
2013-03-28Document encode(bytea, 'escape')'s behavior correctly.Tom Lane
I changed this in commit fd15dba543247eb1ce879d22632b9fdb4c230831, but missed the fact that the SGML documentation of the function specified exactly what it did. Well, one of the two places where it's specified documented that --- probably I looked at the other place and thought nothing needed to be done. Sync the two places where encode() and decode() are described.
2013-03-28Draft release notes for 9.2.4, 9.1.9, 9.0.13, 8.4.17.Tom Lane
Covers commits through today. Not back-patching into back branches yet, since this is just for people to review in advance.
2013-03-28sepgsql: Documentation improvements.Robert Haas
Fixes by me, per griping by Thom Brown.
2013-03-28Allow sepgsql labels to depend on object name.Robert Haas
The main change here is to call security_compute_create_name_raw() rather than security_compute_create_raw(). This ups the minimum requirement for libselinux from 2.0.99 to 2.1.10, but it looks like most distributions will have picked that up before 9.3 is out. KaiGai Kohei
2013-03-28Add sql_drop event for event triggersAlvaro Herrera
This event takes place just before ddl_command_end, and is fired if and only if at least one object has been dropped by the command. (For instance, DROP TABLE IF EXISTS of a table that does not in fact exist will not lead to such a trigger firing). Commands that drop multiple objects (such as DROP SCHEMA or DROP OWNED BY) will cause a single event to fire. Some firings might be surprising, such as ALTER TABLE DROP COLUMN. The trigger is fired after the drop has taken place, because that has been deemed the safest design, to avoid exposing possibly-inconsistent internal state (system catalogs as well as current transaction) to the user function code. This means that careful tracking of object identification is required during the object removal phase. Like other currently existing events, there is support for tag filtering. To support the new event, add a new pg_event_trigger_dropped_objects() set-returning function, which returns a set of rows comprising the objects affected by the command. This is to be used within the user function code, and is mostly modelled after the recently introduced pg_identify_object() function. Catalog version bumped due to the new function. Dimitri Fontaine and Álvaro Herrera Review by Robert Haas, Tom Lane
2013-03-28Revoke bc5334d8679c428a709d150666b288171795bd76Simon Riggs
2013-03-27Fix pasto which broke docs build.Kevin Grittner
Commit bc5334d8679c428a709d150666b288171795bd76 accidentally included a second <variablelist> tag for a new list item.
2013-03-27sepgsql: Support for new post-ALTER access hook.Robert Haas
KaiGai Kohei
2013-03-27Allow external recovery_config_directorySimon Riggs
If required, recovery.conf can now be located outside of the data directory. Server needs read/write permissions on this directory.
2013-03-25Make pg_basebackup work with pre-9.3 servers, and add server version check.Heikki Linnakangas
A new 'starttli' field was added to the response of BASE_BACKUP command. Make pg_basebackup tolerate the case that it's missing, so that it still works with older servers. Add an explicit check for the server version, so that you get a nicer error message if you try to use it with a pre-9.1 server. The streaming protocol message format changed in 9.3, so -X stream still won't work with pre-9.3 servers. I added a version check to ReceiveXLogStream() earlier, but write that slightly differently, so that in 9.4, it will still work with a 9.3 server. (In 9.4, the error message needs to be adjusted to "9.3 or above", though). Also, if the version check fails, don't retry.
2013-03-24Add parallel pg_dump option.Andrew Dunstan
New infrastructure is added which creates a set number of workers (threads on Windows, forked processes on Unix). Jobs are then handed out to these workers by the master process as needed. pg_restore is adjusted to use this new infrastructure in place of the old setup which created a new worker for each step on the fly. Parallel dumps acquire a snapshot clone in order to stay consistent, if available. The parallel option is selected by the -j / --jobs command line parameter of pg_dump. Joachim Wieland, lightly editorialized by Andrew Dunstan.
2013-03-23Don't put <indexterm> before <term> in <varlistentry> items.Tom Lane
Doing that results in a broken index entry in PDF output. We had only a few like that, which is probably why nobody noticed before. Standardize on putting the <term> first. Josh Kupershmidt
2013-03-22Document cross-version compatibility issues for contrib/postgres_fdw.Tom Lane
One of the use-cases for postgres_fdw is extracting data from older PG servers, so cross-version compatibility is important. Document what we can do here, and further annotate some of the coding choices that create compatibility constraints. In passing, remove one unnecessary incompatibility with old servers, namely assuming that we didn't need to quote the timezone name 'UTC'.
2013-03-22Fix problems with incomplete attempt to prohibit OIDS with MVs.Kevin Grittner
Problem with assertion failure in restoring from pg_dump output reported by Joachim Wieland. Review and suggestions by Tom Lane and Robert Haas.
2013-03-22Update commit_delay documentation.Tom Lane
Commit 13fe298ca06f5390df5edf073cf401f9f0b67458 changed this GUC to be PGC_SUSET, but neglected to update the documentation to match. While at it, edit and rearrange the text a little for clarity.
2013-03-22Allow I/O reliability checks using 16-bit checksumsSimon Riggs
Checksums are set immediately prior to flush out of shared buffers and checked when pages are read in again. Hint bit setting will require full page write when block is dirtied, which causes various infrastructure changes. Extensive comments, docs and README. WARNING message thrown if checksum fails on non-all zeroes page; ERROR thrown but can be disabled with ignore_checksum_failure = on. Feature enabled by an initdb option, since transition from option off to option on is long and complex and has not yet been implemented. Default is not to use checksums. Checksum used is WAL CRC-32 truncated to 16-bits. Simon Riggs, Jeff Davis, Greg Smith Wide input and assistance from many community members. Thank you.
2013-03-21Eliminate trivial whitespace inconsistency in docs sample code.Kevin Grittner
2013-03-20Allow extracting machine-readable object identityAlvaro Herrera
Introduce pg_identify_object(oid,oid,int4), which is similar in spirit to pg_describe_object but instead produces a row of machine-readable information to uniquely identify the given object, without resorting to OIDs or other internal representation. This is intended to be used in the event trigger implementation, to report objects being operated on; but it has usefulness of its own. Catalog version bumped because of the new function.