summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2007-04-03Add URL for:Bruce Momjian
o Allow UPDATE tab SET ROW (col, ...) = (SELECT...) < > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00865.php
2007-04-02Add URL for:Bruce Momjian
o Allow commenting of variables in postgresql.conf to restore them to defaults > http://archives.postgresql.org/pgsql-patches/2007-03/msg00180.php
2007-04-02Add URL for:Bruce Momjian
o Allow a warm standby system to also allow read-only statements [pitr] > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00050.php
2007-04-02Add URL for:Bruce Momjian
* Improve speed with indexes For large table adjustments during VACUUM FULL, it is faster to cluster or reindex rather than update the index. Also, index updates can bloat the index. > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00024.php
2007-04-02Add:Bruce Momjian
> o Have timestamp subtraction not call justify_hours()? > > http://archives.postgresql.org/pgsql-sql/2006-10/msg00059.php > < o Add overflow checking to timestamp and interval arithmetic > o Add overflow checking to timestamp and interval arithmetic
2007-04-02Pl/python -> Pl/PythonU:Bruce Momjian
< o Add table function support to pltcl, plpython > o Add table function support to pltcl, plpythonu < o Add PL/Python tracebacks > o Add PL/PythonU tracebacks < o Allow PL/Python to return boolean rather than 1/0 > o Allow PL/PythonU to return boolean rather than 1/0
2007-04-02Add:Bruce Momjian
> * Fix to_date()-related functions to consistently issue errors > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg00915.php >
2007-04-02Add:Bruce Momjian
> > o Allow PL/Python to return boolean rather than 1/0 > > http://archives.postgresql.org/pgsql-patches/2007-01/msg00596.php >
2007-04-02Add item:Bruce Momjian
> > * Consider reducing memory used for shared buffer reference count > > http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php
2007-04-02Add URL for:Bruce Momjian
o Allow RETURN to return row or record functions > o Allow RETURN to return row or record functions > http://archives.postgresql.org/pgsql-patches/2006-08/msg00397.php > http://archives.postgresql.org/pgsql-hackers/2006-09/msg00388.php
2007-04-02Done:Bruce Momjian
< * Support a data type with specific enumerated values (ENUM) < < http://archives.postgresql.org/pgsql-hackers/2006-08/msg00979.php < > * -Support a data type with specific enumerated values (ENUM)
2007-04-02> o Add PQexecf() that allows complex parameter substitutionBruce Momjian
> > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01803.php
2007-04-02Put documentation on XML data type and functions in better positions. AddPeter Eisentraut
some index terms.
2007-04-02Support enum data types. Along the way, use macros for the values ofTom Lane
pg_type.typtype whereever practical. Tom Dunstan, with some kibitzing from Tom Lane.
2007-04-01Mapping schemas and databases to XML and XML Schema.Peter Eisentraut
Refactor and document the remaining mapping code.
2007-03-30Add some instrumentation to the bgwriter, through the stats collector.Magnus Hagander
New view pg_stat_bgwriter, and the functions required to build it.
2007-03-30Update Japanese FAQ.Bruce Momjian
Jun Kuwamura
2007-03-30Update SSL description for when SSL root.crt/server.crt is required;Bruce Momjian
add link to libpq SSL does from server docs. Backpatch to 8.2.X.
2007-03-29Add to:Bruce Momjian
* Reduce storage space for small NUMERICs > http://archives.postgresql.org/pgsql-patches/2007-02/msg00505.php
2007-03-29Add:Bruce Momjian
> * Reduce storage space for small NUMERICs > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg01331.php >
2007-03-29Update:Bruce Momjian
< o Add more logical syntax CLUSTER table USING index; > o Add more logical syntax CLUSTER table USING index;
2007-03-29Update item:Bruce Momjian
o Add more logical syntax CLUSTER table USING index; < o Add more logical syntax CLUSTER table ORDER BY index; > o Add more logical syntax CLUSTER table USING index;
2007-03-29Make ECPG regression tests use native threading instead of pthreads, now thatMagnus Hagander
ecpglib supports it. Change configure (patch from Bruce) and msvc build system to no longer require pthreads on win32, since all parts of postgresql can be thread-safe using the native platform functions.
2007-03-29Teach CLUSTER to skip writing WAL if not needed (ie, not using archiving)Tom Lane
--- Simon. Also, code review and cleanup for the previous COPY-no-WAL patches --- Tom.
2007-03-28Add URL for:Bruce Momjian
* Automatically create rules on views so they are updateable, per SQL99 > http://archives.postgresql.org/pgsql-patches/2006-08/msg00255.php
2007-03-27Remove item due to lack of interest:Bruce Momjian
< * %Add pg_get_acldef(), pg_get_typedefault(), pg_get_attrdef(), < pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef() < < These would be for application use, not for use by pg_dump. <
2007-03-27Add:Bruce Momjian
> > * Allow configuration of backend priorities via the operating system > > Though backend priorities make priority inversion during lock > waits possible, research shows that this is not a huge problem. > http://archives.postgresql.org/pgsql-general/2007-02/msg00493.php
2007-03-27Add documentation for pulling the CVS repository using rsync, andBruce Momjian
mention cvsup last.
2007-03-26Update:Bruce Momjian
* Improve dead row detection during multi-statement transactions usage
2007-03-26Add:Bruce Momjian
> * Increase the number of rows recognized as dead during multi-statement > transactions > > http://archives.postgresql.org/pgsql-patches/2007-03/msg00358.php >
2007-03-26Fix seriously broken markup for libpq-envars cross-references.Tom Lane
2007-03-26Allow non-superuser database owners to create procedural languages.Tom Lane
A DBA is allowed to create a language in his database if it's marked "tmpldbacreate" in pg_pltemplate. The factory default is that this is set for all standard trusted languages, but of course a superuser may adjust the settings. In service of this, add the long-foreseen owner column to pg_language; renaming, dropping, and altering owner of a PL now follow normal ownership rules instead of being superuser-only. Jeremy Drake, with some editorialization by Tom Lane.
2007-03-26Remove assertion that constraint_exclusion risks wrong answers ifTom Lane
table constraints are changed; this is no longer true now that we have a plan invalidation mechanism.
2007-03-25Remove the prohibition on executing cursor commands through SPI_execute.Tom Lane
Vadim had included this restriction in the original design of the SPI code, but I'm darned if I can see a reason for it. I left the macro definition of SPI_ERROR_CURSOR in place, so as not to needlessly break any SPI callers that are checking for it, but that code will never actually be returned anymore.
2007-03-25Add new encoding EUC_JIS_2004 and SHIFT_JIS_2004,Tatsuo Ishii
along with new conversions among EUC_JIS_2004, SHIFT_JIS_2004 and UTF-8. catalog version has been bump up.
2007-03-25Add:Bruce Momjian
> > * Allow BEFORE INSERT triggers on views > > http://archives.postgresql.org/pgsql-general/2007-02/msg01466.php
2007-03-24Add:Bruce Momjian
> o Add more logical syntax CLUSTER table ORDER BY index; > support current syntax for backward compatibility
2007-03-24Support for installing NLS files, and update support to use gettextMagnus Hagander
from gnuwin32.
2007-03-24Document that LDAP URLs should be double-quoted in pg_hba.conf becauseBruce Momjian
commas are often present in the URL. Backpatch to 8.2.X.
2007-03-23Support for running contribcheck on msvcMagnus Hagander
2007-03-22Add:Bruce Momjian
> > * Fix cases where invalid byte encodings are accepted by the database, > but throw an error on SELECT > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00767.php
2007-03-22Add to TODO:Bruce Momjian
CLUSTER: > > o %Add VERBOSE option to report tables as they are processed, > like VACUUM VERBOSE
2007-03-22Remove tabs in SGML files.Bruce Momjian
2007-03-22Remove tabs from SGML file.Bruce Momjian
2007-03-21Add:Bruce Momjian
< < > o During index creation, pre-sort the tuples to improve build speed > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01199.php >
2007-03-21Remove TODO item, not wanted:Bruce Momjian
< * Add NUMERIC division operator that doesn't round? < < Currently NUMERIC _rounds_ the result to the specified precision. < This means division can return a result that multiplied by the < divisor is greater than the dividend, e.g. this returns a value > 10: < < SELECT (10::numeric(2,0) / 6::numeric(2,0))::numeric(2,0) * 6; < < The positive modulus result returned by NUMERICs might be considered < inaccurate, in one sense. <
2007-03-21Add documentation about vcregress.Magnus Hagander
2007-03-21Add URL for:Bruce Momjian
* Add locale-aware MONEY type, and support multiple currencies http://archives.postgresql.org/pgsql-hackers/2007-03/msg01181.php
2007-03-21Add URL for:Bruce Momjian
* Allow accurate statistics to be collected on indexes with more than one column or expression indexes, perhaps using per-index statistics > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01131.php
2007-03-20In FAQ, reference upgrade info via URL.Bruce Momjian
generated by cgit v1.2.3 (git 2.46.0) at 2025-10-02 12:55:16 +0000