summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
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.
2010-09-22Convert cvsignore to gitignore, and add .gitignore for build targets.Magnus Hagander
2010-09-21Fix a missed explanation of auto-analyze threshold, per Joe Miller.Tom Lane
2010-09-17Move pg_db_role_setting docs to correct place in alphabetical order.Robert Haas
2010-09-16Stamp 9.0 release notes with expected release date; also some last-minuteTom Lane
copy-editing.
2010-09-16Fix bad grammar.Tom Lane
2010-09-15Add a compatibility note about plpgsql's treatment of SELECT INTO rec.fldTom Lane
when fld is of composite type. Per discussion of bug #5644 from Valentine Gogichashvili.
2010-09-13Elaborate on what gets stored in pg_authid.rolpasswd.Robert Haas
Also, add cross-reference from pg_shadow.passwd to pg_authid.rolpasswd and fix a bit of markup I muffed in my previous commit. Per discussion with Josh Kupershmidt.
2010-09-13Don't try aligning comments for new archive_command Win32 doc example;Bruce Momjian
it doesn't work. Backpatch to 9.0.X.
2010-09-13Link from pg_shadow docs to pg_authid docs.Robert Haas
Per discussion with Josh Kupershmidt.
2010-09-12Re-add documentation for Win32 copy syntax for archive_command.Bruce Momjian
Backpatch to 9.0.X.
2010-09-09Remove obsolete claim that gzip is needed while installing PG's documentation.Tom Lane
It isn't, now that we ship the docs as loose files rather than a sub-tarball. Also adjust the wording in a couple of places to make the lists of required software read more consistently.
2010-09-09Doc fixes:Bruce Momjian
- remove excessive table cells - moving function parameters into function tags rather than having them being considered separate - add return type column on XML2 contrib module functions list and removing return types from function - add table header to XML2 contrib parameter table Thom Brown Backpatch to 9.0.X.
2010-09-08Add tip about building plpython 2 and 3. Fix link to Python docs.Peter Eisentraut
2010-09-07Clarify that surrogate pairs are not encoded in UTF-8 directlyPeter Eisentraut
2010-09-02Clean up description of ecpg's dtcvfmtasc function.Tom Lane
Per KOIZUMI Satoru.
2010-09-02Clean up some bad grammar and punctuation in description of ecpg's decimalTom Lane
type. Per KOIZUMI Satoru.
2010-09-01Clarify documentation of handling of null arguments for aggregates.Tom Lane
Per discussion.
2010-09-01Improve release notes' description of Teodor's fixes for polygon overlapsTom Lane
and contains operators.
2010-08-31Add missing markup for translatabilityAlvaro Herrera
2010-08-29Remove obsolete remark that PQprepare() is more flexible than PREPARE.Tom Lane
Spotted by Dmitriy Igrishin. Back-patch to 8.2, which is when the PREPARE statement was improved to allow parameter types to be omitted.
2010-08-26Document the existence of the socket lock file under unix_socket_directory,Tom Lane
which is perhaps not a terribly good spot for it but there doesn't seem to be a better place. Also add a source-code comment pointing out a couple reasons for having a separate lock file. Per suggestion from Greg Smith.
2010-08-26Explain automatic creation (or lack of it) of indexes for the various typesTom Lane
of constraints. Kevin Grittner
2010-08-25Remove docs for "Incrementally Updated Backups" because it was ofBruce Momjian
questionable reliability; information moved to a wiki: http://wiki.postgresql.org/wiki/Incrementally_Updated_Backups Backpatch to 9.0.
2010-08-25Document filtering dictionaries in textsearch.sgml.Tom Lane
While at it, copy-edit the description of prefix-match marker support in synonym dictionaries, and clarify the description of the default unaccent dictionary a bit more.
2010-08-25Update release notes, per comments from Simon Riggs.Bruce Momjian
2010-08-25Add missing description of reloftype fieldPeter Eisentraut
2010-08-25Docs review for unaccent: fix grammar, markup, etc.Tom Lane
2010-08-25Update 9.0 release notes for changes since beta4.Tom Lane
Note: as usual, bug fixes that were also applied in back branches are not considered material to include in a new major release's notes.