aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Fix typo in example.Heikki Linnakangas2012-08-23
|
* Add instructions for setting up documentation tool chain on Mac OS XPeter Eisentraut2012-08-23
|
* Remove overly-pessimistic statement about constraint exclusion.Tom Lane2012-08-22
| | | | | | | As of 9.2, constraint exclusion should work okay with prepared statements: the planner will try custom plans with actual values of the parameters, and observe that they are a lot cheaper than the generic plan, and thus never fall back to using the generic plan. Noted by Tatsuhito Kasahara.
* Make a cut at a major-features list for 9.2.Tom Lane2012-08-22
| | | | | This is open to debate of course, but it's past time we had *something* here.
* Make an editorial pass over the 9.2 release notes.Tom Lane2012-08-22
| | | | A very large number of small improvements ...
* Fix erroneous documentation of synchronous_commit = remote_write.Tom Lane2012-08-22
| | | | | | | The docs claimed that this mode only waits for the standby to receive WAL data, but actually it waits for the data to be written out to the standby's OS; which is a pretty significant difference because it removes the risk of crash of the walreceiver process.
* Fix typo.Bruce Momjian2012-08-22
|
* Document that pg_reload_conf() is also an easy way to reload theBruce Momjian2012-08-22
| | | | configuration file.
* Update 9.2 release notes to reflect commits to date.Tom Lane2012-08-21
| | | | | I was unable to entirely resist the temptation to copy-edit related entries, but will save most of that for a separate pass.
* Add a note to the MVCC chapter that some things aren't transactional.Robert Haas2012-08-21
| | | | Craig Ringer, slightly edited by me.
* Copy-editing for recent window-functions documentation rewrite.Tom Lane2012-08-17
| | | | Fix grammar, put back some removed information, rearrange for clarity.
* Update 'int' protocol documentation mention to be "signed", per requestBruce Momjian2012-08-16
| | | | from Dmitriy Igrishin
* Document that tab completation can interfere with some SQL commands.Bruce Momjian2012-08-16
|
* Add warning about pg_ctl restart and the use of relative paths on the ↵Bruce Momjian2012-08-16
| | | | command-line.
* In docs, clarify that, without ORDER BY, the window frame is all rows inBruce Momjian2012-08-16
| | | | the partition.
* Revert: In docs, change a few cases of "not important" toBruce Momjian2012-08-16
| | | | | | "unimportant". Per request from Heikki
* Rewrite window function reference section to more clearly explainBruce Momjian2012-08-16
| | | | keywords and concepts, based on suggestions by Florian Pflug.
* In docs, change a few cases of "not important" to "unimportant".Bruce Momjian2012-08-16
|
* Fix SGML markup; missing tag.Bruce Momjian2012-08-15
|
* Document that PGDATA has to point to the configuration files, ratherBruce Momjian2012-08-15
| | | | | | than the actual data storage directory. Per suggestion from Thom Brown
* Document that pg_ctl -w allows for the entry of an SSL passphase onBruce Momjian2012-08-15
| | | | | | startup. Per report from Thom Brown
* Add CREATE FOREIGN TABLE doc reference to CREATE SERVER.Bruce Momjian2012-08-15
| | | | Per suggestion from Ray Stell
* Properly document that NEW is unassigned in plpgsql for DELETE (notBruce Momjian2012-08-15
| | | | | | | NULL), and OLD is unassigned for INSERT, and NEW/OLD are unassigned (not NULL) for statement-level triggers. Per report from Pavel Stehule
* On second thought, explain why date_trunc("week") on interval values isBruce Momjian2012-08-15
| | | | not supported in the error message, rather than the docs.
* Document why you can't use date_trunc("week") on intervals.Bruce Momjian2012-08-15
|
* Document that foreign "version" and "type" values are only useful toBruce Momjian2012-08-15
| | | | certain foreign data wrappers.
* Properly escape usernames in initdb, so names with single-quotes areBruce Momjian2012-08-15
| | | | | | | supported. Also add assert to catch future breakage. Also, improve documentation that "double"-quotes must be used in pg_hba.conf (not single quotes).
* Add more limited large object trigger example.Bruce Momjian2012-08-14
|
* Add doc example of restricting large object trigger firing to onlyBruce Momjian2012-08-14
| | | | updates of the column of interest.
* Update release notes for 9.1.5, 9.0.9, 8.4.13, 8.3.20.Tom Lane2012-08-14
|
* Prevent access to external files/URLs via contrib/xml2's xslt_process().Tom Lane2012-08-14
| | | | | | | | | | | | | | | | | | | | | | | libxslt offers the ability to read and write both files and URLs through stylesheet commands, thus allowing unprivileged database users to both read and write data with the privileges of the database server. Disable that through proper use of libxslt's security options. Also, remove xslt_process()'s ability to fetch documents and stylesheets from external files/URLs. While this was a documented "feature", it was long regarded as a terrible idea. The fix for CVE-2012-3489 broke that capability, and rather than expend effort on trying to fix it, we're just going to summarily remove it. While the ability to write as well as read makes this security hole considerably worse than CVE-2012-3489, the problem is mitigated by the fact that xslt_process() is not available unless contrib/xml2 is installed, and the longstanding warnings about security risks from that should have discouraged prudent DBAs from installing it in security-exposed databases. Reported and fixed by Peter Eisentraut. Security: CVE-2012-3488
* In documentation, change "recommendable" to "recommended", perBruce Momjian2012-08-14
| | | | | | consultation with word definitions. Backpatch to 9.2.
* Add link from COPY ref page to psql \copy.Tom Lane2012-08-11
| | | | Jeff Janes
* Support having multiple Unix-domain sockets per postmaster.Tom Lane2012-08-10
| | | | | | | | | | | | | | Replace unix_socket_directory with unix_socket_directories, which is a list of socket directories, and adjust postmaster's code to allow zero or more Unix-domain sockets to be created. This is mostly a straightforward change, but since the Unix sockets ought to be created after the TCP/IP sockets for safety reasons (better chance of detecting a port number conflict), AddToDataDirLockFile needs to be fixed to support out-of-order updates of data directory lockfile lines. That's a change that had been foreseen to be necessary someday anyway. Honza Horak, reviewed and revised by Tom Lane
* Fix upper limit of superuser_reserved_connections, add limit for wal_sendersMagnus Hagander2012-08-10
| | | | | | | | Should be limited to the maximum number of connections excluding autovacuum workers, not including. Add similar check for max_wal_senders, which should never be higher than max_connections.
* Make psql -1 < file behave as expected.Robert Haas2012-08-09
| | | | | | | | | | Previously, the -1 option was silently ignored. Also, emit an error if -1 is used in a context where it won't be respected, to avoid user confusion. Original patch by Fabien COELHO, but this version is quite different from the original submission.
* Doc correction to point out that 9.2+ can overwrite pg_xlog files.Simon Riggs2012-08-08
| | | | Noted by Noah Misch, patch by Fujii Masao
* Implement SQL-standard LATERAL subqueries.Tom Lane2012-08-07
| | | | | | | | | | | | | | | | | | | | | | | | | | | This patch implements the standard syntax of LATERAL attached to a sub-SELECT in FROM, and also allows LATERAL attached to a function in FROM, since set-returning function calls are expected to be one of the principal use-cases. The main change here is a rewrite of the mechanism for keeping track of which relations are visible for column references while the FROM clause is being scanned. The parser "namespace" lists are no longer lists of bare RTEs, but are lists of ParseNamespaceItem structs, which carry an RTE pointer as well as some visibility-controlling flags. Aside from supporting LATERAL correctly, this lets us get rid of the ancient hacks that required rechecking subqueries and JOIN/ON and function-in-FROM expressions for invalid references after they were initially parsed. Invalid column references are now always correctly detected on sight. In passing, remove assorted parser error checks that are now dead code by virtue of our having gotten rid of add_missing_from, as well as some comments that are obsolete for the same reason. (It was mainly add_missing_from that caused so much fudging here in the first place.) The planner support for this feature is very minimal, and will be improved in future patches. It works well enough for testing purposes, though. catversion bump forced due to new field in RangeTblEntry.
* Fix to_char(), to_date(), and to_timestamp() to handle negative/BCBruce Momjian2012-08-07
| | | | | | | | century specifications just like positive/AD centuries. Previously the behavior was either wrong or inconsistent with positive/AD handling. Centuries without years now always assume the first year of the century, which is now documented.
* Typo fixes for previous commit.Robert Haas2012-08-06
| | | | Noted by Thom Brown.
* Warn more vigorously about the non-transactional behavior of sequences.Robert Haas2012-08-06
| | | | Craig Ringer, edited fairly heavily by me
* Reword documentation for concurrent index rebuilds to be clearer.Bruce Momjian2012-08-04
| | | | Backpatch to 9.1 and 9.2.
* Add link to synchronous_commit variables in high availability docs.Bruce Momjian2012-08-03
| | | | | | Backpatch to 9.2 Erik Rijkers
* Document that trying to exceed temp_file_limit causes a query cancel.Bruce Momjian2012-08-03
| | | | Backpatch to 9.2.
* Document that, for psql -c, only the result of the last command isBruce Momjian2012-08-03
| | | | | | returned, per report from Aleksey Tsalolikhin Backpatch to 9.2 and 9.1.
* Update release notes for libpq feature change.Tom Lane2012-08-02
|
* Replace libpq's "row processor" API with a "single row" mode.Tom Lane2012-08-02
| | | | | | | | | | | | | | | | | | | | | After taking awhile to digest the row-processor feature that was added to libpq in commit 92785dac2ee7026948962cd61c4cd84a2d052772, we've concluded it is over-complicated and too hard to use. Leave the core infrastructure changes in place (that is, there's still a row processor function inside libpq), but remove the exposed API pieces, and instead provide a "single row" mode switch that causes PQgetResult to return one row at a time in separate PGresult objects. This approach incurs more overhead than proper use of a row processor callback would, since construction of a PGresult per row adds extra cycles. However, it is far easier to use and harder to break. The single-row mode still affords applications the primary benefit that the row processor API was meant to provide, namely not having to accumulate large result sets in memory before processing them. Preliminary testing suggests that we can probably buy back most of the extra cycles by micro-optimizing construction of the extra results, but that task will be left for another day. Marko Kreen
* Add documentation cross-reference for JSON functions.Tom Lane2012-08-01
| | | | Thom Brown
* pg_basebackup: stylistic adjustmentsAlvaro Herrera2012-07-31
| | | | | | | | | | | | | | The most user-visible part of this is to change the long options --statusint and --noloop to --status-interval and --no-loop, respectively, per discussion. Also, consistently enclose file names in double quotes, per our conventions; and consistently use the term "transaction log file" to talk about WAL segments. (Someday we may need to go over this terminology and make it consistent across the whole source code.) Finally, reflow the code to better fit in 80 columns, and have pgindent fix it up some more.
* Now that the diskchecker.pl author has updated the download link on hisBruce Momjian2012-07-30
| | | | | | website, revert the separate link to the download git repository. Backpatch from 9.0 to current.
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-27 10:38:24 +0000