summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2012-10-09Add microsecs/op display to pg_test_fsync utilitySimon Riggs
e.g. fsync 2103.613 ops/sec ( 475 microsecs/op) Peter Geoghegan
2012-10-08Fix lo_read, lo_write, lo_truncate to cope with "size_t" length parameters.Tom Lane
libpq defines these functions as accepting "size_t" lengths ... but the underlying backend functions expect signed int32 length parameters, and so will misinterpret any value exceeding INT_MAX. Fix the libpq side to throw error rather than possibly doing something unexpected. This is a bug of long standing, but I doubt it's worth back-patching. The problem is really pretty academic anyway with lo_read/lo_write, since any caller expecting sane behavior would have to have provided a multi-gigabyte buffer. It's slightly more pressing with lo_truncate, but still we haven't supported large objects over 2GB until now.
2012-10-07Improve documentation about large-object functions.Tom Lane
Copy-editing for previous patch, plus fixing some longstanding markup issues and oversights (like not mentioning that failures will set the PQerrorMessage string).
2012-10-07Add API for 64-bit large object access. Now users can access up toTatsuo Ishii
4TB large objects (standard 8KB BLCKSZ case). For this purpose new libpq API lo_lseek64, lo_tell64 and lo_truncate64 are added. Also corresponding new backend functions lo_lseek64, lo_tell64 and lo_truncate64 are added. inv_api.c is changed to handle 64-bit offsets. Patch contributed by Nozomi Anzai (backend side) and Yugo Nagata (frontend side, docs, regression tests and example program). Reviewed by Kohei Kaigai. Committed by Tatsuo Ishii with minor editings.
2012-10-05Improve LDAP authentication documentationPeter Eisentraut
Use the terms "simple bind" and "search+bind" consistently do distinguish the two modes (better than first mode and second mode in any case). They were already used in some places, now it's just more prominent. Split up the list of options into one for common options and one for each mode, for clarity. Add configuration examples for either mode.
2012-10-05Removed sentence about not being able to retrieve more than one row at a time,Michael Meskes
because it is not correct.
2012-10-04Fix permissions explanations in CREATE DATABASE and CREATE SCHEMA docs.Tom Lane
These reference pages still claimed that you have to be superuser to create a database or schema owned by a different role. That was true before 8.1, but it was changed in commits aa1110624c08298393dfce996f7b21809d98d3fd and f91370cd2faf1fd35a1ac74d84652a85ed841919 to allow assignment of ownership to any role you are a member of. However, at the time we were thinking of that primarily as a change to the ALTER OWNER rules, so the need to touch these two CREATE ref pages got missed.
2012-10-03Support CREATE SCHEMA IF NOT EXISTS.Tom Lane
Per discussion, schema-element subcommands are not allowed together with this option, since it's not very obvious what should happen to the element objects. Fabrízio de Royes Mello
2012-10-03Add --sampling-rate option to pgbench.Heikki Linnakangas
This allows logging only some fraction of transactions, greatly reducing the amount of log generated. Tomas Vondra, reviewed by Robert Haas and Jeff Janes.
2012-10-03Return the number of rows processed when COPY is executed through SPI.Heikki Linnakangas
You can now get the number of rows processed by a COPY statement in a PL/pgSQL function with "GET DIAGNOSTICS x = ROW_COUNT". Pavel Stehule, reviewed by Amit Kapila, with some editing by me.
2012-10-01The max shared_buffers value that initdb will choose was raised, update docs.Heikki Linnakangas
Jeff Janes
2012-09-29PL/Python: Convert oid to long/intPeter Eisentraut
oid is a numeric type, so transform it to the appropriate Python numeric type like the other ones.
2012-09-28Fix tar files emitted by pg_dump and pg_basebackup to be POSIX conformant.Tom Lane
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
2012-09-25Fix examples of how to use "su" while starting the server.Tom Lane
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.
2012-09-24Add support for include_dir in config file.Heikki Linnakangas
This allows easily splitting configuration into many files, deployed in a directory. Magnus Hagander, Greg Smith, Selena Deckelmann, reviewed by Noah Misch.
2012-09-22Minor corrections for ALTER TYPE ADD VALUE IF NOT EXISTS patch.Tom Lane
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.
2012-09-22Fix docs typoAndrew Dunstan
2012-09-22Allow IF NOT EXISTS when add a new enum label.Andrew Dunstan
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.
2012-09-19Update release notes for 9.2.1, 9.1.6, 9.0.10, 8.4.14, 8.3.21.Tom Lane
2012-09-17Provide adequate documentation of the "table_name *" notation.Tom Lane
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.
2012-09-16Fix documentation reference to maximum allowed for autovacuum_freeze_max_age.Kevin Grittner
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.
2012-09-12Fix catalog docs to reflect connoinherit change in 09ff76f.Andrew Dunstan
Backpatch to 9.2.
2012-09-11Fix typo: lexemes misspelled in full text search docs.Kevin Grittner
Dan Scott
2012-09-06Update syntax shown for \copy to match new syntax for COPY.Robert Haas
Etsuro Fujita
2012-09-05Fix typo in information_schema documentation.Tom Lane
Shigeru Hanada
2012-09-05Make one last copy-editing pass over the 9.2 release notes.Tom Lane
Also, set the release date to 2012-09-10, since we're pretty well committed to that now.
2012-09-04Document that pg_upgrade requires PGHOST be set for any pre-9.1 serversBruce Momjian
with a socket directory mismatch with the new server. Backpatch to 9.2.
2012-09-04Mention basebackup-from-slave next to cascading replicationMagnus Hagander
2012-09-03Fix pg_upgrade to cope with non-default unix_socket_directory scenarios.Tom Lane
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
2012-09-02Update URLs that pointed to sun.com; either repoint them or removeBruce Momjian
them.
2012-09-02Add small doc mention that libpq is named after POSTQUEL.Bruce Momjian
2012-09-01Revert doc patch 305557984dd964ac397c6752e9d0f14646b60f15 as the valuesBruce Momjian
are sometimes signed, sometimes unsigned.
2012-09-01Fix broken link in installation.sgml.Tom Lane
Linking to other parts of the manual doesn't work when building the standalone INSTALL document.
2012-09-01Cross-link to doc build requirements from install requirements.Robert Haas
Jeff Janes
2012-09-01More documentation updates for LATERAL.Tom Lane
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.
2012-08-31psql: Reduce compatibility warningPeter Eisentraut
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.
2012-08-31In pg_upgade, document that the port numbers must be different whenBruce Momjian
checking an old running server.
2012-08-30Clarify FreeBSD instructions in pg_test_timing.Bruce Momjian
Josh Kupershmidt
2012-08-30Properly document that SIGTERM is OK for users to use on a postgresBruce Momjian
session, now that pg_terminate_backend() uses it. Josh Kupershmidt
2012-08-30Revert 1fbc30f1dca6624c01a9a6a9ff711a7036c68532 because theBruce Momjian
--enable-shared is about Plyton's configure, not ours.
2012-08-30Remove doc mention of --enable-shared, per Tom.Bruce Momjian
2012-08-30Document that max_locks_per_transaction might need to be increased forBruce Momjian
queries on parent tables, per suggestion from Josh Berkus.
2012-08-30Fix checkpoint_timeout documentation to reflect current behavior.Robert Haas
Jeff Janes
2012-08-30Document that log_autovacuum_min_duration can be used to monitorBruce Momjian
autovacuum activity. Per report from Marc Mamin
2012-08-30Document how to prevent PostgreSQL itself from exhausting memory.Robert Haas
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.
2012-08-30Document that COPY OUT requires an absolute pathname.Robert Haas
As suggested by Etsuro Fujita, but with somewhat different wording.
2012-08-30Remove old documentation warnings about the use of bigint.Bruce Momjian
2012-08-30Document that xslt-related RPMs may be needed to build docs.Robert Haas
2012-08-29Document that NOTIFY events are visible to all users.Bruce Momjian
2012-08-28Adjust pg_test_timing to show shortest test durations first, placeBruce Momjian
percentage column before count column. Docs updated.
generated by cgit v1.2.3 (git 2.46.0) at 2025-12-08 18:54:40 +0000