summaryrefslogtreecommitdiff
path: root/doc/src/sgml
AgeCommit message (Collapse)Author
2011-11-08-DLINUX_OOM_ADJ=0 should be in CPPFLAGS, not CFLAGSPeter Eisentraut
2011-11-04Fix archive_command examplePeter Eisentraut
The given archive_command example didn't use %p or %f, which wouldn't really work in practice.
2011-11-01Document that multiple LDAP servers can be specifiedMagnus Hagander
2011-10-12Modify up/home macro to match standard parameter list; fixes doc build.Bruce Momjian
2011-10-12Improve documentation of psql's \q command.Tom Lane
The documentation neglected to explain its behavior in a script file (it only ends execution of the script, not psql as a whole), and failed to mention the long form \quit either.
2011-10-12Add Up/Home link to the top of the HTML doc output.Bruce Momjian
Backpatch to 9.0.X and 9.1.X.
2011-10-10Fix typo in docs for libpq keepalives_count option.Robert Haas
Shigehiro Honda
2011-09-24Fix typoMagnus Hagander
2011-09-24Note that sslmode=require verifies the CA if root cert is presentMagnus Hagander
This mode still exists for backwards compatibility, making sslmode=require the same as sslmode=verify-ca when the file is present, but not causing an error when it isn't. Per bug 6189, reported by Srinivas Aji
2011-09-22Update release notes for 9.1.1, 9.0.5, 8.4.9, 8.3.16, 8.2.22.Tom Lane
Man, we fixed a lotta bugs since April.
2011-09-07In pg_upgrade, disallow migration of 8.3 clusters using contrib/ltreeBruce Momjian
because its internal format was changed in 8.4. Backpatch to 9.0 and 9.1. Report by depesz, diagnosis by Tom.
2011-09-07Revert documentation patch about NEW/OLD and triggers.Bruce Momjian
Backpatch to 9.0 and 9.1. Patch from Josh Kupershmidt.
2011-09-06Properly document the existance of OLD/NEW trigger pl/pgsql triggerBruce Momjian
fields. Backpatch to 9.0 and 9.1. Report from Pavel Stehule, patch from Josh Kupershmidt
2011-09-06Fix plpgsql "PERFORM" markup.Bruce Momjian
Backpatch to 9.0 and 9.1.
2011-09-06Document PERFORM limitation when using WITH queries.Bruce Momjian
Backpatch to 9.0 and 9.1. Report from depstein@alliedtesting.com.
2011-09-06Update type-conversion documentation for long-ago changes.Tom Lane
This example wasn't updated when we changed the behavior of bpcharlen() in 8.0, nor when we changed the number of parameters taken by the bpchar() cast function in 7.3. Per report from lsliang.
2011-09-06Properly document semphore requirements by accounting for workerBruce Momjian
processes. Backpatch to 9.1 and 9.0. Submitted by Anton Yuzhaninov, confirmed by Robert Haas
2011-09-05Document that contrib/pgtrgm only processes ASCII alphanumericBruce Momjian
characters. Backpatch to 9.0 and 9.1.
2011-08-23Add recovery.conf to the index in the user manual.Heikki Linnakangas
Fujii Masao
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-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-05Fix typo in sslmode documentationMagnus Hagander
Per bug #6089, noted by Sidney Cadot
2011-07-04Clarify that you need ActiveState perl 5.8 *or later* to build on Windows.Heikki Linnakangas
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-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-23In pg_upgrade docs, clarify that link mode uses "hard" links.Bruce Momjian
Backpatch to 9.1 and 9.0.
2011-06-20Fix missed use of "cp -i" in an example, per Fujii Masao.Tom Lane
Also be more careful about markup: use & not just &.
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-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.0.
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-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-13Add doc cross-reference to search_path discussion of current_schemas().Robert Haas
Brendan Jurd
2011-06-09Support silent mode for service registrations on win32Magnus Hagander
Using -s when registering a service will now suppress the application eventlog entries stating that the service is starting and started. MauMau
2011-06-09Fix documentation of information_schema.element_typesPeter Eisentraut
The documentation of the columns collection_type_identifier and dtd_identifier was wrong. This effectively reverts commits 8e1ccad51901e83916dae297cd9afa450957a36c and 57352df66d3a0885899d39c04c067e63c7c0ba30 and updates the name array_type_identifier (the name in SQL:1999) to collection_type_identifier. closes bug #5926
2011-06-04Fix documentation reference to "above" examplePeter Eisentraut
found by Thom Brown
2011-06-04More ECPG documentation fixesPeter Eisentraut
Marc Cousin
2011-06-04ECPG documentation fixPeter Eisentraut
Marc Cousin, Satoshi Nagayasu
2011-05-31Protect GIST logic that assumes penalty values can't be negative.Tom Lane
Apparently sane-looking penalty code might return small negative values, for example because of roundoff error. This will confuse places like gistchoose(). Prevent problems by clamping negative penalty values to zero. (Just to be really sure, I also made it force NaNs to zero.) Back-patch to all supported branches. Alexander Korotkov
2011-05-09Update documentation to state there is three-value logic, notBruce Momjian
three-value boolean logic. Backpatch to 9.0.X since we just got another bug report about this today.
2011-04-28The arguments to pg_ctl kill are not optional - remove brackets in the docs.Heikki Linnakangas
Fujii Masao
2011-04-27Add comments about the need to avoid uninitialized bits in datatype values.Tom Lane
There was already one recommendation in the documentation about writing C functions to ensure padding bytes are zeroes, but make it stronger. Also fix an example that was still using direct assignment to a varlena length word, which no longer works since the varvarlena changes.
2011-04-15Note that Bison on GnuWin32 has trouble with paths with spacesMagnus Hagander
Peter Eisentraut
2011-04-15Specify which versions of the Platform SDK are supportedMagnus Hagander
Anything including Visual Studio 2010 compilers is not yet supported for building on Windows.
2011-04-14Update release notes for releases 9.0.4, 8.4.8, 8.3.15, and 8.2.21.Tom Lane