summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2011-08-05Fix thinko in documentation of local_preload_libraries.Tom Lane
Somebody added a cross-reference to shared_preload_libraries, but wrote the wrong variable name when they did it (and didn't bother to make it a link either). Spotted by Christoph Anton Mitterer.
2011-08-04Fix markup for recent wal_level clarification.Bruce Momjian
Backpatch to 9.1 and 9.0.
2011-08-04In documentaiton, clarify which commands have reduced WAL volume forBruce Momjian
wal_level = minimum. Backpatch to 9.1 and 9.0.
2011-07-27Fix typo.Robert Haas
Noted by Josh Kupershmidt.
2011-07-26Clarify which relkinds accept column comments.Robert Haas
Per discussion with Josh Kupershmidt.
2011-07-25Improvements to SQL/MED documentation.Robert Haas
Laurenz Albe, somewhat modified by me.
2011-07-24Change EDITOR_LINENUMBER_SWITCH to an environment variablePeter Eisentraut
Also change "switch" to "arg" because "switch" is a bit of a sloppy term. So the environment variable is called PSQL_EDITOR_LINENUMBER_ARG. Set "+" as hardcoded default value on Unix (since "vi" is the hardcoded default editor), so many users won't have to configure this at all. Move the documentation around a bit to centralize the editor configuration under environment variables, rather than repeating bits of it under every backslash command that invokes an editor.
2011-07-20Improve sepgsql and SECURITY LABEL documentation.Robert Haas
KaiGai Kohei, based on feedback from Yeb Havinga, with some corrections by me.
2011-07-20Minor improvement to pg_seclabel documentation.Robert Haas
This is a bit more consistent with the way pg_description is documented, and also include a useful cross-link.
2011-07-18Remove claim that the project is not represented in the SQL working groupPeter Eisentraut
We have a few people involved there now.
2011-07-18Note that information_schema.sql_languages was removed in SQL:2008Peter Eisentraut
2011-07-16Add an errdetail_internal() ereport auxiliary routine.Tom Lane
This function supports untranslated detail messages, in the same way that errmsg_internal supports untranslated primary messages. We've needed this for some time IMO, but discussion of some cases in the SSI code provided the impetus to actually add it. Kevin Grittner, with minor adjustments by me
2011-07-14Small update on suggested startup file locationsPeter Eisentraut
Debian/Ubuntu don't have a /etc/rc.d/ directory, so add some alternative names as suggestions.
2011-07-13Mark collation-related information schema columns as not implementedPeter Eisentraut
rather than not applicable. They have already been implemented in 9.2.
2011-07-08Add item about Clang support to 9.1 release notesPeter Eisentraut
2011-07-08Message style improvementsPeter Eisentraut
2011-07-07Update examples for string-related functions.Tom Lane
In the example for decode(), show the bytea result in hex format, since that's now the default. Use an E'' string in the example for quote_literal(), so that it works regardless of the standard_conforming_strings setting. On the functions-for-binary-strings page, leave the examples as-is for readability, but add a note pointing out that they are shown in escape format. Per comments from Thom Brown. Also, improve the description for encode() and decode() a tad. Backpatch to 9.0, where bytea_output was introduced.
2011-07-07Update 9.1 release notes to reflect commits through today.Tom Lane
2011-07-07Reclassify replication-related GUC variables as "master" and "standby".Tom Lane
Per discussion, this structure seems more understandable than what was there before. Make config.sgml and postgresql.conf.sample agree. In passing do a bit of editorial work on the variable descriptions.
2011-07-07Finish disabling reduced-lock-levels-for-DDL feature.Tom Lane
Previous patch only covered the ALTER TABLE changes, not changes in other commands; and it neglected to revert the documentation changes.
2011-07-05Restructure foreign data wrapper chapter so it has more than one section.Tom Lane
As noted by Laurenz Albe, our SGML tools deal rather oddly with chapters having just one <sect1>. Perhaps the tooling could be fixed, but really the design of this chapter's introduction is pretty bogus anyhow. Split it into a true introduction and a <sect1> about the FDW functions, so that it reads better and dodges the lack-of-a-chapter-TOC problem.
2011-07-05Improve documentation about foreign data wrapper validator functions.Tom Lane
Modified version of a patch by Shigeru Hanada.
2011-07-05Fix typo in sslmode documentationMagnus Hagander
Per bug #6089, noted by Sidney Cadot
2011-07-05Small documentation tweaksPeter Eisentraut
2011-07-04Clarify that you need ActiveState perl 5.8 *or later* to build on Windows.Heikki Linnakangas
2011-07-04Reset ALTER TABLE lock levels to AccessExclusiveLock in all cases.Simon Riggs
Locks on inheritance parent remain at lower level, as they were before. Remove entry from 9.1 release notes.
2011-07-03Fix omissions in documentation of the pg_roles view.Tom Lane
Somehow, column rolconfig got removed from the documentation of the pg_roles view in the 9.0 cycle, although the column is actually still there. In 9.1, we'd also forgotten to document the rolreplication column. Spotted by Sakamoto Masahiko.
2011-07-02Unify spelling of "canceled", "canceling", "cancellation"Peter Eisentraut
We had previously (af26857a2775e7ceb0916155e931008c2116632f) established the U.S. spellings as standard.
2011-07-01In pg_upgrade 9.0 and 9.1, document suggestion of using a non-defaultBruce Momjian
port number to avoid unintended client connections.
2011-06-27Mention that SSPI authentication can use GSSAPI on non-Windows systems.Robert Haas
As noted by Christian Ullrich.
2011-06-24Documentation improvements for pg_locks with respect to SSI.Robert Haas
Explain that querying pg_locks does not simultaneously lock both the normal lock manager and the predicate lock manager. Per discussion with Kevin Grittner.
2011-06-23In pg_upgrade docs, clarify that link mode uses "hard" links.Bruce Momjian
Backpatch to 9.1 and 9.0.
2011-06-21Performance tuning advice for SSI.Robert Haas
Kevin Grittner, with additional wordsmithing by me.
2011-06-20Fix missed use of "cp -i" in an example, per Fujii Masao.Tom Lane
Also be more careful about markup: use &amp; not just &.
2011-06-19Produce HISTORY file consistently as ASCIIPeter Eisentraut
The release notes may contain non-ASCII characters (for contributor names), which lynx converts to the encoding determined by the current locale. The get output that is deterministic and easily readable by everyone, we make lynx produce LATIN1 and then convert that to ASCII with transliteration for the non-ASCII characters.
2011-06-19Capitalization fixesPeter Eisentraut
2011-06-17Don't use "cp -i" in the example WAL archive_command.Tom Lane
This is a dangerous example to provide because on machines with GNU cp, it will silently do the wrong thing and risk archive corruption. Worse, during the 9.0 cycle somebody "improved" the discussion by removing the warning that used to be there about that, and instead leaving the impression that the command would work as desired on most Unixen. It doesn't. Try to rectify the damage by providing an example that is safe most everywhere, and then noting that you can try cp -i if you want but you'd better test that. In back-patching this to all supported branches, I also added an example command for Windows, which wasn't provided before 9.0.
2011-06-17Fix typo.Robert Haas
Per Josh Kupershmidt and Tom Lane.
2011-06-15Rework parsing of ConstraintAttributeSpec to improve NOT VALID handling.Tom Lane
The initial commit of the ALTER TABLE ADD FOREIGN KEY NOT VALID feature failed to support labeling such constraints as deferrable. The best fix for this seems to be to fold NOT VALID into ConstraintAttributeSpec. That's a bit more general than the documented syntax, but it allows better-targeted syntax error messages. In addition, do some mostly-but-not-entirely-cosmetic code review for the whole NOT VALID patch.
2011-06-14Document that psql's \d also works with composite typesPeter Eisentraut
This has always been true, it was just never documented.
2011-06-14In pg_upgrade, document that link mode has to have data directories onBruce Momjian
the same file system, and that authentication should lock out normal users. Per suggestsion from #postgresql irc channel. Backpatch to 9.1.
2011-06-14Fix grammatical mistake introduced by previous commitAlvaro Herrera
Per note from Tom
2011-06-14Mention DROP TABLE as well as ALTER TABLE NO INHERITAlvaro Herrera
... when talking about how good they are in replacement of bulk DELETE in partitioned setups. The original wording was a bit confusing. Per an observation from David Wheeler.
2011-06-14Improve accuracy of ON_ERROR_STOP documentation.Robert Haas
Per a gripe from Tom Lane.
2011-06-13Document that bits to the right of the CIDR mask "should" be zero, notBruce Momjian
"must".
2011-06-13Expand warnings on locks acquired by CREATE INDEX CONCURRENTLYAlvaro Herrera
The previous wording wasn't explicit enough, which could misled readers into thinking that the locks acquired are more restricted in nature than they really are. The resulting optimism can be damaging to morale when confronted with reality, as has been observed in the field. Greg Smith
2011-06-13Remove parentheses from mention of current_schemas function.Robert Haas
This is more consistent with what we do elsewhere, and hopefully avoids creating the perception that current_schemas takes no arguments. As suggested by Brendan Jurd
2011-06-13Clarify that NATURAL without matching columns is like CROSS JOIN.Robert Haas
As suggested by Grzegorz Szpetkowski.
2011-06-13Add doc cross-reference to search_path discussion of current_schemas().Robert Haas
Brendan Jurd
2011-06-13Document GUC context for synchronous_standby_names/hot_standby_feedback.Robert Haas
Fujii Masao