summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2008-11-21Document which GUC settings are enums and not strings, along with a shortMagnus Hagander
paragraph about what that means.
2008-11-21Docs update for enumvals patch.Magnus Hagander
2008-11-21Include the platform "FAQs" into the installation instructions.Peter Eisentraut
I weeded out some really old information along the way. FAQ_AIX needs separate consideration and will be dealt with later.
2008-11-21Use relation_expr for TABLE command, requested by Tom.Peter Eisentraut
2008-11-20Note that the example aggregate array_accum is comparable to the nowTom Lane
built-in array_agg. Per suggestion from Robert Haas.
2008-11-20Issue a proper error message when MD5 is attempted whenBruce Momjian
db_user_namespace is enabled. Also document this limitation.
2008-11-20TABLE commandPeter Eisentraut
2008-11-20Add support for using SSL client certificates to authenticate to theMagnus Hagander
database (only for SSL connections, obviously).
2008-11-20Control client certificate requesting with the pg_hba option "clientcert"Magnus Hagander
instead of just relying on the root certificate file to be present.
2008-11-19Add WITH as a refname to the SELECT reference page.Peter Eisentraut
Now "\help WITH" works and there will be a separate WITH(7) man page.
2008-11-19Add "Most Common Implementation" row to high availablity table so theBruce Momjian
table is less abstract. Most common implementations were already mentioned in the text.
2008-11-19Add auto-explain contrib module for automatic logging of the plans ofTom Lane
slow-running queries. Takahiro Itagaki
2008-11-18Ident authentication over Unix-domain sockets on Solaris, usingPeter Eisentraut
getpeerucred() function. Author: Garick Hamlin <ghamlin@isc.upenn.edu>
2008-11-17Document that Bucardo is an example of mulit-master replication withBruce Momjian
conflict resolution.
2008-11-16Modify UPDATE/DELETE WHERE CURRENT OF to use the FOR UPDATE infrastructure toTom Lane
locate the target row, if the cursor was declared with FOR UPDATE or FOR SHARE. This approach is more flexible and reliable than digging through the plan tree; for instance it can cope with join cursors. But we still provide the old code for use with non-FOR-UPDATE cursors. Per gripe from Robert Haas.
2008-11-14Document a gotcha that happens on Windows when using libpq's new eventTom Lane
procedure support: it's possible to get confused because exported procedures have two different addresses. Per Andrew Chernow.
2008-11-14Reduce contrib/intagg to a thin wrapper around the new core functionsTom Lane
array_agg() and unnest(). We could drop it entirely in the future, but let's keep it for a release or two as a compatibility assist.
2008-11-14Since doc/src/sgml already builds the HTML docs twice to resolve indexPeter Eisentraut
entries, we don't have to do two builds here as well.
2008-11-14Set SQL man pages to be section 7 by default, and only transform them toPeter Eisentraut
another section if required by the platform (instead of the old way of building them in section "l" and always transforming them to the platform-specific section). This speeds up the installation on common platforms, and it avoids some funny business with the man page tools and build process.
2008-11-14Implement the basic form of UNNEST, ie unnest(anyarray) returns setofTom Lane
anyelement. This lacks the WITH ORDINALITY option, as well as the multiple input arrays option added in the most recent SQL specs. But it's still a pretty useful subset of the spec's functionality, and it is enough to allow obsoleting contrib/intagg.
2008-11-13Marginal editorial improvements for array_agg patch documentation.Tom Lane
2008-11-13array_agg aggregate function, as per SQL:2008, but without ORDER BY clausePeter Eisentraut
Rearrange the documentation a bit now that array_agg and xmlagg have similar semantics and issues. best of Robert Haas, Jeff Davis, Peter Eisentraut
2008-11-13Fix libpq certificate validation for SSL connections.Magnus Hagander
Add config parameter "sslverify" to control the verification. Default is to do full verification. Clean up some old SSL code that never really worked.
2008-11-12Support for man page links, if a man page has more than one refname.Peter Eisentraut
We don't actually use this anywhere, but it might come in handy for dealing with SELECT/WITH/TABLE. It works with both the old and the new man page target (for some value of "works").
2008-11-12Remove unnecessary whitespace in refname elements. This confuses thePeter Eisentraut
man page tools.
2008-11-12Add refentrytitle elements to refentry pages. Their absence confused thePeter Eisentraut
man page tools somewhat.
2008-11-12array_length() function, and for SQL compatibility also cardinality()Peter Eisentraut
function as a special case. This version still has the suspicious behavior of returning null for an empty array (rather than zero), but this may need a wholesale revision of empty array behavior, currently under discussion. Jim Nasby, Robert Haas, Peter Eisentraut
2008-11-11Mention the tup_fetched column in pg_stat_database.Magnus Hagander
Greg Sabino Mullane
2008-11-11Add support for input and output of interval values formatted per ISO 8601;Tom Lane
specifically, we can input either the "format with designators" or the "alternative format", and we can output the former when IntervalStyle is set to iso_8601. Ron Mayer
2008-11-10Add a --locale switch to createdb, to ease the creation of databases withAlvaro Herrera
different locales. This is just syntactical sweetener over --lc-collate and --lc-ctype. Per discussion. While at it, properly document --lc-ctype and --lc-collate in SGML docs, which apparently were forgotten (or purposefully ommited?) when they were created.
2008-11-10Make relhasrules and relhastriggers work like relhasindex, namely we letTom Lane
VACUUM reset them to false rather than trying to clean 'em up during DROP.
2008-11-09Replace pg_class.reltriggers with relhastriggers, which is just a boolean hintTom Lane
("there might be triggers") rather than an exact count. This is necessary catalog infrastructure for the upcoming patch to reduce the strength of locking needed for trigger addition/removal. Split out and committed separately for ease of reviewing/testing. In passing, also get rid of the unused pg_class columns relukeys, relfkeys, and relrefs, which haven't been maintained in many years and now have no chance of ever being maintained (because of wishing to avoid locking). Simon Riggs
2008-11-09Add a startup check that pg_xlog and pg_xlog/archive_status exist.Tom Lane
If the latter doesn't exist, automatically recreate it. (We don't do this for pg_xlog, though, per discussion.) Jonah Harris
2008-11-09Add some documentation about handling of fractions in interval input.Tom Lane
(It's always worked like this, but we never documented it before.)
2008-11-09Add a new GUC variable called "IntervalStyle" that decouples interval outputTom Lane
from DateStyle, and create a new interval style that produces output matching the SQL standard (at least for interval values that fall within the standard's restrictions). IntervalStyle is also used to resolve the conflict between the standard and traditional Postgres rules for interpreting negative interval input. Ron Mayer
2008-11-07Improve documentation of pg_typeof, per gripe from David Wheeler.Tom Lane
2008-11-07Implement ALTER DATABASE SET TABLESPACE to move a whole database (or at leastTom Lane
as much of it as lives in its default tablespace) to a new tablespace. Guillaume Lelarge, with some help from Bernd Helmle and Tom Lane
2008-11-06Improve psql's \dC command to take a pattern parameter. Casts are shownTom Lane
if their source or target types match the pattern (using the same definition of "match" as \dT does). Per recent discussion.
2008-11-04Document that SSL is only possible on tcp/ip connections in theBruce Momjian
postgresql.conf 'ssl' section.
2008-11-04Document that 'sslmode' is ignored for Unix domain socket communication;Bruce Momjian
backpatch to 8.3.X.
2008-11-04Experimental new support for building man pages via docbook2x, an XSL-basedPeter Eisentraut
tool chain. With some polishing, this might help us get rid of our ancient and crufty man page build mechanism.
2008-11-04ADD array_ndims functionPeter Eisentraut
Author: Robert Haas <robertmhaas@gmail.com>
2008-11-04Add missing colon to docs.Bruce Momjian
2008-11-04Remove tabs from SGML file.Bruce Momjian
2008-11-04Disallow LOCK TABLE outside a transaction block (or function), since this caseTom Lane
almost certainly represents user error. Per a gripe from Sebastian Böhm and subsequent discussion.
2008-11-03Allow uuid_in() to parse a wider variety of variant input formats for the UUIDPeter Eisentraut
data type. This patch takes the approach of allowing an optional hyphen after each group of four hex digits. Author: Robert Haas <robertmhaas@gmail.com>
2008-11-03suppress_redundant_updates_trigger function.Andrew Dunstan
2008-11-03Add pg_typeof() function.Tom Lane
Brendan Jurd
2008-11-03Update URL to Docbook DSSSL stylesheets, per Gabriele Bartolini.Alvaro Herrera
2008-11-03Change the pgstat logic so that the stats collector writes the stats file onlyTom Lane
upon requests from backends, rather than on a fixed 500msec cycle. (There's still throttling logic to ensure it writes no more often than once per 500msec, though.) This should result in a significant reduction in stats file write traffic in typical scenarios where the stats are demanded only infrequently. This approach also means that the former difficulty with changing stats_temp_directory on-the-fly has gone away, so remove the caution about that as well as the thrashing we did to minimize the trouble window. In passing, also fix pgstat_report_stat() so that we will send a stats message if we have function call stats but not table stats to report; this fixes a bug in the recent patch to support function-call stats. Martin Pihlak