summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2009-01-07Create a third option named "partition" for constraint_exclusion, and make itTom Lane
the default. This setting enables constraint exclusion checks only for appendrel members (ie, inheritance children and UNION ALL arms), which are the cases in which constraint exclusion is most likely to be useful. Avoiding the overhead for simple queries that are unlikely to benefit should bring the cost down to the point where this is a reasonable default setting. Per today's discussion.
2009-01-07Have current_query() use ActivePortal->sourceText rather thanBruce Momjian
debug_query_string; this allows current_query() to be more accurate; docs updated; per idea from Tom
2009-01-07Fix executor/spi.h to follow our usual conventions for include files, ie,Tom Lane
not include postgres.h nor anything else it doesn't directly need. Add #includes to calling files as needed to compensate. Per my proposal of yesterday. This should be noted as a source code change in the 8.4 release notes, since it's likely to require changes in add-on modules.
2009-01-07Add hba parameter include_realm to krb5, gss and sspi authentication, usedMagnus Hagander
to pass the full username@realm string to the authentication instead of just the username. This makes it possible to use pg_ident.conf to authenticate users from multiple realms as different database users.
2009-01-07Allow krb_realm (krb5, gssapi and sspi) and krb_server_hostname (krb5 only)Magnus Hagander
authentication options to be set in pg_hba.conf on a per-line basis, to override the defaults set in postgresql.conf.
2009-01-07Add appropriate text for SIGHUP parameters instead of just removing itMagnus Hagander
like previous patch did. Per note from Tom Lane
2009-01-07Break out \distv into four separate lines in the psql documentation, forBruce Momjian
clarity.
2009-01-06Add documentation for new \d*S* patch, and clean up some of the docs.Bruce Momjian
Fix \do and trigger display for the patch too.
2009-01-06Document that Cygwin does not support OpenSSL.Bruce Momjian
2009-01-06Remove references to pgsql-ports and pgsql-patches mailing lists fromTom Lane
various documentation, since those lists are now dead/deprecated. Point to pgsql-bugs and/or pgsql-hackers as appropriate.
2009-01-06Change a couple of ill-advised uses of INFO elog level to WARNINGs; inTom Lane
particular this allows EmitWarningsOnPlaceholders messages to show up in the postmaster log by default. Update elog.h comment to make it clearer what INFO is for, and fix one example in the SGML docs that was misusing it. Per my gripe of yesterday.
2009-01-06Update SELECT version() to show whether it is a 32 or 64-bit backend binary.Bruce Momjian
2009-01-05Add a --role option to pg_dump, pg_dumpall, and pg_restore. This allowsTom Lane
performing dumps and restores in accordance with a security policy that forbids logging in directly as superuser, but instead specifies that you should log into an admin account and then SET ROLE to the superuser. In passing, clean up some ugly and mostly-broken code for quoting shell arguments in pg_dumpall. Benedek László, with some help from Tom Lane
2009-01-05Update Japanese FAQ.Bruce Momjian
Jun Kuwamura
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