aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Add the ability to compute per-statement latencies (ie, average executionTom Lane2010-08-12
| | | | | | times) to pgbench. Florian Pflug, reviewed by Greg Smith
* Back out syntax case changes --- seems they were intentional.Bruce Momjian2010-08-12
|
* Extend psql's \e and \ef commands so that a line number can be specified,Tom Lane2010-08-12
| | | | | | | | | | | | | | | | | | and the editor's cursor will be initially placed on that line. In \e the lines are counted with respect to the query buffer, while in \ef they are counted with line 1 = first line of function body. These choices are useful for positioning the cursor on the line of a previously-reported error. To avoid assumptions about what switch the user's editor takes for this purpose, invent a new psql variable EDITOR_LINENUMBER_SWITCH with (at present) no default value. One incompatibility from previous behavior is that "\e 1234" will now take "1234" as a line number not a file name. There are at least two ways to select a numerically-named file if you really want to. Pavel Stehule, reviewed by Jan Urbanski, with further editing by Robert Haas and Tom Lane
* Properly lowercase identifiers, uppercase keywords, in doc examplesBruce Momjian2010-08-11
|
* Fix one more incorrect errno definition in the ECPG manual.Robert Haas2010-08-11
| | | | Again, back-patch all the way to 7.4.
* Fix incorrect errno definitions in ECPG manual.Robert Haas2010-08-11
| | | | | | | ecpgerrno.h hasn't materially changed since PostgreSQL 7.4, so this has been wrong for a very long time. Back-patch all the way. Satoshi Nagayasu
* Add three-parameter forms of array_to_string and string_to_array, to allowTom Lane2010-08-10
| | | | | | | | | | | | | | | | better handling of NULL elements within the arrays. The third parameter is a string that should be used to represent a NULL element, or should be translated into a NULL element, respectively. If the third parameter is NULL it behaves the same as the two-parameter form. There are two incompatible changes in the behavior of the two-parameter form of string_to_array. First, it will return an empty (zero-element) array rather than NULL when the input string is of zero length. Second, if the field separator is NULL, the function splits the string into individual characters, rather than returning NULL as before. These two changes make this form fully compatible with the behavior of the new three-parameter form. Pavel Stehule, reviewed by Brendan Jurd
* Add some links to tablesPeter Eisentraut2010-08-10
|
* <example> is a floating element, so it's use is inappropriate when thePeter Eisentraut2010-08-10
| | | | surrounding text refers to the example inline.
* Use double quotes rather than double quotes for libpq target anchors.Robert Haas2010-08-10
| | | | | Per observation from Tom Lane that the previous patch to these files was not consistent with what is done elsewhere in the docs.
* Provide stable target anchors for libpq functions.Robert Haas2010-08-09
| | | | Daniele Varrazzo
* Modify the handling of RAISE without parameters so that the error it throwsTom Lane2010-08-09
| | | | | | | | | | | | | can be caught in the same places that could catch an ordinary RAISE ERROR in the same location. The previous coding insisted on throwing the error from the block containing the active exception handler; which is arguably more surprising, and definitely unlike Oracle's behavior. Not back-patching, since this is a pretty obscure corner case. The risk of breaking somebody's code in a minor version update seems to outweigh any possible benefit. Piyush Newe, reviewed by David Fetter
* Add an xpath_exists() function. This is equivalent to XMLEXISTS except thatTom Lane2010-08-08
| | | | | | it offers support for namespace mapping. Mike Fowler, reviewed by David Fetter
* Add stats functions and views to provide access to a transaction's ownTom Lane2010-08-08
| | | | | | | | statistics counts. These numbers are being accumulated but haven't yet been transmitted to the collector (and won't be, until the transaction ends). For some purposes, though, it's handy to be able to look at them. Joel Jacobson, reviewed by Itagaki Takahiro
* Fix 9.0 release notes vacuum mention, not -> nowBruce Momjian2010-08-07
| | | | Peter Fokkinga
* Recognize functional dependency on primary keys. This allows a table'sTom Lane2010-08-07
| | | | | | | | | | | | | other columns to be referenced without listing them in GROUP BY, so long as the primary key column(s) are listed in GROUP BY. Eventually we should also allow functional dependency on a UNIQUE constraint when the columns are marked NOT NULL, but that has to wait until NOT NULL constraints are represented in pg_constraint, because we need to have pg_constraint OIDs for all the conditions needed to ensure functional dependency. Peter Eisentraut, reviewed by Alex Hunsaker and Tom Lane
* Fix indexterm spellingPeter Eisentraut2010-08-06
|
* Let's put that </link> in a sane place ...Tom Lane2010-08-06
|
* Fix inaccurate description of deferrable unique constraints, per Dean Rasheed.Tom Lane2010-08-06
|
* Rearrange "big features" section of the release notes.Robert Haas2010-08-06
| | | | Josh Berkus
* Document which Python environment variables affect PL/PythonPeter Eisentraut2010-08-05
|
* Remove the single-argument form of string_agg(). It added nothing much inTom Lane2010-08-05
| | | | | | | | functionality, while creating an ambiguity in usage with ORDER BY that at least two people have already gotten seriously confused by. Also, add an opr_sanity test to check that we don't in future violate the newly minted policy of not having built-in aggregates with the same name and different numbers of parameters. Per discussion of a complaint from Thom Brown.
* Add xmlexists functionPeter Eisentraut2010-08-05
| | | | by Mike Fowler, reviewed by Peter Eisentraut
* Fix sloppy mistakes in documentation of PQescapeLiteral and PQescapeIdentifier.Tom Lane2010-08-04
| | | | Noted by Dmitriy Igrishin.
* Add an example to clarify the use of ORDER BY in multiple-argumentTom Lane2010-08-04
| | | | aggregates. People seem to not get this right without help.
* Fix mangled grammar.Tom Lane2010-08-03
|
* Kibitzing on \conninfo patch: adjust the order of field output to matchTom Lane2010-08-03
| | | | | | the parameters of \connect, and fix oversight of not enabling translation of the messages. Also, adjust \connect's similar messages to match, and deal with 8.2-era violation of basic translatability guidelines there.
* Add EXPLAIN documentation example.Bruce Momjian2010-08-03
| | | | gabrielle <gorthx@gmail.com>
* Fix markup, other minor editing for recent btree_gist doc changes.Tom Lane2010-08-03
|
* Teach levenshtein() about multi-byte characters.Robert Haas2010-08-02
| | | | Based on a patch by, and further ideas from, Alexander Korotkov.
* Add btree_gist support for searching on "not equals".Robert Haas2010-08-02
| | | | Jeff Davis, with slight editorialization by me.
* Update release notes for 9.0 beta 4. Back-patch some changes that were made ↵Tom Lane2010-07-29
| | | | only in HEAD.
* Fix indentation of verbatim block elementsPeter Eisentraut2010-07-29
| | | | | | | | | | Block elements with verbatim formatting (literallayout, programlisting, screen, synopsis) should be aligned at column 0 independent of the surrounding SGML, because whitespace is significant, and indenting them creates erratic whitespace in the output. The CSS stylesheets already take care of indenting the output. Assorted markup improvements to go along with it.
* Work around a documentation toolchain problem by replacing the "AIX-fixlevels"Tom Lane2010-07-29
| | | | | | | | | | table with a <variablelist> carrying the same information. Previously the 9.0 documentation was failing to build as a US-size PDF file. It's quite obscure what the real problem is or why this avoids it, but we need a hack now so we can build docs for beta4. In passing do a bit of editing in the AIX installation docs, in particular remove a long-obsolete claim that the regression tests are likely to fail.
* Reduce lock levels of CREATE TRIGGER and some ALTER TABLE, CREATE RULE actions.Simon Riggs2010-07-28
| | | | | | | | | Avoid hard-coding lockmode used for many altering DDL commands, allowing easier future changes of lock levels. Implementation of initial analysis on DDL sub-commands, so that many lock levels are now at ShareUpdateExclusiveLock or ShareRowExclusiveLock, allowing certain DDL not to block reads/writes. First of number of planned changes in this area; additional docs required when full project complete.
* Add ssl_cipher() and ssl_version() functions to contrib/sslinfo.Robert Haas2010-07-27
| | | | Review by Dave Page.
* Fix typo in PL/pgsql code example.Robert Haas2010-07-27
| | | | | | Backpatch to 8.4. Marc Cousin. Review by Kevin Grittner.
* Spelling fixesPeter Eisentraut2010-07-27
|
* Fix grammarPeter Eisentraut2010-07-26
| | | | backpatched to 8.1
* Add table creation and population to examplePeter Eisentraut2010-07-26
| | | | from John Gage
* Remove tabs from sgml file.Bruce Momjian2010-07-26
|
* CREATE TABLE IF NOT EXISTS.Robert Haas2010-07-25
| | | | Reviewed by Bernd Helmle.
* Add INSERT statement to example so that it can be reproducedPeter Eisentraut2010-07-25
| | | | from John Gage
* Prevent pg_upgrade from migrating databases that use reg* data typesBruce Momjian2010-07-25
| | | | | | | where the oid is not preserved by pg_upgrade (everything but pg_type). Update documentation. Per bug report from depstein@alliedtesting.com.
* Fix typoPeter Eisentraut2010-07-24
|
* Tidy up boolean data type pagePeter Eisentraut2010-07-24
| | | | by Thom Brown
* Remove tab from SGML filePeter Eisentraut2010-07-24
|
* Add options to force quoting of all identifiers.Robert Haas2010-07-22
| | | | | | | | | | I've added a quote_all_identifiers GUC which affects the behavior of the backend, and a --quote-all-identifiers argument to pg_dump and pg_dumpall which sets the GUC and also affects the quoting done internally by those applications. Design by Tom Lane; review by Alex Hunsaker; in response to bug #5488 filed by Hartmut Goebel.
* Add \conninfo command to psql, to show current connection info.Robert Haas2010-07-20
| | | | David Christensen. Reviewed by Steve Singer. Some further changes by me.
* Add restart_after_crash GUC.Robert Haas2010-07-20
| | | | | | | | | | | Normally, we automatically restart after a backend crash, but in some cases when PostgreSQL is invoked by clusterware it may be desirable to suppress this behavior, so we provide an option which does this. Since no existing GUC group quite fits, create a new group called "error handling options" for this and the previously undocumented GUC exit_on_error, which is now documented. Review by Fujii Masao.
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-09 00:14:30 +0000