summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2013-10-07docs: update release notes for 8.4.18, 9.0.14, 9.1.10, 9.2.5, 9.3.1Bruce Momjian
2013-10-02doc: Correct psycopg URLPeter Eisentraut
2013-09-02Fix relfrozenxid query in docs to include TOAST tables.Andrew Dunstan
The original query ignored TOAST tables which could result in tables needing a vacuum not being reported. Backpatch to all live branches.
2013-07-19doc: Fix typos in conversion names.Robert Haas
David Christensen
2013-07-02Mention extra_float_digits in floating point docsAlvaro Herrera
Make it easier for readers of the FP docs to find out about possibly truncated values. Per complaint from Tom Duffey in message F0E0F874-C86F-48D1-AA2A-0C5365BF5118@trillitech.com Author: Albe Laurenz Reviewed by: Abhijit Menon-Sen
2013-06-27Tweak wording in sequence-function docs to avoid PDF build failures.Tom Lane
Adjust the wording in the first para of "Sequence Manipulation Functions" so that neither of the link phrases in it break across line boundaries, in either A4- or US-page-size PDF output. This fixes a reported build failure for the 9.3beta2 A4 PDF docs, and future-proofs this particular para against causing similar problems in future. (Perhaps somebody will fix this issue in the SGML/TeX documentation tool chain someday, but I'm not holding my breath.) Back-patch to all supported branches, since the same problem could rise up to bite us in future updates if anyone changes anything earlier than this in func.sgml.
2013-06-26Document effect of constant folding on CASE.Noah Misch
Back-patch to all supported versions. Laurenz Albe
2013-06-19Update CREATE FUNCTION documentation about argument namesPeter Eisentraut
More languages than PL/pgSQL actually support parameter names.
2013-06-12Improve description of loread/lowrite.Robert Haas
Patch by me, reviewed by Tatsuo Ishii.
2013-06-11Add description that loread()/lowrite() are corresponding toTatsuo Ishii
lo_read()/lo_write() in libpq to avoid confusion.
2013-06-07Correct the documentation of pg_rewrite.ev_attr.Kevin Grittner
It claimed the value was always zero; it is really always -1. Per report from Hari Babu backpatch 734fbbd1d2d1babfbd195414e2445024ad549ae3 to 8.4
2013-06-07Minor docs wordsmithing.Tom Lane
Swap the order of a couple of phrases to clarify what the adjective "subsequent" applies to. Joshua Tolley
2013-05-04docs: log_line_prefix session id fixBruce Momjian
Restore 4-byte designation for docs. Fix 9.3 doc query to properly pad to four digits. Backpatch to all active branches Per suggestions from Ian Lawrence Barwick
2013-05-04doc: fix log_line_prefix session_id %c itemBruce Momjian
Backpatch to 9.1 and earlier Report from Ian Lawrence Barwick
2013-04-04doc: Remove excessive table cellPeter Eisentraut
2013-04-04doc: Fix number of columns in tablePeter Eisentraut
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-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-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-18Improve documentation of EXTRACT(WEEK).Tom Lane
The docs showed that early-January dates can be considered part of the previous year for week-counting purposes, but failed to say explicitly that late-December dates can also be considered part of the next year. Fix that, and add a cross-reference to the "isoyear" field. Per bug #7967 from Pawel Kobylak.
2013-03-03doc: Awkward phrasing fixPeter Eisentraut
Josh Kupershmidt
2013-02-25doc: Fix markup typoPeter Eisentraut
2013-02-24doc: Remove PostgreSQL version number from xml2 deprecation noticePeter Eisentraut
It is obviously no longer true.
2013-02-04Prevent execution of enum_recv() from SQL.Tom Lane
This function was misdeclared to take cstring when it should take internal. This at least allows crashing the server, and in principle an attacker might be able to use the function to examine the contents of server memory. The correct fix is to adjust the system catalog contents (and fix the regression tests that should have caught this but failed to). However, asking users to correct the catalog contents in existing installations is a pain, so as a band-aid fix for the back branches, install a check in enum_recv() to make it throw error if called with a cstring argument. We will later revert this in HEAD in favor of correcting the catalogs. Our thanks to Sumit Soni (via Secunia SVCRP) for reporting this issue. Security: CVE-2013-0255
2013-02-04Update release notes for 9.2.3, 9.1.8, 9.0.12, 8.4.16, 8.3.23.Tom Lane
2013-01-28DROP OWNED: don't try to drop tablespaces/databasesAlvaro Herrera
My "fix" for bugs #7578 and #6116 on DROP OWNED at fe3b5eb08a1 not only misstated that it applied to REASSIGN OWNED (which it did not affect), but it also failed to fix the problems fully, because I didn't test the case of owned shared objects. Thus I created a new bug, reported by Thomas Kellerer as #7748, which would cause DROP OWNED to fail with a not-for-user-consumption error message. The code would attempt to drop the database, which not only fails to work because the underlying code does not support that, but is a pretty dangerous and undesirable thing to be doing as well. This patch fixes that bug by having DROP OWNED only attempt to process shared objects when grants on them are found, ignoring ownership. Backpatch to 8.3, which is as far as the previous bug was backpatched.
2013-01-20doc: Fix syntax of a URLPeter Eisentraut
Leading white space before the "http:" is apparently treated as a relative link at least by some browsers.
2013-01-01Update copyrights for 2013Bruce Momjian
Fully update git head, and update back branches in ./COPYRIGHT and legal.sgml files.
2012-12-08Update ISO 3166 linkPeter Eisentraut
The old one no longer pointed to anything useful.
2012-12-03Update release notes for 9.2.2, 9.1.7, 9.0.11, 8.4.15, 8.3.22.Tom Lane
2012-12-03Fix documentation of path(polygon) function.Tom Lane
Obviously, this returns type "path", but somebody made a copy-and-pasteo long ago. Dagfinn Ilmari Mannsåker
2012-12-01doc: Fix broken links to DocBook wikiPeter Eisentraut
2012-11-26Remove inaccurate "Incrementally Updated Backups" documentation section;Bruce Momjian
already removed from 9.0+. Applied to 8.3 and 8.4.
2012-10-17Fix typo in previous commitSimon Riggs
2012-10-17Add hash index caution to CREATE INDEX docsSimon Riggs
2012-10-04Fix permissions explanations in CREATE DATABASE and CREATE SCHEMA docs.Tom Lane
These reference pages still claimed that you have to be superuser to create a database or schema owned by a different role. That was true before 8.1, but it was changed in commits aa1110624c08298393dfce996f7b21809d98d3fd and f91370cd2faf1fd35a1ac74d84652a85ed841919 to allow assignment of ownership to any role you are a member of. However, at the time we were thinking of that primarily as a change to the ALTER OWNER rules, so the need to touch these two CREATE ref pages got missed.
2012-09-25Fix examples of how to use "su" while starting the server.Tom Lane
The syntax "su -c 'command' username" is not accepted by all versions of su, for example not OpenBSD's. More portable is "su username -c 'command'". So change runtime.sgml to recommend that syntax. Also, add a -D switch to the OpenBSD example script, for consistency with other examples. Per Denis Lapshin and Gábor Hidvégi.
2012-09-19Update release notes for 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21.Tom Lane
2012-09-17Provide adequate documentation of the "table_name *" notation.Tom Lane
Somewhere along the line, somebody decided to remove all trace of this notation from the documentation text. It was still in the command syntax synopses, or at least some of them, but with no indication what it meant. This will not do, as evidenced by the confusion apparent in bug #7543; even if the notation is now unnecessary, people will find it in legacy SQL code and need to know what it does.
2012-09-16Fix documentation reference to maximum allowed for autovacuum_freeze_max_age.Kevin Grittner
The documentation mentioned setting autovacuum_freeze_max_age to "its maximum allowed value of a little less than two billion". This led to a post asking about the exact maximum allowed value, which is precisely two billion, not "a little less". Based on question by Radovan Jablonovsky. Backpatch to 8.3.
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-06-19Update copyright year in forgotten placesPeter Eisentraut
found by Stefan Kaltenbrunner
2012-06-17Add missing subtitle for compressed archive logsMagnus Hagander
2012-05-31Update release notes for 9.1.4, 9.0.8, 8.4.12, 8.3.19.Tom Lane
2012-05-03Remove link to ODBCng project from the docs.Magnus Hagander
This backatches Heikki's patch in 140a4fbf1a87891a79a2c61a08416828d39f286a to make sure the documentation on the website gets updated, since we're regularly receiving complains about this link.
2012-04-06Update URL for pgtclng project.Tom Lane
Thom Brown
2012-03-20Update struct Trigger in docsAlvaro Herrera
2012-03-11Add description for --no-locale and --text-search-config.Tatsuo Ishii
2012-03-05Improve documentation around logging_collector and use of stderr.Tom Lane
In backup.sgml, point out that you need to be using the logging collector if you want to log messages from a failing archive_command script. (This is an oversimplification, in that it will work without the collector as long as you're not sending postmaster stderr to /dev/null; but it seems like a good idea to encourage use of the collector to avoid problems with multiple processes concurrently scribbling on one file.) In config.sgml, do some wordsmithing of logging_collector discussion. Per bug #6518 from Janning Vygen