summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2009-01-04Add contrib/pg_stat_statements for server-wide tracking of statement executionTom Lane
statistics. Takahiro Itagaki
2009-01-02Today is find-typo-in-old-patches day. Fix wrong cut/paste in identMagnus Hagander
documentation.
2009-01-02Make it possible to change Kerberos/GSSAPI parameters without restartingMagnus Hagander
the postmaster. They are only used in backend processes, so it's just a matter of re-labeling the GUCs.
2009-01-02Tweak guc.c to allow underscores in the names of custom variable classes,Tom Lane
and change auto_explain's custom GUC variables to be named auto_explain.xxx not just explain.xxx. Per discussion in connection with the pg_stat_statements patch, it seems like a good idea to have the convention that custom variable classes are named the same as their defining module. Committing separately since this should happen regardless of what happens with pg_stat_statements itself.
2009-01-01Update copyright for 2009.Bruce Momjian
2008-12-31Throw error if a <window definition> references a window that already has aTom Lane
frame clause, as appears to be required by the fine print in the SQL spec. Per discussion with Pavel, not doing so risks user confusion.
2008-12-31Add a WINDOW attribute to CREATE FUNCTION, and teach pg_dump about it,Tom Lane
so that user-defined window functions are possible. For the moment you'll have to write them in C, for lack of any interface to the WindowObject API in the available PLs, but it's better than no support at all. There was some debate about the best syntax for this. I ended up choosing the "it's an attribute" position --- the other approach will inevitably be more work, and the likely market for user-defined window functions is probably too small to justify it.
2008-12-31Add some basic support for window frame clauses to the window-functionsTom Lane
patch. This includes the ability to force the frame to cover the whole partition, and the ability to make the frame end exactly on the current row rather than its last ORDER BY peer. Supporting any more of the full SQL frame-clause syntax will require nontrivial hacking on the window aggregate code, so it'll have to wait for 8.5 or beyond.
2008-12-29Fix thinko in documentation of default window frame behavior,Tom Lane
per Hitoshi Harada.
2008-12-28Support window functions a la SQL:2008.Tom Lane
Hitoshi Harada, with some kibitzing from Heikki and Tom.
2008-12-19Add a new column proiswindow to pg_proc. It doesn't actually do anythingTom Lane
useful yet, but I'm tired of re-merging this aspect of the window functions patch.
2008-12-19SQL/MED catalog manipulation facilitiesPeter Eisentraut
This doesn't do any remote or external things yet, but it gives modules like plproxy and dblink a standardized and future-proof system for managing their connection information. Martin Pihlak and Peter Eisentraut
2008-12-19Add a couple of cross-references to the docs about enum types, per aTom Lane
recent gripe that the info is hard to find.
2008-12-18Add "not" to wal journaling text.Bruce Momjian
2008-12-18Clarify documentation that journaling is not required for WAL or data files.Bruce Momjian
2008-12-18Code review for function default parameters patch. Fix numerous problems asTom Lane
per recent discussions. In passing this also fixes a couple of bugs in the previous variadic-parameters patch.
2008-12-18Update documentation table describing how shared memory is used byBruce Momjian
various facilities.
2008-12-18Add note that TRUNCATE uses an access exclusive lock. This apparentlyPeter Eisentraut
surprised/confused some users.
2008-12-16Add note to the shared memory sizing table about needing to use page count inAlvaro Herrera
shared_buffers and wal_buffers, not size in bytes. Per discussion.
2008-12-16Fix wording of section comparing triggers and rules; old wording asBruce Momjian
confusing.
2008-12-15Add documentation that pg_standby sleeps on Win32 because of 'copy' behavior.Bruce Momjian
2008-12-15Code review for CREATE OR REPLACE VIEW patch. Do things in a saner order toTom Lane
result in hopefully-less-confusing error messages when the new definition isn't compatible with the old; minor other cleanup.
2008-12-15Support specifying filename for SSL certificate, key, root certificate storeMagnus Hagander
and certificate revokation list by using connection parameters or environment variables. Original patch by Mark Woodward, heavily reworked by Alvaro Herrera and Magnus Hagander.
2008-12-13Increase the default value of default_statistics_target from 10 to 100,Tom Lane
and its maximum value from 1000 to 10000. ALTER TABLE SET STATISTICS similarly now allows a value up to 10000. Per discussion.
2008-12-11To reduce confusion over whether VACUUM FULL is needed for anti-wraparoundTom Lane
vacuuming (it's not), say "database-wide VACUUM" instead of "full-database VACUUM" in the relevant hint messages. Also, document the permissions needed to do this. Per today's discussion.
2008-12-11Append major version number and for libraries soname major version numberPeter Eisentraut
to the gettext domain name, to simplify parallel installations. Also, rename set_text_domain() to pg_bindtextdomain(), because that is what it does.
2008-12-10Update journaling performance docs based on comments by Michael Renner.Bruce Momjian
2008-12-09Add a specific example of parenthesizing when extracting a field of aTom Lane
composite column. Might help cut down on future questions...
2008-12-08Clearify how processes are started by autovacuum, and what the effectMagnus Hagander
of autovacuum_max_workers parameter is. Per discussion with Alvaro.
2008-12-08Add note that autovacuum can use up several times maintenance_work_mem,Magnus Hagander
with warning against setting it too high.
2008-12-07Desultorily enclose programlisting tags in CDATA, to get rid of some obnoxiousAlvaro Herrera
SGML-escaping.
2008-12-06Allow CREATE OR REPLACE VIEW to add columns to the _end_ of the view.Bruce Momjian
Robert Haas
2008-12-06Document that non-data journaling is a recommended mount option.Bruce Momjian
2008-12-04Default values for function argumentsPeter Eisentraut
Pavel Stehule, with some tweaks by Peter Eisentraut
2008-12-03Update key words table to 8.4 and SQL:2008.Peter Eisentraut
2008-12-02Documentation for wildcard certificates patchMagnus Hagander
2008-12-01Add braces to clarify syntax synopsisPeter Eisentraut
2008-12-01Small correctionPeter Eisentraut
2008-12-01typoPeter Eisentraut
2008-11-30Add a "LIKE = typename" clause to CREATE TYPE for base types. This allowsTom Lane
the basic representational details (typlen, typalign, typbyval, typstorage) to be copied from an existing type rather than listed explicitly in the CREATE TYPE command. The immediate reason for this is to provide a simple solution for add-on modules that want to define types represented as int8, float4, or float8: as of 8.4 the appropriate PASSEDBYVALUE setting is platform-specific and so it's hard for a SQL script to know what to do. This patch fixes the contrib/isn breakage reported by Rushabh Lathia.
2008-11-28Support regular expressions in pg_ident.conf.Magnus Hagander
2008-11-27Add that PL/Java is an implementation of SQL/JRT, and drop claim thatPeter Eisentraut
PL/pgSQL has much to do with SQL/PSM.
2008-11-27Tweak wording of DISCARD ALL description to avoid giving the impressionTom Lane
that the presented list of equivalent operations is meant to be the primary definition of what it does. Per comment from Guillaume Smet.
2008-11-26configure check for docbook2man program, used in the new XML-based manPeter Eisentraut
page build target. This covers from-source, Debian, and Fedora installation variants.
2008-11-26Make DISCARD ALL discard advisory locks, too. Marko KreenTom Lane
2008-11-25information_schema.key_column_usage.position_in_unique_constraint wasTom Lane
misdocumented as not being implemented. In reality it has worked since the release of 8.2.
2008-11-25Remove PGINTERVALSTYLE from the set of special environment variables forTom Lane
libpq. As noted by Peter, adding this variable created a risk of unexpected connection failures when talking to older server versions, and since it doesn't do anything you can't do with PGOPTIONS, it doesn't seem really necessary. Removing it does occasion a few extra lines in pg_regress.c, but saving a getenv() call per libpq connection attempt is perhaps worth that anyway.
2008-11-24Move FAQ_AIX information to installation instructions.Peter Eisentraut
The information on why the shared libraries are built the way they are was not relevant to end users and has been made a mailing list archive link in Makefile.shlib.
2008-11-24CLUSTER VERBOSE and corresponding clusterdb --verbose optionPeter Eisentraut
Jim Cox and Peter Eisentraut
2008-11-21Minor copy-editing.Tom Lane