summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2006-06-08Use simple URL's rather than text and a URL:Bruce Momjian
< 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 >
2006-06-08Add URL.Bruce Momjian
< * Support triggers on columns (Greg Sabino Mullane) > * Support triggers on columns > > See http://archives.postgresql.org/pgsql-patches/2005-07/msg00107.php. >
2006-06-08Spelling fix.Bruce Momjian
Robert Treat
2006-06-08Done:Bruce Momjian
> * -Allow server logs to be remotely read and removed using SQL commands
2006-06-08Add URL for ALTER CONSTRAINT RENAME.Bruce Momjian
> > See http://archives.postgresql.org/pgsql-patches/2006-02/msg00168.php. >
2006-06-08Add URL.Bruce Momjian
< recovery. > recovery. See http://archives.postgresql.org/pgsql-patches/2005-04/msg00121.php.
2006-06-08Add URL:Bruce Momjian
< 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.
2006-06-08Update wording:Bruce Momjian
< * Add SQL99 WITH RECURSIVE to SELECT > * Add SQL99 WITH RECURSIVE (hierarchical) queries to SELECT
2006-06-08Add entry:Bruce Momjian
> * Consider allowing control of upper/lower case folding of unquoted > identifiers > > Details at http://archives.postgresql.org/pgsql-hackers/2004-04/msg00818.php.
2006-06-07Done:Bruce Momjian
< o Allow timezone names in SQL strings, '2006-05-24 21:11 > o -Allow timezone names in SQL strings, '2006-05-24 21:11
2006-06-07Spelling fix.Bruce Momjian
Robert Treat
2006-06-07Mention GPL /contrib modules:Bruce Momjian
> > Particularly, move GPL-licensed /contrib/userlock and > /contrib/dbmirror/clean_pending.pl. >
2006-06-06Make the planner estimate costs for nestloop inner indexscans on the basisTom Lane
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.
2006-06-06Add URL to RESET CONNECTION:Bruce Momjian
< 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.
2006-06-06Done:Bruce Momjian
< * %Make postmater and postgres options distinct so the postmaster -o > * -Make postmater and postgres options distinct so the postmaster -o
2006-06-05Increase the default value of cpu_index_tuple_cost from 0.001 to 0.005.Tom Lane
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.
2006-06-05Add a GUC parameter seq_page_cost, and use that everywhere we formerlyTom Lane
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.
2006-06-04Update:Bruce Momjian
< * %Remove behavior of postmaster -o > * %Make postmater and postgres options distinct so the postmaster -o > option is no longer needed
2006-06-04Update:Bruce Momjian
< 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.
2006-06-04Update GUI FAQ.Bruce Momjian
Robert Treat
2006-06-04Update GUI tools URL.Bruce Momjian
Robert Treat
2006-06-03Record location of partial patch :Bruce Momjian
> * 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. >
2006-06-03Mention pg_encoding_to_char in entry for pg_database.encoding.Tom Lane
Per Larry Rosenman.
2006-06-03Patch reverted, not done:Bruce Momjian
> * Allow WAL information to recover corrupted pg_controldata
2006-06-03Remove pg_resetxlog -r flag, feature has problems referenced here:Bruce Momjian
http://archives.postgresql.org/pgsql-hackers/2006-05/msg00002.php
2006-05-31Fix example of how to escape data in psql backslash commands.Tom Lane
2006-05-31Make PG_MODULE_MAGIC required in shared libraries that are loaded intoTom Lane
the server. Per discussion, there seems no point in a waiting period before making this required.
2006-05-31Recommend '' for literal ', rather than \', in psql documentation.Bruce Momjian
2006-05-31Support '' for literal ' in psql single-quote strings, documentation update.Bruce Momjian
2006-05-30Code review for magic-block patch. Remove separate header file pgmagic.h,Tom Lane
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.
2006-05-30Add pgmagic header block to store compile-time constants:Bruce Momjian
It now only checks four things: Major version number (7.4 or 8.1 for example) NAMEDATALEN FUNC_MAX_ARGS INDEX_MAX_KEYS The three constants were chosen because: 1. We document them in the config page in the docs 2. We mark them as changable in pg_config_manual.h 3. Changing any of these will break some of the more popular modules: FUNC_MAX_ARGS changes fmgr interface, every module uses this NAMEDATALEN changes syscache interface, every PL as well as tsearch uses this INDEX_MAX_KEYS breaks tsearch and anything using GiST. Martijn van Oosterhout
2006-05-30Revert patch, needs more work:Bruce Momjian
--------------------------------------------------------------------------- Add dynamic record inspection to PL/PgSQL, useful for generic triggers: tval2 := r.(cname); or columns := r.(*); Titus von Boxberg
2006-05-30Add dynamic record inspection to PL/PgSQL, useful for generic triggers:Bruce Momjian
tval2 := r.(cname); or columns := r.(*); Titus von Boxberg
2006-05-30Back out patch, wrong previous commit message.Bruce Momjian
2006-05-30Add regexp_replace() to string functions section.Bruce Momjian
Joachim Wieland
2006-05-30Update PL documentation:Bruce Momjian
An article at WebProNews quoted from the PG docs as to the merits of stored procedures. I have added a bit more material on their merits, as well as making a few changes to improve the introductions to PL/Perl and PL/Tcl. Chris Browne
2006-05-30Update Japanese FAQ.Bruce Momjian
J.Kuwamura
2006-05-30Add item:Bruce Momjian
> * Consider GnuTLS if OpenSSL license becomes a problem > > See http://archives.postgresql.org/pgsql-patches/2006-05/msg00040.php.
2006-05-29Add:Bruce Momjian
> o Allow timezone names in SQL strings, '2006-05-24 21:11 > Americas/New_York'::timestamptz
2006-05-29Make plperl's $_TD trigger data a global rather than a lexical variable,Andrew Dunstan
with a fresh local value for each invocation, to avoid unexpected sharing violations. Per recent -hackers discussion.
2006-05-28TG_table_name and TG_table_schema for plpgsql, plus docs and regression.Andrew Dunstan
2006-05-28Remove traces of otherwise unused RELKIND_SPECIAL symbol. Leave the psql bitsAlvaro Herrera
in place though, so that it plays nicely with older servers. Per discussion.
2006-05-27TG_table_name and TG_table_schema for pl/tcl, plus regression test and docs.Andrew Dunstan
2006-05-26Support binary COPY through psql. Also improve detection of write errorsTom Lane
during COPY OUT. Andreas Pflug, some editorialization by moi.
2006-05-26Add table_name and table_schema to plpython trigger data, plus docs and ↵Andrew Dunstan
regression test.
2006-05-26Add table_name and table_schema to plperl trigger data. relname isAndrew Dunstan
kept but now deprecated. Patch from Adam Sjøgren. Add regression test to show plperl trigger data (Andrew). TBD: apply similar changes to plpgsql, plpython and pltcl.
2006-05-24Remove pg_attribute detail, add URLBruce Momjian
< pg_attribute.attislocal has to be set to 'false' for ADD, and < pg_attribute.attinhcount adjusted appropriately > See http://archives.postgresql.org/pgsql-hackers/2006-05/msg00988.php.
2006-05-24* Add support NULL to GiST.Teodor Sigaev
* some refactoring and simplify code int gistutil.c and gist.c * now in some cases it can be called used-defined picksplit method for non-first column in index, but here is a place to do more. * small fix of docs related to support NULL.
2006-05-23Add PQisthreadsafe() to libpq, to allow library applications to queryBruce Momjian
the thread-safety status of the library.
2006-05-23Update text:Bruce Momjian
> This allows tables to be added/removed from an inheritance > hierarchy. This is particularly useful for table partitioning.
generated by cgit v1.2.3 (git 2.46.0) at 2025-08-30 13:38:57 +0000