summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2012-08-30Document that COPY OUT requires an absolute pathname.Robert Haas
As suggested by Etsuro Fujita, but with somewhat different wording.
2012-08-30Remove old documentation warnings about the use of bigint.Bruce Momjian
2012-08-30Document that xslt-related RPMs may be needed to build docs.Robert Haas
2012-08-29Document that NOTIFY events are visible to all users.Bruce Momjian
2012-08-28Adjust pg_test_timing to show shortest test durations first, placeBruce Momjian
percentage column before count column. Docs updated.
2012-08-28Update doc mention of how to compute bigint advisory lock value, per TomBruce Momjian
Lane's correction.
2012-08-27Document how to create advisory lock "bigint" values in SQL.Bruce Momjian
David E. Wheeler
2012-08-27Improve a couple of 9.2 release note entries.Tom Lane
Clarify the compatibility notes about EXTRACT() and about statistics timing columns.
2012-08-27Add section IDs to subsections of syntax.sgml that lacked them.Tom Lane
This is so that these sections will have stable HTML tags that one can link to, rather than things like "AEN1902". Perhaps we should mount a campaign to do this everywhere, but I've found myself pointing at syntax.sgml subsections often enough to be sure it's useful here.
2012-08-27Document the lack of reading the PGDATABASE environment variable inBruce Momjian
pg_restore.
2012-08-26Update FreeBSD kernel configuration documentation.Bruce Momjian
Brad Davis
2012-08-26Clarify documentation that primary key and unique constraints are copiedBruce Momjian
for CREATE TABLE LIKE ... INCLUDING INDEXES. Per report from david.sahagian@emc.com
2012-08-25Document clearly that psql \! parameter interpretation limitations areBruce Momjian
the same as \copy.
2012-08-24Some spelling adjustments in release notesPeter Eisentraut
2012-08-24Normalize some British spellingsPeter Eisentraut
2012-08-24Put options on man page and in help output in slightly better orderPeter Eisentraut
2012-08-23Fix typo in example.Heikki Linnakangas
2012-08-23Add instructions for setting up documentation tool chain on Mac OS XPeter Eisentraut
2012-08-22Remove overly-pessimistic statement about constraint exclusion.Tom Lane
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.
2012-08-22Make a cut at a major-features list for 9.2.Tom Lane
This is open to debate of course, but it's past time we had *something* here.
2012-08-22Make an editorial pass over the 9.2 release notes.Tom Lane
A very large number of small improvements ...
2012-08-22Fix erroneous documentation of synchronous_commit = remote_write.Tom Lane
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.
2012-08-22Fix typo.Bruce Momjian
2012-08-22Document that pg_reload_conf() is also an easy way to reload theBruce Momjian
configuration file.
2012-08-21Update 9.2 release notes to reflect commits to date.Tom Lane
I was unable to entirely resist the temptation to copy-edit related entries, but will save most of that for a separate pass.
2012-08-21Add a note to the MVCC chapter that some things aren't transactional.Robert Haas
Craig Ringer, slightly edited by me.
2012-08-17Copy-editing for recent window-functions documentation rewrite.Tom Lane
Fix grammar, put back some removed information, rearrange for clarity.
2012-08-16Update 'int' protocol documentation mention to be "signed", per requestBruce Momjian
from Dmitriy Igrishin
2012-08-16Document that tab completation can interfere with some SQL commands.Bruce Momjian
2012-08-16Add warning about pg_ctl restart and the use of relative paths on the ↵Bruce Momjian
command-line.
2012-08-16In docs, clarify that, without ORDER BY, the window frame is all rows inBruce Momjian
the partition.
2012-08-16Revert: In docs, change a few cases of "not important" toBruce Momjian
"unimportant". Per request from Heikki
2012-08-16Rewrite window function reference section to more clearly explainBruce Momjian
keywords and concepts, based on suggestions by Florian Pflug.
2012-08-16In docs, change a few cases of "not important" to "unimportant".Bruce Momjian
2012-08-15Fix SGML markup; missing tag.Bruce Momjian
2012-08-15Document that PGDATA has to point to the configuration files, ratherBruce Momjian
than the actual data storage directory. Per suggestion from Thom Brown
2012-08-15Document that pg_ctl -w allows for the entry of an SSL passphase onBruce Momjian
startup. Per report from Thom Brown
2012-08-15Add CREATE FOREIGN TABLE doc reference to CREATE SERVER.Bruce Momjian
Per suggestion from Ray Stell
2012-08-15Properly document that NEW is unassigned in plpgsql for DELETE (notBruce Momjian
NULL), and OLD is unassigned for INSERT, and NEW/OLD are unassigned (not NULL) for statement-level triggers. Per report from Pavel Stehule
2012-08-15On second thought, explain why date_trunc("week") on interval values isBruce Momjian
not supported in the error message, rather than the docs.
2012-08-15Document why you can't use date_trunc("week") on intervals.Bruce Momjian
2012-08-15Document that foreign "version" and "type" values are only useful toBruce Momjian
certain foreign data wrappers.
2012-08-15Properly escape usernames in initdb, so names with single-quotes areBruce Momjian
supported. Also add assert to catch future breakage. Also, improve documentation that "double"-quotes must be used in pg_hba.conf (not single quotes).
2012-08-14Add more limited large object trigger example.Bruce Momjian
2012-08-14Add doc example of restricting large object trigger firing to onlyBruce Momjian
updates of the column of interest.
2012-08-14Update release notes for 9.1.5, 9.0.9, 8.4.13, 8.3.20.Tom Lane
2012-08-14Prevent access to external files/URLs via contrib/xml2's xslt_process().Tom Lane
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
2012-08-14In documentation, change "recommendable" to "recommended", perBruce Momjian
consultation with word definitions. Backpatch to 9.2.
2012-08-11Add link from COPY ref page to psql \copy.Tom Lane
Jeff Janes
2012-08-10Support having multiple Unix-domain sockets per postmaster.Tom Lane
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