aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* PL/Python: Convert oid to long/intPeter Eisentraut2012-09-29
| | | | | oid is a numeric type, so transform it to the appropriate Python numeric type like the other ones.
* Fix tar files emitted by pg_dump and pg_basebackup to be POSIX conformant.Tom Lane2012-09-28
| | | | | | | | | | | | | | | | | | | | Both programs got the "magic" string wrong, causing standard-conforming tar implementations to believe the output was just legacy tar format without any POSIX extensions. This doesn't actually matter that much, especially since pg_dump failed to fill the POSIX fields anyway, but still there is little point in emitting tar format if we can't be compliant with the standard. In addition, pg_dump failed to write the EOF marker correctly (there should be 2 blocks of zeroes not just one), pg_basebackup put the numeric group ID in the wrong place, and both programs had a pretty brain-dead idea of how to compute the checksum. Fix all that and improve the comments a bit. pg_restore is modified to accept either the correct POSIX-compliant "magic" string or the previous value. This part of the change will need to be back-patched to avoid an unnecessary compatibility break when a previous version tries to read tar-format output from 9.3 pg_dump. Brian Weaver and Tom Lane
* Fix examples of how to use "su" while starting the server.Tom Lane2012-09-25
| | | | | | | | The syntax "su -c 'command' username" is not accepted by all versions of su, for example not OpenBSD's. More portable is "su username -c 'command'". So change runtime.sgml to recommend that syntax. Also, add a -D switch to the OpenBSD example script, for consistency with other examples. Per Denis Lapshin and Gábor Hidvégi.
* Add support for include_dir in config file.Heikki Linnakangas2012-09-24
| | | | | | | This allows easily splitting configuration into many files, deployed in a directory. Magnus Hagander, Greg Smith, Selena Deckelmann, reviewed by Noah Misch.
* Minor corrections for ALTER TYPE ADD VALUE IF NOT EXISTS patch.Tom Lane2012-09-22
| | | | | | | | | Produce a NOTICE when the label already exists, for consistency with other CREATE IF NOT EXISTS commands. Also, fix the code so it produces something more user-friendly than an index violation when the label already exists. This not incidentally enables making a regression test that the previous patch didn't make for fear of exposing an unpredictable OID in the results. Also some wordsmithing on the documentation.
* Fix docs typoAndrew Dunstan2012-09-22
|
* Allow IF NOT EXISTS when add a new enum label.Andrew Dunstan2012-09-22
| | | | | | | | If the label is already in the enum the statement becomes a no-op. This will reduce the pain that comes from our not allowing this operation inside a transaction block. Andrew Dunstan, reviewed by Tom Lane and Magnus Hagander.
* Update release notes for 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21.Tom Lane2012-09-19
|
* Provide adequate documentation of the "table_name *" notation.Tom Lane2012-09-17
| | | | | | | | | Somewhere along the line, somebody decided to remove all trace of this notation from the documentation text. It was still in the command syntax synopses, or at least some of them, but with no indication what it meant. This will not do, as evidenced by the confusion apparent in bug #7543; even if the notation is now unnecessary, people will find it in legacy SQL code and need to know what it does.
* Fix documentation reference to maximum allowed for autovacuum_freeze_max_age.Kevin Grittner2012-09-16
| | | | | | | | | The documentation mentioned setting autovacuum_freeze_max_age to "its maximum allowed value of a little less than two billion". This led to a post asking about the exact maximum allowed value, which is precisely two billion, not "a little less". Based on question by Radovan Jablonovsky. Backpatch to 8.3.
* Fix catalog docs to reflect connoinherit change in 09ff76f.Andrew Dunstan2012-09-12
| | | | Backpatch to 9.2.
* Fix typo: lexemes misspelled in full text search docs.Kevin Grittner2012-09-11
| | | | Dan Scott
* Update syntax shown for \copy to match new syntax for COPY.Robert Haas2012-09-06
| | | | Etsuro Fujita
* Fix typo in information_schema documentation.Tom Lane2012-09-05
| | | | Shigeru Hanada
* Make one last copy-editing pass over the 9.2 release notes.Tom Lane2012-09-05
| | | | | Also, set the release date to 2012-09-10, since we're pretty well committed to that now.
* Document that pg_upgrade requires PGHOST be set for any pre-9.1 serversBruce Momjian2012-09-04
| | | | | | with a socket directory mismatch with the new server. Backpatch to 9.2.
* Mention basebackup-from-slave next to cascading replicationMagnus Hagander2012-09-04
|
* Fix pg_upgrade to cope with non-default unix_socket_directory scenarios.Tom Lane2012-09-03
| | | | | | | | | | | | | | | | | | | | | | When starting either an old or new postmaster, force it to place its Unix socket in the current directory. This makes it even harder for accidental connections to occur during pg_upgrade, and also works around some scenarios where the default socket location isn't usable. (For example, if the default location is something other than "/tmp", it might not exist during "make check".) When checking an already-running old postmaster, find out its actual socket directory location from postmaster.pid, if possible. This dodges problems with an old postmaster having a configured location different from the default built into pg_upgrade's libpq. We can't find that out if the old postmaster is pre-9.1, so also document how to cope with such scenarios manually. In support of this, centralize handling of the connection-related command line options passed to pg_upgrade's subsidiary programs, such as pg_dump. This should make future changes easier. Bruce Momjian and Tom Lane
* Update URLs that pointed to sun.com; either repoint them or removeBruce Momjian2012-09-02
| | | | them.
* Add small doc mention that libpq is named after POSTQUEL.Bruce Momjian2012-09-02
|
* Revert doc patch 305557984dd964ac397c6752e9d0f14646b60f15 as the valuesBruce Momjian2012-09-01
| | | | are sometimes signed, sometimes unsigned.
* Fix broken link in installation.sgml.Tom Lane2012-09-01
| | | | | Linking to other parts of the manual doesn't work when building the standalone INSTALL document.
* Cross-link to doc build requirements from install requirements.Robert Haas2012-09-01
| | | | Jeff Janes
* More documentation updates for LATERAL.Tom Lane2012-09-01
| | | | | | | | | | | | | | Extend xfunc.sgml's discussion of set-returning functions to show an example of using LATERAL, and recommend that over putting SRFs in the targetlist. In passing, reword func.sgml's section on set-returning functions so that it doesn't claim that the functions listed therein are all the built-in set-returning functions. That hasn't been true for a long time, and trying to make it so doesn't seem like it would be an improvement. (Perhaps we should rename that section?) Both per suggestions from Merlin Moncure.
* psql: Reduce compatibility warningPeter Eisentraut2012-08-31
| | | | | | Only warn when connecting to a newer server, since connecting to older servers works pretty well nowadays. Also update the documentation a little about current psql/server compatibility expectations.
* In pg_upgade, document that the port numbers must be different whenBruce Momjian2012-08-31
| | | | checking an old running server.
* Clarify FreeBSD instructions in pg_test_timing.Bruce Momjian2012-08-30
| | | | Josh Kupershmidt
* Properly document that SIGTERM is OK for users to use on a postgresBruce Momjian2012-08-30
| | | | | | session, now that pg_terminate_backend() uses it. Josh Kupershmidt
* Revert 1fbc30f1dca6624c01a9a6a9ff711a7036c68532 because theBruce Momjian2012-08-30
| | | | --enable-shared is about Plyton's configure, not ours.
* Remove doc mention of --enable-shared, per Tom.Bruce Momjian2012-08-30
|
* Document that max_locks_per_transaction might need to be increased forBruce Momjian2012-08-30
| | | | queries on parent tables, per suggestion from Josh Berkus.
* Fix checkpoint_timeout documentation to reflect current behavior.Robert Haas2012-08-30
| | | | Jeff Janes
* Document that log_autovacuum_min_duration can be used to monitorBruce Momjian2012-08-30
| | | | | | autovacuum activity. Per report from Marc Mamin
* Document how to prevent PostgreSQL itself from exhausting memory.Robert Haas2012-08-30
| | | | | | | | The existing documentation in Linux Memory Overcommit seemed to assume that PostgreSQL itself could never be the problem, or at least it didn't tell you what to do about it. Per discussion with Craig Ringer and Kevin Grittner.
* Document that COPY OUT requires an absolute pathname.Robert Haas2012-08-30
| | | | As suggested by Etsuro Fujita, but with somewhat different wording.
* Remove old documentation warnings about the use of bigint.Bruce Momjian2012-08-30
|
* Document that xslt-related RPMs may be needed to build docs.Robert Haas2012-08-30
|
* Document that NOTIFY events are visible to all users.Bruce Momjian2012-08-29
|
* Adjust pg_test_timing to show shortest test durations first, placeBruce Momjian2012-08-28
| | | | percentage column before count column. Docs updated.
* Update doc mention of how to compute bigint advisory lock value, per TomBruce Momjian2012-08-28
| | | | Lane's correction.
* Document how to create advisory lock "bigint" values in SQL.Bruce Momjian2012-08-27
| | | | David E. Wheeler
* Improve a couple of 9.2 release note entries.Tom Lane2012-08-27
| | | | | Clarify the compatibility notes about EXTRACT() and about statistics timing columns.
* Add section IDs to subsections of syntax.sgml that lacked them.Tom Lane2012-08-27
| | | | | | | This is so that these sections will have stable HTML tags that one can link to, rather than things like "AEN1902". Perhaps we should mount a campaign to do this everywhere, but I've found myself pointing at syntax.sgml subsections often enough to be sure it's useful here.
* Document the lack of reading the PGDATABASE environment variable inBruce Momjian2012-08-27
| | | | pg_restore.
* Update FreeBSD kernel configuration documentation.Bruce Momjian2012-08-26
| | | | Brad Davis
* Clarify documentation that primary key and unique constraints are copiedBruce Momjian2012-08-26
| | | | | | for CREATE TABLE LIKE ... INCLUDING INDEXES. Per report from david.sahagian@emc.com
* Document clearly that psql \! parameter interpretation limitations areBruce Momjian2012-08-25
| | | | the same as \copy.
* Some spelling adjustments in release notesPeter Eisentraut2012-08-24
|
* Normalize some British spellingsPeter Eisentraut2012-08-24
|
* Put options on man page and in help output in slightly better orderPeter Eisentraut2012-08-24
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-27 06:32:04 +0000