summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2010-02-17Stamp HEAD as 9.0devel, and update various places that were referring to 8.5Tom Lane
(hope I got 'em all). Per discussion, this release will be 9.0 not 8.5.
2010-02-17Tweak description of payload parameter.Tom Lane
2010-02-16Replace the pg_listener-based LISTEN/NOTIFY mechanism with an in-memory queue.Tom Lane
In addition, add support for a "payload" string to be passed along with each notify event. This implementation should be significantly more efficient than the old one, and is also more compatible with Hot Standby usage. There is not yet any facility for HS slaves to receive notifications generated on the master, although such a thing is possible in future. Joachim Wieland, reviewed by Jeff Davis; also hacked on by me.
2010-02-16Move log_error_verbosity GUC setting to "What to log" section, andBruce Momjian
document the behavior of terse and verbose output options.
2010-02-16Honor to_char() "FM" specification in YYY, YY, and Y; it was alreadyBruce Momjian
honored by YYYY. Also document Oracle "toggle" FM behavior. Per report from Guy Rouillier
2010-02-16Have SELECT and CREATE TABLE AS queries return a row count. While thisBruce Momjian
is invisible in psql, other interfaces, like libpq, make this value visible. Boszormenyi Zoltan
2010-02-16Clarify documentation on the behavior of unnamed bind queries.Bruce Momjian
2010-02-16Fix synopsis of DO statement.Itagaki Takahiro
2010-02-15Add psql tab completion for DO blocks.Itagaki Takahiro
Also adjust documentation of DO. Patch from David Fetter and subsequent discussion.
2010-02-14Ooops, let's get the non-null vs null bit right ...Tom Lane
2010-02-14Document the behavior of STRICT VARIADIC functions.Tom Lane
2010-02-13Remove tabs from sgml.Bruce Momjian
2010-02-12Add plperl.on_plperl_init and plperl.on_plperlu_init settings for ↵Andrew Dunstan
language-specific startup. Rename recently added plperl.on_perl_init to plperl.on_init. Also, code cleanup for utf8 hack. Patch from Tim Bunce, reviewed by Alex Hunsaker.
2010-02-12Extend the set of frame options supported for window functions.Tom Lane
This patch allows the frame to start from CURRENT ROW (in either RANGE or ROWS mode), and it also adds support for ROWS n PRECEDING and ROWS n FOLLOWING start and end points. (RANGE value PRECEDING/FOLLOWING isn't there yet --- the grammar works, but that's all.) Hitoshi Harada, reviewed by Pavel Stehule
2010-02-12Update Hot Standby documentation to reflect the change in the LOGHeikki Linnakangas
messages printed at startup. As pointed out by Simon Riggs.
2010-02-12Clean up Streaming Replication documentation a little bit. A lot moreHeikki Linnakangas
needs to be done, but it's a step forward..
2010-02-09Move "Warm Standby Servers for High Availability" and "Hot Standby"Heikki Linnakangas
sections under "High Availability, Load Balancing, and Replication" chapter. Streaming replication chapter needs a lot more work, but this commit just moves things around.
2010-02-08Create an official API function for C functions to use to check if they areTom Lane
being called as aggregates, and to get the aggregate transition state memory context if needed. Use it instead of poking directly into AggState and WindowAggState in places that shouldn't know so much. We should have done this in 8.4, probably, but better late than never. Revised version of a patch by Hitoshi Harada.
2010-02-08Update high availability/replication documentation chart for new hotBruce Momjian
standby featureset.
2010-02-08Remove old-style VACUUM FULL (which was known for a little while asTom Lane
VACUUM FULL INPLACE), along with a boatload of subsidiary code and complexity. Per discussion, the use case for this method of vacuuming is no longer large enough to justify maintaining it; not to mention that we don't wish to invest the work that would be needed to make it play nicely with Hot Standby. Aside from the code directly related to old-style VACUUM FULL, this commit removes support for certain WAL record types that could only be generated within VACUUM FULL, redirect-pointer removal in heap_page_prune, and nontransactional generation of cache invalidation sinval messages (the last being the sticking point for Hot Standby). We still have to retain all code that copes with finding HEAP_MOVED_OFF and HEAP_MOVED_IN flag bits on existing tuples. This can't be removed as long as we want to support in-place update from pre-9.0 databases.
2010-02-07Create a "relation mapping" infrastructure to support changing the relfilenodesTom Lane
of shared or nailed system catalogs. This has two key benefits: * The new CLUSTER-based VACUUM FULL can be applied safely to all catalogs. * We no longer have to use an unsafe reindex-in-place approach for reindexing shared catalogs. CLUSTER on nailed catalogs now works too, although I left it disabled on shared catalogs because the resulting pg_index.indisclustered update would only be visible in one database. Since reindexing shared system catalogs is now fully transactional and crash-safe, the former special cases in REINDEX behavior have been removed; shared catalogs are treated the same as non-shared. This commit does not do anything about the recently-discussed problem of deadlocks between VACUUM FULL/CLUSTER on a system catalog and other concurrent queries; will address that in a separate patch. As a stopgap, parallel_schedule has been tweaked to run vacuum.sql by itself, to avoid such failures during the regression tests.
2010-02-05Mention warm and now "hot" standby servers in the high availability docs.Bruce Momjian
2010-02-05Document that archive_timeout will force new WAL files even if a singleBruce Momjian
checkpoint has happened, and recommend adjusting checkpoint_timeout to reduce the impact of this.
2010-02-05Previous commit was: Properly document that OVER and WINDOW are Postgres ↵Bruce Momjian
reserved words.
2010-02-05Previous commit was to have tab checking as part of gmake check.Bruce Momjian
2010-02-05*** empty log message ***Bruce Momjian
2010-02-05Improve PL/Perl documentation of database access functions.Bruce Momjian
Alexey Klyukin
2010-02-05Add SGML 'check-tabs' Makefile rule to check for tabs.Bruce Momjian
2010-02-05Modify recently added PQconnectdbParams() with new argument, expand_dbname.Joe Conway
If expand_dbname is non-zero and dbname contains an = sign, it is taken as a conninfo string in exactly the same way as if it had been passed to PQconnectdb. This is equivalent to the way PQsetdbLogin() works, allowing PQconnectdbParams() to be a complete alternative. Also improve the way the new function is called from psql and replace a previously missed call to PQsetdbLogin() in psql. Additionally use PQconnectdbParams() for pg_dump and friends, and the bin/scripts command line utilities such as vacuumdb, createdb, etc. Finally, update the documentation for the new parameter, as well as the nuances of precedence in cases where key words are repeated or duplicated in the conninfo string.
2010-02-04Three out of four of us like this phrasing better.Tom Lane
2010-02-03Mention "unquoted" identifiers are case-insensitive.Bruce Momjian
2010-02-03Proofreading improvements for the Administration documentation book.Bruce Momjian
2010-02-03Add a message type header to the CopyData messages sent from primaryHeikki Linnakangas
to standby in streaming replication. While we only have one message type at the moment, adding a message type header makes this easier to extend.
2010-02-02Make RADIUS authentication use pg_getaddrinfo_all() to get address ofMagnus Hagander
the server. Gets rid of a fairly ugly hack for Solaris, and also provides hostname and IPV6 support.
2010-02-01Remove tabs in sgml.Bruce Momjian
2010-02-01Minor documentation improvements for new string_agg aggregate.Robert Haas
2010-02-01Revoke augmentation of WAL records for btree delete, per discussion.Simon Riggs
2010-02-01Add string_agg aggregate functions. The one argument version concatenatesItagaki Takahiro
the input values into a string. The two argument version also does the same thing, but inserts delimiters between elements. Original patch by Pavel Stehule, reviewed by David E. Wheeler and me.
2010-01-30Add plperl.on_perl_init setting to provide for initializing the perl library ↵Andrew Dunstan
on load. Also, handle END blocks in plperl. Database access is disallowed during both these operations, although it might be allowed in END blocks in future. Patch from Tim Bunce.
2010-01-29Augment WAL records for btree delete with GetOldestXmin() to reduceSimon Riggs
false positives during Hot Standby conflict processing. Simple patch to enhance conflict processing, following previous discussions. Controlled by parameter minimize_standby_conflicts = on | off, with default off allows measurement of performance impact to see whether it should be set on all the time.
2010-01-29Allow psql variables to be interpolated with literal or identifier escaping.Robert Haas
Loosely based on a patch by Pavel Stehule.
2010-01-28Add new make targets "world", "install-world" and "installcheck-world" to ↵Andrew Dunstan
build, install and check just about everything. In addition to everything built installed and tested by all, install and installcheck targets, these build HTML Docs, build and test contrib, and test PLs and ECPG.
2010-01-28Type table featurePeter Eisentraut
This adds the CREATE TABLE name OF type command, per SQL standard.
2010-01-28Add functions to reset the statistics counter for a single table/index orMagnus Hagander
a single function.
2010-01-28Introduce two new libpq connection functions, PQconnectdbParams andJoe Conway
PQconnectStartParams. These are analogous to PQconnectdb and PQconnectStart respectively. They differ from the legacy functions in that they accept two NULL-terminated arrays, keywords and values, rather than conninfo strings. This avoids the need to build the conninfo string in cases where it might be inconvenient to do so. Includes documentation. Also modify psql to utilize PQconnectdbParams rather than PQsetdbLogin. This allows the new config parameter application_name to be set, which in turn is displayed in the pg_stat_activity view and included in CSV log entries. This will also ensure both new functions get regularly exercised. Patch by Guillaume Lelarge with review and minor adjustments by Joe Conway.
2010-01-27Fix typo.Magnus Hagander
Noted by Thom Brown.
2010-01-27Add support for RADIUS authentication.Magnus Hagander
2010-01-27Fix plperl.sgml errors from recent commit.Andrew Dunstan
2010-01-26Various small improvements and cleanups for PL/Perl.Andrew Dunstan
- Allow (ineffective) use of 'require' in plperl If the required module is not already loaded then it dies. So "use strict;" now works in plperl. - Pre-load the feature module if perl >= 5.10. So "use feature :5.10;" now works in plperl. - Stored procedure subs are now given names. The names are not visible in ordinary use, but they make tools like Devel::NYTProf and Devel::Cover much more useful. - Simplified and generalized the subroutine creation code. Now one code path for generating sub source code, not four. Can generate multiple 'use' statements with specific imports (which handles plperl.use_strict currently and can easily be extended to handle a plperl.use_feature=':5.12' in future). - Disallows use of Safe version 2.20 which is broken for PL/Perl. http://rt.perl.org/rt3/Ticket/Display.html?id=72068 - Assorted minor optimizations by pre-growing data structures. Patch from Tim Bunce, reviewed by Alex Hunsaker.
2010-01-26Remove the default_do_language parameter, instead making DO use a hardwiredTom Lane
default of "plpgsql". This is more reasonable than it was when the DO patch was written, because we have since decided that plpgsql should be installed by default. Per discussion, having a parameter for this doesn't seem useful enough to justify the risk of application breakage if the value is changed unexpectedly.
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-28 21:11:23 +0000