aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Add COPY views patch URL:Bruce Momjian2006-06-14
| | | | > http://archives.postgresql.org/pgsql-patches/2005-09/msg00148.php
* Add:Bruce Momjian2006-06-14
| | | | | | | > > o Add API for 64-bit large object access > > http://archives.postgresql.org/pgsql-hackers/2005-09/msg00781.php
* Keep TODO.detail until item is done:Bruce Momjian2006-06-14
| | | | | < o %Allow pg_dump to use multiple -t and -n switches > o %Allow pg_dump to use multiple -t and -n switches [pg_dump]
* Add URL, remove TODO.detail:Bruce Momjian2006-06-14
| | | | | | | | < o %Allow pg_dump to use multiple -t and -n switches [pg_dump] > o %Allow pg_dump to use multiple -t and -n switches > > http://archives.postgresql.org/pgsql-patches/2006-01/msg00190.php >
* Add locale/encoding references:Bruce Momjian2006-06-14
| | | | | | < Right now only one encoding is allowed per database. > Right now only one encoding is allowed per database. [locale] > * Add CREATE COLLATE? [locale]
* Update link to TODO.detail:Bruce Momjian2006-06-14
| | | | | < o Check WSACancelBlockingCall() for interrupts (win32intr) > o Check WSACancelBlockingCall() for interrupts [win32intr]
* Add:Bruce Momjian2006-06-14
| | | | | | | | > o Fix problem when cascading referential triggers make changes on > cascaded tables, seeing the tables in an intermediate state > > http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php > http://archives.postgresql.org/pgsql-hackers/2005-09/msg00174.php
* Added:Bruce Momjian2006-06-14
| | | | | | | > > * Add URL to more complete multi-byte regression tests > > http://archives.postgresql.org/pgsql-hackers/2005-07/msg00272.php
* Add entry:Bruce Momjian2006-06-14
| | | | | | > * Allow user-defined types to accept 'typmod' parameters > http://archives.postgresql.org/pgsql-hackers/2005-08/msg01142.php > http://archives.postgresql.org/pgsql-hackers/2005-09/msg00012.php
* Remove:Bruce Momjian2006-06-13
| | | | < o %Add CSV output format
* Add BY clause to PL/PgSQL FOR loop, to control the iteration increment.Bruce Momjian2006-06-12
| | | | Jaime Casanova
* Add URL for bitmap AM:Bruce Momjian2006-06-12
| | | | > http://archives.postgresql.org/pgsql-patches/2005-07/msg00512.php
* Remove pg_dump wording:Bruce Momjian2006-06-10
| | | | | | < pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef(), and < make use of them in pg_dump > pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef()
* Add:Bruce Momjian2006-06-10
| | | | | | < pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef() > pg_get_tabledef(), pg_get_domaindef(), pg_get_functiondef(), and > make use of them in pg_dump
* Cleanups:Bruce Momjian2006-06-09
| | | | | | | | | | | | | | < * Allow a database in tablespace t1 with tables created in > o Allow a database in tablespace t1 with tables created in 125c125 < * Allow reporting of which objects are in which tablespaces > o Allow reporting of which objects are in which tablespaces 593c593 < * Allow GRANT/REVOKE permissions to be inherited by objects based on > o Allow GRANT/REVOKE permissions to be inherited by objects based on 596c596 < * Allow SERIAL sequences to inherit permissions from the base table? > o Allow SERIAL sequences to inherit permissions from the base table?
* Cleanup:Bruce Momjian2006-06-09
| | | | | < * -%Allow pooled connections to list all prepared statements > * -Allow pooled connections to list all prepared statements
* Add URL.Bruce Momjian2006-06-09
| | | | | | < the insert. > the insert. > http://archives.postgresql.org/pgsql-patches/2005-07/msg00568.php
* Update:Bruce Momjian2006-06-09
| | | | | < * Add SQL99 WITH RECURSIVE (hierarchical) queries to SELECT > * Add SQL:2003 WITH RECURSIVE (hierarchical) queries to SELECT
* Remove:Bruce Momjian2006-06-09
| | | | < * Rename some /contrib modules from pg* to pg_*
* Add URL.Bruce Momjian2006-06-08
| | | | | | > > http://archives.postgresql.org/pgsql-patches/2006-06/msg00096.php >
* Use simple URL's rather than text and a URL:Bruce Momjian2006-06-08
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | < recovery. See http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php. > recovery. > http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php < Right now only one encoding is allowed per database. For a partial < patch, see http://archives.postgresql.org/pgsql-hackers/2005-03/msg00932.php. > Right now only one encoding is allowed per database. > http://archives.postgresql.org/pgsql-hackers/2005-03/msg00932.php 459c460 < notify the protocol when a RESET CONNECTION command is used. See > notify the protocol when a RESET CONNECTION command is used. 461d461 < for a partial implementation. 515c515 < See http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php. > http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php 535c535 < See http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php. > http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php 821c821 < See http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php. > http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php 877c877 < Details at http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php. > http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php < See partially completed patch and additional work required at < http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php. > http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php 1297c1296 < See http://archives.postgresql.org/pgsql-patches/2006-05/msg00040.php. > http://archives.postgresql.org/pgsql-patches/2006-05/msg00040.php 1311c1310,1311 < o Improve signal handling, > o Improve signal handling > 1312a1313 >
* Add URL.Bruce Momjian2006-06-08
| | | | | | | | < * Support triggers on columns (Greg Sabino Mullane) > * Support triggers on columns > > See http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php. >
* Spelling fix.Bruce Momjian2006-06-08
| | | | Robert Treat
* Done:Bruce Momjian2006-06-08
| | | | > * -Allow server logs to be remotely read and removed using SQL commands
* Add URL for ALTER CONSTRAINT RENAME.Bruce Momjian2006-06-08
| | | | | | > > See http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php. >
* Add URL.Bruce Momjian2006-06-08
| | | | | < recovery. > recovery. See http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php.
* Add URL:Bruce Momjian2006-06-08
| | | | | | < Right now only one encoding is allowed per database. > Right now only one encoding is allowed per database. For a partial > patch, see http://archives.postgresql.org/pgsql-hackers/2005-03/msg00932.php.
* Update wording:Bruce Momjian2006-06-08
| | | | | < * Add SQL99 WITH RECURSIVE to SELECT > * Add SQL99 WITH RECURSIVE (hierarchical) queries to SELECT
* Add entry:Bruce Momjian2006-06-08
| | | | | | | > * Consider allowing control of upper/lower case folding of unquoted > identifiers > > Details at http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php.
* Done:Bruce Momjian2006-06-07
| | | | | < o Allow timezone names in SQL strings, '2006-05-24 21:11 > o -Allow timezone names in SQL strings, '2006-05-24 21:11
* Spelling fix.Bruce Momjian2006-06-07
| | | | Robert Treat
* Mention GPL /contrib modules:Bruce Momjian2006-06-07
| | | | | | | > > Particularly, move GPL-licensed /contrib/userlock and > /contrib/dbmirror/clean_pending.pl. >
* Make the planner estimate costs for nestloop inner indexscans on the basisTom Lane2006-06-06
| | | | | | | | | | | | | | | | | | | | | that the Mackert-Lohmann formula applies across all the repetitions of the nestloop, not just each scan independently. We use the M-L formula to estimate the number of pages fetched from the index as well as from the table; that isn't what it was designed for, but it seems reasonably applicable anyway. This makes large numbers of repetitions look much cheaper than before, which accords with many reports we've received of overestimation of the cost of a nestloop. Also, change the index access cost model to charge random_page_cost per index leaf page touched, while explicitly not counting anything for access to metapage or upper tree pages. This may all need tweaking after we get some field experience, but in simple tests it seems to be giving saner results than before. The main thing is to get the infrastructure in place to let cost_index() and amcostestimate functions take repeated scans into account at all. Per my recent proposal. Note: this patch changes pg_proc.h, but I did not force initdb because the changes are basically cosmetic --- the system does not look into pg_proc to decide how to call an index amcostestimate function, and there's no way to call such a function from SQL at all.
* Add URL to RESET CONNECTION:Bruce Momjian2006-06-06
| | | | | | | < notify the protocol when a RESET CONNECTION command is used. > notify the protocol when a RESET CONNECTION command is used. See > http://archives.postgresql.org/pgsql-patches/2006-04/msg00192.php > for a partial implementation.
* Done:Bruce Momjian2006-06-06
| | | | | < * %Make postmater and postgres options distinct so the postmaster -o > * -Make postmater and postgres options distinct so the postmaster -o
* Increase the default value of cpu_index_tuple_cost from 0.001 to 0.005.Tom Lane2006-06-05
| | | | | | This shouldn't affect simple indexscans much, while for bitmap scans that are touching a lot of index rows, this seems to bring the estimates more in line with reality. Per recent discussion.
* Add a GUC parameter seq_page_cost, and use that everywhere we formerlyTom Lane2006-06-05
| | | | | | | | assumed that a sequential page fetch has cost 1.0. This patch doesn't in itself change the system's behavior at all, but it opens the door to people adopting other units of measurement for EXPLAIN costs. Also, if we ever decide it's worth inventing per-tablespace access cost settings, this change provides a workable intellectual framework for that.
* Update:Bruce Momjian2006-06-04
| | | | | | < * %Remove behavior of postmaster -o > * %Make postmater and postgres options distinct so the postmaster -o > option is no longer needed
* Update:Bruce Momjian2006-06-04
| | | | | | | | < o Allow COPY to output from views > o Allow COPY to output from SELECT 570c570 < Another idea would be to allow actual SELECT statements in a COPY. > COPY should also be able to output views.
* Update GUI FAQ.Bruce Momjian2006-06-04
| | | | Robert Treat
* Update GUI tools URL.Bruce Momjian2006-06-04
| | | | Robert Treat
* Record location of partial patch :Bruce Momjian2006-06-03
| | | | | | | | > * Allow WAL information to recover corrupted pg_controldata > > See partially completed patch and additional work required at > http://archives.postgresql.org/pgsql-patches/2006-06/msg00025.php. >
* Mention pg_encoding_to_char in entry for pg_database.encoding.Tom Lane2006-06-03
| | | | Per Larry Rosenman.
* Patch reverted, not done:Bruce Momjian2006-06-03
| | | | > * Allow WAL information to recover corrupted pg_controldata
* Remove pg_resetxlog -r flag, feature has problems referenced here:Bruce Momjian2006-06-03
| | | | http://archives.postgresql.org/pgsql-hackers/2006-05/msg00002.php
* Fix example of how to escape data in psql backslash commands.Tom Lane2006-05-31
|
* Make PG_MODULE_MAGIC required in shared libraries that are loaded intoTom Lane2006-05-31
| | | | | the server. Per discussion, there seems no point in a waiting period before making this required.
* Recommend '' for literal ', rather than \', in psql documentation.Bruce Momjian2006-05-31
|
* Support '' for literal ' in psql single-quote strings, documentation update.Bruce Momjian2006-05-31
|
* Code review for magic-block patch. Remove separate header file pgmagic.h,Tom Lane2006-05-30
| | | | | | | | | | as this seems only likely to create headaches for module developers. Put the macro in the pre-existing fmgr.h file instead. Avoid being too cute about how many fields we can cram into a word, and avoid trying to fetch from a library we've already unlinked. Along the way, it occurred to me that the magic block really ought to be 'const' so it can be stored in the program text area. Do the same for the existing data blocks for PG_FUNCTION_INFO_V1 functions.
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-10 11:48:02 +0000