aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Add URL for:Bruce Momjian2007-04-02
| | | | | | o Allow commenting of variables in postgresql.conf to restore them to defaults > http://archives.postgresql.org/pgsql-patches/2007-03/msg00180.php
* Add URL for:Bruce Momjian2007-04-02
| | | | | | | o Allow a warm standby system to also allow read-only statements [pitr] > http://archives.postgresql.org/pgsql-hackers/2007-03/msg00050.php
* Add URL for:Bruce Momjian2007-04-02
| | | | | | | | | | | * 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
* Add:Bruce Momjian2007-04-02
| | | | | | | | | > 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
* Allow NOTIFY/LISTEN/UNLISTEN to only take relation names, notBruce Momjian2007-04-02
| | | | | schema.relation, because the notify code only honors the relation name. schema.relation will now generate a syntax error.
* Check length of enum literals on definition and input to make sure they will ↵Andrew Dunstan2007-04-02
| | | | fit in a name field and not cause syscache errors.
* Pl/python -> Pl/PythonU:Bruce Momjian2007-04-02
| | | | | | | | | < 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
* Add:Bruce Momjian2007-04-02
| | | | | | | > * Fix to_date()-related functions to consistently issue errors > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg00915.php >
* Add:Bruce Momjian2007-04-02
| | | | | | | | > > o Allow PL/Python to return boolean rather than 1/0 > > http://archives.postgresql.org/pgsql-patches/2007-01/msg00596.php >
* Add item:Bruce Momjian2007-04-02
| | | | | | | > > * Consider reducing memory used for shared buffer reference count > > http://archives.postgresql.org/pgsql-hackers/2007-01/msg00752.php
* Add URL for:Bruce Momjian2007-04-02
| | | | | | | | 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
* Fix check_sql_fn_retval to allow the case where a SQL function declared toTom Lane2007-04-02
| | | | | | | | return void ends with a SELECT, if that SELECT has a single result that is also of type void. Without this, it's hard to write a void function that calls another void function. Per gripe from Peter. Back-patch as far as 8.0.
* Done:Bruce Momjian2007-04-02
| | | | | | | | < * 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)
* > o Add PQexecf() that allows complex parameter substitutionBruce Momjian2007-04-02
| | | | | > > http://archives.postgresql.org/pgsql-hackers/2007-03/msg01803.php
* Put documentation on XML data type and functions in better positions. AddPeter Eisentraut2007-04-02
| | | | some index terms.
* xcopy can only deal with forward-slashed paths when it's quoted - neededMagnus Hagander2007-04-02
| | | | | for "vcregress check" to work. Per report from Dave Page.
* Fix caching of unsuccessful initialization of parser or configuration.Teodor Sigaev2007-04-02
| | | | Per report from Listmail <lists@peufeu.com>
* Support enum data types. Along the way, use macros for the values ofTom Lane2007-04-02
| | | | | pg_type.typtype whereever practical. Tom Dunstan, with some kibitzing from Tom Lane.
* Update catversion for new XML mapping functionsPeter Eisentraut2007-04-01
|
* Update SQL conformance for SQL to XML mappingsPeter Eisentraut2007-04-01
|
* Mapping schemas and databases to XML and XML Schema.Peter Eisentraut2007-04-01
| | | | Refactor and document the remaining mapping code.
* Complete cleaningPeter Eisentraut2007-04-01
|
* Add some instrumentation to the bgwriter, through the stats collector.Magnus Hagander2007-03-30
| | | | New view pg_stat_bgwriter, and the functions required to build it.
* Update Japanese FAQ.Bruce Momjian2007-03-30
| | | | Jun Kuwamura
* Update SSL description for when SSL root.crt/server.crt is required;Bruce Momjian2007-03-30
| | | | | | add link to libpq SSL does from server docs. Backpatch to 8.2.X.
* Fix oversight in coding of _bt_start_vacuum: we can't assume that the LWLockTom Lane2007-03-30
| | | | | | | will be released by transaction abort before _bt_end_vacuum gets called. If either of these "can't happen" errors actually happened, we'd freeze up trying to acquire an already-held lock. Latest word is that this does not explain Martin Pitt's trouble report, but it still looks like a bug.
* pg_char_to_encoding() was redundant in initdb becauseBruce Momjian2007-03-29
| | | | | | | pg_valid_server_encoding() returns the same result if the encoding is valid. ITAGAKI Takahiro
* Add to:Bruce Momjian2007-03-29
| | | | | * Reduce storage space for small NUMERICs > http://archives.postgresql.org/pgsql-patches/2007-02/msg00505.php
* Add:Bruce Momjian2007-03-29
| | | | | | | > * Reduce storage space for small NUMERICs > > http://archives.postgresql.org/pgsql-hackers/2007-02/msg01331.php >
* Install include filesMagnus Hagander2007-03-29
|
* Update:Bruce Momjian2007-03-29
| | | | | < o Add more logical syntax CLUSTER table USING index; > o Add more logical syntax CLUSTER table USING index;
* Update item:Bruce Momjian2007-03-29
| | | | | | 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;
* exec_parse_message neglected to copy parameter type array into theTom Lane2007-03-29
| | | | | required memory context when handling client-specified parameter types for an unnamed statement. Per report from Kris Jurka.
* Make ECPG regression tests use native threading instead of pthreads, now thatMagnus Hagander2007-03-29
| | | | | | | 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.
* - Added patch by Magnus Hagander <magnus@hagander.net> to use nativeMichael Meskes2007-03-29
| | | | | win32 threads. - Fixed regression tests to run threading tests.
* Teach CLUSTER to skip writing WAL if not needed (ie, not using archiving)Tom Lane2007-03-29
| | | | | --- Simon. Also, code review and cleanup for the previous COPY-no-WAL patches --- Tom.
* Code cleanup for the new regexp UDFs: we can hardcode the OID and someNeil Conway2007-03-28
| | | | | properties of the "text" type, and then simplify the code accordingly. Patch from Jeremy Drake.
* Replace 4-clause licensed blf.[ch] with blowfish implementationNeil Conway2007-03-28
| | | | from PuTTY with is under minimal BSD/MIT license. Marko Kreen.
* Add the "recheck" logic to autovacuum worker code. The worker first buildsAlvaro Herrera2007-03-28
| | | | | | | | | | | its table list and then rechecks pgstat before vacuuming each table to verify that no one has vacuumed the table in the meantime. In the current autovacuum world this only means that a worker will not vacuum a table that a user has vacuumed manually after the worker started. When support for multiple autovacuum workers is introduced, this will reduce the probability of simultaneous workers on the same database doing redundant work.
* Fix compiler warnings in ereport messages on mingw.Magnus Hagander2007-03-28
| | | | ITAGAKI Takahiro
* Add URL for:Bruce Momjian2007-03-28
| | | | | * Automatically create rules on views so they are updateable, per SQL99 > http://archives.postgresql.org/pgsql-patches/2006-08/msg00255.php
* Fix uninitialized-variable bug.Tom Lane2007-03-28
|
* Fix array coercion expressions to ensure that the correct volatility isTom Lane2007-03-27
| | | | | | | | | seen by code inspecting the expression. The best way to do this seems to be to drop the original representation as a function invocation, and instead make a special expression node type that represents applying the element-type coercion function to each array element. In this way the element function is exposed and will be checked for volatility. Per report from Guillaume Smet.
* Install import libraries used to link to libpq, ecpg and the backend.Magnus Hagander2007-03-27
|
* Cosmetic changes: rename some struct fields, and move the fetching of pgstatAlvaro Herrera2007-03-27
| | | | | table entries to a separate routine. Don't pass the pgstat database entry to do_autovacuum; rather, have it fetch it by itself.
* Remove item due to lack of interest:Bruce Momjian2007-03-27
| | | | | | | | < * %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. <
* Add:Bruce Momjian2007-03-27
| | | | | | | | | > > * 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
* Fix typo in Makefile.Bruce Momjian2007-03-27
| | | | Marko Kreen
* Fix typo, ensable -> enable, per Steve Gieseking.Tom Lane2007-03-27
|
* Add documentation for pulling the CVS repository using rsync, andBruce Momjian2007-03-27
| | | | mention cvsup last.