summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2011-03-23Fix ancient typo in user-defined-aggregates documentation.Tom Lane
The description of the initcond value for the built-in avg(float8) aggregate has been wrong since it was written. Noted by Disc Magnet.
2011-03-02Correct mistaken claims about EXPLAIN ANALYZE's handling of triggers.Tom Lane
Time spent executing AFTER triggers is not included in the runtime of the associated ModifyTable node; in my patch of yesterday I confused queuing of these triggers with their actual execution. Spotted by Marko Tiikkaja.
2011-03-01Update discussion of EXPLAIN to reflect existence of ModifyTable nodes.Tom Lane
Back-patch to 9.0, since this was changed then.
2011-02-13Clarify documentation for libpq's PQescapeBytea to mention the new hexBruce Momjian
format. Modify PQescapeStringConn() docs to be consisent with other escaping functions. Add mention problems with pre-9.0 versions of libpq using not understanding bytea hex format to the 9.0 release notes. Backpatch to 9.0 docs.
2011-02-03Fix typo.Magnus Hagander
Thom Brown
2011-02-01Create new errcode for recovery conflict caused by db drop on master.Simon Riggs
Previously reported as ERRCODE_ADMIN_SHUTDOWN, this case is now reported as ERRCODE_DATABASE_DROPPED. No message text change. Unlikely to happen on most servers, so low impact change to allow session poolers to correctly handle this situation. Tatsuo Ishii and Simon Riggs
2011-01-27Update release notes.Tom Lane
Security: CVE-2010-4015
2011-01-27Update release notes for releases 9.0.3, 8.4.7, 8.3.14, and 8.2.20.Tom Lane
2011-01-25Correct ALTER TYPE -> SET DATA TYPE in ALTER TABLE documentation.Robert Haas
The latter is the correct name of the operation to change the data type of a column. Noah Misch
2011-01-19Document that WITH queries are also called Common Table Expressions.Robert Haas
Peter Geoghegan, reviewed by Stephen Frost
2011-01-11Typo fixMagnus Hagander
Josh Kupershmidt
2011-01-08Remove bogus claims regarding createuser defaults.Robert Haas
Josh Kupershmidt
2011-01-05Update documentation to say that \lo_import sets :LASTOID, notBruce Momjian
lo_insert.
2010-12-24Correct spelling: longjump() -> longjmp().Robert Haas
2010-12-24Fix grammarPeter Eisentraut
2010-12-24Backpatch to 9.0 a doc mention that a BBU does not prevent partial pageBruce Momjian
writes.
2010-12-18Document unavailable parameters in some configurationsMagnus Hagander
Add a note to user-facing parameters that can be removed completely (and not just empty) by #ifdef's depending on build configuration.
2010-12-13Update release notes for releases 9.0.2, 8.4.6, 8.3.13, 8.2.19, and 8.1.23.Tom Lane
2010-12-08Force default wal_sync_method to be fdatasync on Linux.Tom Lane
Recent versions of the Linux system header files cause xlogdefs.h to believe that open_datasync should be the default sync method, whereas formerly fdatasync was the default on Linux. open_datasync is a bad choice, first because it doesn't actually outperform fdatasync (in fact the reverse), and second because we try to use O_DIRECT with it, causing failures on certain filesystems (e.g., ext4 with data=journal option). This part of the patch is largely per a proposal from Marti Raudsepp. More extensive changes are likely to follow in HEAD, but this is as much change as we want to back-patch. Also clean up confusing code and incorrect documentation surrounding the fsync_writethrough option. Those changes shouldn't result in any actual behavioral change, but I chose to back-patch them anyway to keep the branches looking similar in this area. In 9.0 and HEAD, also do some copy-editing on the WAL Reliability documentation section. Back-patch to all supported branches, since any of them might get used on modern Linux versions.
2010-11-12docs -> documentationPeter Eisentraut
2010-11-10Mention that pg_upgrade requires compatible 32/64-bit binaries.Bruce Momjian
2010-11-09plpython has plpy.Error instead of plpy.ERRORAlvaro Herrera
Author: Marti Raudsepp <marti@juffo.org>
2010-10-26Note explicitly that hash indexes are also not replicated because they're notHeikki Linnakangas
WAL-logged. Make the notice about the lack of WAL-logging more visible by making it a <caution>. Also remove the false statement from hot standby caveats section that hash indexes are not used during hot standby.
2010-10-22Add semicolon, missed in previous patch. And update the keyword list inHeikki Linnakangas
the docs to reflect that OFF is now unreserved. Spotted by Tom Lane.
2010-10-19Update storage.sgml to describe the 9.0 tablespace directory layout.Tom Lane
2010-10-19Add mention of using tools/fsync to test fsync methods. RestructureBruce Momjian
recent wal_sync_method doc paragraph to be clearer.
2010-10-18Remove tab from SGML.Bruce Momjian
2010-10-18Document the tablespace directory "should" be empty, rather than "must"Bruce Momjian
be empty. Because of binary migration usage, it might not be empty.
2010-10-15Correct WAL space calculation formula in docs.Simon Riggs
Error pointed out by Fujii Masao, though not his patch.
2010-10-14Add pg_user_mappings to the table of system views.Robert Haas
2010-10-14Improvements to docs about pg_archive_cleanup and use of archivesSimon Riggs
Brendan Jurd
2010-10-14Complete the documentation of the USAGE privilege for foreign serversPeter Eisentraut
The GRANT reference page failed to mention that the USAGE privilege allows modifying associated user mappings, although this was already documented on the CREATE/ALTER/DROP USER MAPPING pages.
2010-10-13Make title capitalization consistent with surroundingsPeter Eisentraut
2010-10-08Adjust EXPLAIN documentation, so that it's not unreasonably wide.Robert Haas
The new formatting matches what we do for COPY. Per a complaint from Bruce Momjian.
2010-10-08Warn that views can be safely used to hide columns, but not rows.Robert Haas
2010-10-07Improve WAL reliability documentation, and add more cross-references to it.Robert Haas
In particular, we are now more explicit about the fact that you may need wal_sync_method=fsync_writethrough for crash-safety on some platforms, including MaxOS X. There's also now an explicit caution against assuming that the default setting of wal_sync_method is either crash-safe or best for performance.
2010-10-06Correct docs for behaviour of ALTER DATABASE .. RENAME during Hot Standby.Simon Riggs
Actual behaviour did not match documented behaviour and we have agreed that it should be the docs that change. Spotted by Bernd Helmle
2010-10-05Undo some poorly-thought-out "proofreading improvements".Tom Lane
Per Tatsuhito Kasahara.
2010-10-01Fix back-branch breakage from ill-advised last-minute commit.REL9_0_1Tom Lane
2010-09-30Use a separate interpreter for each calling SQL userid in plperl and pltcl.Tom Lane
There are numerous methods by which a Perl or Tcl function can subvert the behavior of another such function executed later; for example, by redefining standard functions or operators called by the target function. If the target function is SECURITY DEFINER, or is called by such a function, this means that any ordinary SQL user with Perl or Tcl language usage rights can do essentially anything with the privileges of the target function's owner. To close this security hole, create a separate Perl or Tcl interpreter for each SQL userid under which plperl or pltcl functions are executed within a session. However, all plperlu or pltclu functions run within a session still share a single interpreter, since they all execute at the trust level of a database superuser anyway. Note: this change results in a functionality loss when libperl has been built without the "multiplicity" option: it's no longer possible to call plperl functions under different userids in one session, since such a libperl can't support multiple interpreters in one process. However, such a libperl already failed to support concurrent use of plperl and plperlu, so it's likely that few people use such versions with Postgres. Security: CVE-2010-3433
2010-09-30Adjust pg_archivecleanup docs to match message changes made 2010-06-17.Robert Haas
Erik Rijkers
2010-09-30Update release notes for releases 9.0.1, 8.4.5, 8.3.12, 8.2.18, 8.1.22,Tom Lane
8.0.26, and 7.4.30.
2010-09-28Mention that pg_upgrade requires write permission in the currentBruce Momjian
directory. Per report from Harald Armin Massa.
2010-09-28Mention in pg_upgrade docs that the proper Win32 service name should be used.Bruce Momjian
Per report from Harald Armin Massa
2010-09-28Add mention of installing pg_upgrade_support in pg_upgrade doc sectionBruce Momjian
title, per suggestion from Ian Barwick.
2010-09-25Fix man page markup for <cmdsynopsis> with multiple variantsPeter Eisentraut
Command synopses using <cmdsynopsis> with multiple variants previously used <sbr> to break lines between variants. The new man page toolchain introduced in 9.0 makes a mess out of that, and that markup was probably wrong all along, because <sbr> is supposed to break lines within a synopsis, not between them. So fix that by using multiple <cmdsynopsis> elements inside <refsynopsisdiv>. backpatched to 9.0
2010-09-22Do some copy-editing on the Git usage docs.Tom Lane
2010-09-22Fix remaining stray references to CVS.Tom Lane
These are just cosmetic and don't seem worth back-patching far. I put them into 9.0 just because it was trivial to do so.
2010-09-22Add assorted other documentation build targets to documentation gitignore.Tom Lane
2010-09-22Remove anonymous cvs instructions, and replace them with instructionsMagnus Hagander
for git. Change other references from cvs to git as well.