aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Properly document the existance of OLD/NEW trigger pl/pgsql triggerBruce Momjian2011-09-06
| | | | | | | | fields. Backpatch to 9.0 and 9.1. Report from Pavel Stehule, patch from Josh Kupershmidt
* Fix spelling mistake in pgpass documentation change.Bruce Momjian2011-09-06
| | | | Per Peter.
* Add documentation suggestion about adding a comment to the top ofBruce Momjian2011-09-06
| | | | | | pgpass. Backpatch to 9.1.
* Fix plpgsql "PERFORM" markup.Bruce Momjian2011-09-06
| | | | Backpatch to 9.0 and 9.1.
* Document PERFORM limitation when using WITH queries.Bruce Momjian2011-09-06
| | | | | | Backpatch to 9.0 and 9.1. Report from depstein@alliedtesting.com.
* Add an "incompatibility" entry to 9.1 release notes about CREATE EXTENSION.Tom Lane2011-09-06
| | | | | | We've now seen more than one gripe from somebody who didn't get the memo about how to install contrib modules in 9.1. Try to make it a little more prominent that you aren't supposed to call the scripts directly anymore.
* Update type-conversion documentation for long-ago changes.Tom Lane2011-09-06
| | | | | | 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.
* Properly document semphore requirements by accounting for workerBruce Momjian2011-09-06
| | | | | | | | processes. Backpatch to 9.1 and 9.0. Submitted by Anton Yuzhaninov, confirmed by Robert Haas
* Add documentation link to strftime supported options.Bruce Momjian2011-09-05
|
* Add mention that UTC really means UT1.Bruce Momjian2011-09-05
| | | | Backpatch to 9.1.
* Document that contrib/pgtrgm only processes ASCII alphanumericBruce Momjian2011-09-05
| | | | | | characters. Backpatch to 9.0 and 9.1.
* Userspace access vector cache for contrib/sepgsql.Robert Haas2011-09-01
| | | | KaiGai Kohei
* The replication status values in pg_stat_replication was changed toHeikki Linnakangas2011-08-31
| | | | | | lowercase earlier, but documentation was not updated. Update the docs. Fujii Masao
* Some markup cleanup to deconfuse the find_gt_lt toolPeter Eisentraut2011-08-30
| | | | Josh Kupershmidt
* Repair brain fade in previous commit, per Josh Kupershmidt.Robert Haas2011-08-30
|
* Add --if-exists option to dropdb and dropuser.Robert Haas2011-08-30
| | | | Josh Kupershmidt, with some further editing by me.
* Document minimum required version of DocBook XSL stylesheetsPeter Eisentraut2011-08-27
|
* Implement the information schema with_hierarchy columnPeter Eisentraut2011-08-27
| | | | | In PostgreSQL, this is included in the SELECT privilege, so show YES or NO depending on whether SELECT is granted.
* Spelling improvementPeter Eisentraut2011-08-27
|
* Clean up weird corner cases in lexing of psql meta-command arguments.Tom Lane2011-08-26
| | | | | | | | | | | | | | These changes allow backtick command evaluation and psql variable interpolation to happen on substrings of a single meta-command argument. Formerly, no such evaluations happened at all if the backtick or colon wasn't the first character of the argument, and we considered an argument completed as soon as we'd processed one backtick, variable reference, or quoted substring. A string like 'FOO'BAR was thus taken as two arguments not one, not exactly what one would expect. In the new coding, an argument is considered terminated only by unquoted whitespace or backslash. Also, clean up a bunch of omissions, infelicities and outright errors in the psql documentation of variables and metacommand argument syntax.
* Support non-ASCII letters in psql variable names.Tom Lane2011-08-26
| | | | | As in the backend, the implementation actually accepts any non-ASCII character, but we only document that you can use letters.
* Adjust CREATE DOMAIN example for standard_conforming_strings=on.Robert Haas2011-08-25
| | | | Noted by Hitoshi Harada.
* Fix pgxs.mk to always add --dbname=$(CONTRIB_TESTDB) to REGRESS_OPTS.Tom Lane2011-08-24
| | | | | | | | | | | | | | The previous coding resulted in contrib modules unintentionally overriding the use of CONTRIB_TESTDB. There seems no particularly good reason to allow that (after all, the makefile can set CONTRIB_TESTDB if that's really what it intends). In passing, document REGRESS_OPTS where the other pgxs.mk options are documented. Back-patch to 9.1 --- in prior versions, there were no cases of contrib modules setting REGRESS_OPTS without including the --dbname switch, so while the coding was fragile there was no actual bug.
* Add recovery.conf to the index in the user manual.Heikki Linnakangas2011-08-23
| | | | Fujii Masao
* Update 9.1 release notes to reflect commits through today.Tom Lane2011-08-17
| | | | Also do another pass of copy-editing.
* Adjust wording now that estimated size can increaseMagnus Hagander2011-08-17
| | | | Per comment form Fujii Masao.
* MacOS -> Mac OSPeter Eisentraut2011-08-17
| | | | Josh Kupershmidt
* Fix typoPeter Eisentraut2011-08-14
|
* Add major features list and introductory text for 9.1 release notes.Bruce Momjian2011-08-11
| | | | Backpatch to 9.1, obviously.
* Display both per-table and per-column FDW options in psql's \d output.Robert Haas2011-08-11
| | | | | | | Along the way, rename "Options" to "FDW Options" in various places for consistency and clarity. Shigeru Hanada
* Change psql's \dd command to do something more useful.Robert Haas2011-08-11
| | | | | | | | | | | | | Instead of displaying comments on an arbitrary subset of the object types which support them, make \dd display comments on exactly those object types which don't have their own backlash commands. We now regard the display of comments as properly the job of the relevant backslash command (though many of them do so only in verbose mode) rather than something that \dd should be responsible for. However, a handful of object types have no backlash command, so make \dd give information about those. Josh Kupershmidt
* Remove wal_sender_delay GUC, because it's no longer useful.Tom Lane2011-08-10
| | | | | | | | | | | | | | The latch infrastructure is now capable of detecting all cases where the walsender loop needs to wake up, so there is no reason to have an arbitrary timeout. Also, modify the walsender loop logic to follow the standard pattern of ResetLatch, test for work to do, WaitLatch. The previous coding was both hard to follow and buggy: it would sometimes busy-loop despite having nothing available to do, eg between receipt of a signal and the next time it was caught up with new WAL, and it also had interesting choices like deciding to update to WALSNDSTATE_STREAMING on the strength of information known to be obsolete.
* Teach psql to display the comments on SQL/MED objects in verbose mode.Robert Haas2011-08-08
| | | | | | | | | The relevant backslash commands already exist, so we're just adding an additional column. With this commit, all objects that have psql backslash commands and accept comments should now display those comments at least in verbose mode. Josh Kupershmidt, with doc additions by me.
* Teach psql to display the comments on conversions and domains.Robert Haas2011-08-08
| | | | | | | | | | | \dc and \dD now accept a "+" option, which will cause the comments to be displayed. Along the way, correct a few oversights in the previous commit in this area, 3b17efdfdd846c9bfad1637686e6f18198ea3df5 - namely, (1) when \dL+ is used, make description still be the last column, for consistency with what we've done elsewhere; and (2) document the difference between \dC and \dC+. Josh Kupershmidt, with a couple of doc changes by me.
* Teach vacuumlo to limit number of removals, via new -l option.Robert Haas2011-08-08
| | | | | | | Also, handle failure better: don't just blindly keep trying to delete stuff after the transaction has already failed. Tim Lewis, reviewed by Josh Kupershmidt, with further hacking by me.
* Add "Compatibility" section to ALTER EXTENSION reference pagePeter Eisentraut2011-08-07
| | | | Almost all other pages have one; this one must have been forgotten.
* Remove whitespace from end of linesPeter Eisentraut2011-08-07
|
* Rename "Example" sections to "Examples" in dblink chapterPeter Eisentraut2011-08-07
| | | | For consistency with other man pages.
* Fix a whitespace issue with the man pagesPeter Eisentraut2011-08-07
| | | | | | | | | | | | | | | | | | | | | There is what may actually be a mistake in our markup. The problem is in a situation like <para> <command>FOO</command> is ... there is strictly speaking a line break before "FOO". In the HTML output, this does not appear to be a problem, but in the man page output, this shows up, so you get double blank lines at odd places. So far, we have attempted to work around this with an XSL hack, but that causes other problems, such as creating run-ins in places like <acronym>SQL</acronym> <command>COPY</command> So fix the problem properly by removing the extra whitespace. I only fixed the problems that affect the man page output, not all the places.
* Fix thinko in documentation of local_preload_libraries.Tom Lane2011-08-05
| | | | | | | | 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.
* Allow per-column foreign data wrapper options.Robert Haas2011-08-05
| | | | Shigeru Hanada, with fairly minor editing by me.
* Fix markup for recent wal_level clarification.Bruce Momjian2011-08-04
| | | | Backpatch to 9.1 and 9.0.
* Teach psql to display comments on languages and casts.Robert Haas2011-08-04
| | | | | | | | The output of \dL (list languages) is fairly narrow, so we just always display the comment. \dC (list casts) can get fairly wide, so we only display comments if the new \dC+ option is specified. Josh Kupershmidt
* In documentaiton, clarify which commands have reduced WAL volume forBruce Momjian2011-08-04
| | | | | | wal_level = minimum. Backpatch to 9.1 and 9.0.
* Fix typo.Robert Haas2011-07-27
| | | | Noted by Josh Kupershmidt.
* Clarify which relkinds accept column comments.Robert Haas2011-07-26
| | | | Per discussion with Josh Kupershmidt.
* Improvements to SQL/MED documentation.Robert Haas2011-07-25
| | | | Laurenz Albe, somewhat modified by me.
* Add new pgbench options, --tablespace and --index-tablespace.Robert Haas2011-07-25
| | | | Per a request from Greg Smith.
* Add new pgbench switch, --unlogged-tables.Robert Haas2011-07-25
| | | | | This entails adjusting pgbench to use getopt_long() rather than getopt().
* Change EDITOR_LINENUMBER_SWITCH to an environment variablePeter Eisentraut2011-07-24
| | | | | | | | | | | 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.