aboutsummaryrefslogtreecommitdiff
Commit message (Collapse)AuthorAge
* Remove the -P options of oid2name and pgbench, as they are securityTom Lane2007-12-11
| | | | | | | hazards. Instead teach these programs to prompt for a password when necessary, just like all our other programs. I did not bother to invent -W switches for them, since the return on investment seems so low.
* Make vacuumlo prompt for password when needed, thus making its -WTom Lane2007-12-11
| | | | | | switch optional, as is the case for every other one of our programs. I had already documented its -W as being optional, so this is bringing the code into line with the docs ...
* Remove Stefan Kaltenbrunner mention from full text release note item.Bruce Momjian2007-12-10
|
* Add release note introduction.Bruce Momjian2007-12-10
|
* Mention Stefan Kaltenbrunner as contributor for text search because ofBruce Momjian2007-12-10
| | | | psql work.
* Wording improvement for write-cache disabling instructions.Bruce Momjian2007-12-10
|
* Write cache doc cleanupsBruce Momjian2007-12-10
| | | | Greg Smith
* Document how to turn off disk write cache on popular operating systems.Bruce Momjian2007-12-10
|
* Make an editorial pass over the newly SGML-ified contrib documentation.Tom Lane2007-12-10
| | | | | | Fix lots of bad markup, bad English, bad explanations. Second round of commits. pgcrypto and pgstandby still to go...
* Change the "distributed checkpoint" release note item to Greg Smith's proposedAlvaro Herrera2007-12-10
| | | | wording.
* Update Brazilian FAQ.Bruce Momjian2007-12-10
| | | | Euler Taveira de Oliveira
* FAQ wording and markup fix.Bruce Momjian2007-12-10
| | | | Euler Taveira de Oliveira
* Fix attribution for Rime of the Ancient Mariner (obviously it's beenTom Lane2007-12-10
| | | | too long since freshman English :-()
* The E. J. Pratt verse used as a tsearch test case is unfortunately stillTom Lane2007-12-09
| | | | | under copyright in the US and many other places. Substitute a little something from a poet who's more safely dead. Per gripe from Bjorn Munch.
* Fix bogus prompt for password in -u case. Per gripe from Robert Treat.Tom Lane2007-12-09
|
* Fix up the PQconnectionUsedPassword mess: create a separateTom Lane2007-12-09
| | | | | | | | PQconnectionNeedsPassword function that tells the right thing for whether to prompt for a password, and improve PQconnectionUsedPassword so that it checks whether the password used by the connection was actually supplied as a connection argument, instead of coming from environment or a password file. Per bug report from Mark Cave-Ayland and subsequent discussion.
* Fix completely-bogus volatility markings on pg_trgm functions.Tom Lane2007-12-09
|
* Fix mergejoin cost estimation so that we consider the statistical ranges ofTom Lane2007-12-08
| | | | | | | | | | the two join variables at both ends: not only trailing rows that need not be scanned because there cannot be a match on the other side, but initial rows that will be scanned without possibly having a match. This allows a more realistic estimate of startup cost to be made, per recent pgsql-performance discussion. In passing, fix a couple of bugs that had crept into mergejoinscansel: it was not quite up to speed for the task of estimating descending-order scans, which is a new requirement in 8.3.
* In the release notes, mention that the "Overview" items are listed inBruce Momjian2007-12-08
| | | | the sections below in more detail.
* In release notes, mention "most" updates are improved with HOT.Bruce Momjian2007-12-07
|
* Remove completed 8.3 TODO items:Bruce Momjian2007-12-07
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | < o -Allow commenting of variables in postgresql.conf to restore them < to defaults < o -Add a GUC variable to control the tablespace for temporary objects < and sort files < Monitoring < ========== < < * -Allow server log information to be output as CSV format < * -Add ability to monitor the use of temporary sort files < * -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 < http://archives.postgresql.org/pgsql-hackers/2006-08/msg00149.php < < * -Add Globally/Universally Unique Identifier (GUID/UUID) < < http://archives.postgresql.org/pgsql-patches/2006-09/msg00209.php < http://archives.postgresql.org/pgsql-general/2007-01/msg00853.php < < * -Support a data type with specific enumerated values (ENUM) < o -Add support for arrays of complex types < o -Make 64-bit version of the MONEY data type < * -Add ISO day of week format 'ID' to to_char() where Monday = 1 < * -Add a field 'isoyear' to extract(), based on the ISO week < * -Add RESET SESSION command to reset all session state < o -Make CLUSTER preserve recently-dead tuples per MVCC requirements < o -Add more logical syntax CLUSTER table USING index; < support current syntax for backward compatibility < o -Allow UPDATE/DELETE WHERE CURRENT OF cursor < o -Add support for MOVE cursors < o -Allow PL/PythonU to return boolean rather than 1/0 < o -Allow psql \pset boolean variables to set to fixed values, rather < than toggle < o -Add -f to pg_dumpall < Dependency Checking < =================== < < * -Flush cached query plans when the dependent objects change or < when new ANALYZE statistics are available < * -Track dependencies in function bodies and recompile/invalidate < * -Invalidate prepared queries, like INSERT, when the table definition < is altered < < * -Allow use of indexes to search for NULLs < * -Allow the creation of indexes with mixed ascending/descending < specifiers < * -Reduce checkpoint performance degredation by forcing data to disk < more evenly < * -Allow sequential scans to take advantage of other concurrent < sequential scans, also called "Synchronised Scanning" < * -Consider shrinking expired tuples to just their headers < * -Allow heap reuse of UPDATEd rows if no indexed columns are changed, < and old and new versions are on the same heap page < * -Reduce XID consumption of read-only queries < o -Turn on by default < o -Allow multiple vacuums so large tables do not starve small < tables < * -Allow the pg_xlog directory location to be specified during initdb < with a symlink back to the /data location < * -Allow buffered WAL writes and fsync < * -Allow ORDER BY ... LIMIT # to select high/low value without sort or < index using a sequential scan for highest/lowest values < * -Merge xmin/xmax/cmin/cmax back into three header fields < o -Support a smaller header for short variable-length fields < * -Move NAMEDATALEN from postgres_ext.h to pg_config_manual.h < * -Fix problem with excessive logging during SSL disconnection < < http://archives.postgresql.org/pgsql-bugs/2006-12/msg00122.php < http://archives.postgresql.org/pgsql-bugs/2007-05/msg00065.php < < o -Add long file support for binary pg_dump output
* Update HOT description to make index column changes clearer.Bruce Momjian2007-12-07
|
* Change documentation, change "distributed" checkpoints to "smoothed"Bruce Momjian2007-12-07
| | | | checkpoints.
* Clean up a couple of problems in crosstab_hash's use of a hash table.Tom Lane2007-12-07
| | | | | | | | | | | | The original coding leaked memory (at least 8K per crosstab_hash call) because it allowed the hash table to be allocated as a child of TopMemoryContext and then never freed it. Fix that by putting the hash table under per_query_ctx, instead. Also get rid of use of a static variable to point to the hash table. Aside from being ugly, that would actively do the wrong thing in the case of re-entrant calls to crosstab_hash, which are at least theoretically possible since it was expecting the static variable to stay valid across a SPI_execute call.
* Realign the running text in this file to 79 characters wide. Some otherPeter Eisentraut2007-12-07
| | | | copy-editing.
* Fix typo in pg_standby docs. Arul Shaji.Neil Conway2007-12-07
|
* Add missing table entry for lastval(), per Jeff Davis.Tom Lane2007-12-06
|
* Disable asserts by default on msvc build (to make it the sameMagnus Hagander2007-12-06
| | | | as in unix)
* Change wording of logged message when cancelling an autovacuum task, usingAlvaro Herrera2007-12-06
| | | | | american speling (unlike this commit message). Per complaint from Mike C. on bug #3790 and subsequent discussion.
* Make an editorial pass over the newly SGML-ified contrib documentation.Tom Lane2007-12-06
| | | | | | Fix lots of bad markup, bad English, bad explanations. This commit covers only about half the contrib modules, but I grow weary...
* Remove unused, occasionally confusing graphics building support.Peter Eisentraut2007-12-05
|
* Correct misattribution of earthdistance module --- according to itsTom Lane2007-12-04
| | | | | old README file, Bruno Wolff did the bulk of the work, but for some reason only Hal Snyder was credited here.
* Don't send an empty SSPI negotiation packet at the end of the negotiation.Magnus Hagander2007-12-04
| | | | Fixes bug #3750
* Entity-ify a passel of & < > characters. Per gripe from Devrim.Tom Lane2007-12-03
|
* Fix build_minmax_path() to cope if an IS NULL clause turns up in theTom Lane2007-12-03
| | | | | | indexable-clauses list for a btree index. Formerly it just Asserted that all such clauses were opclauses, but that's no longer true in 8.3. Per bug #3796 from Matthias Schoeneich.
* Remove contrib/spi/preprocessor, which has been uninteresting everTom Lane2007-12-03
| | | | | | since we supported standard FOREIGN KEY constraint syntax. It was harmless enough just sitting there, but the prospect of having to document it is surely more work than it's worth.
* Default to integer timestamps being off until 8.4, to correspondMagnus Hagander2007-12-03
| | | | to the settings used for other platforms.
* Don't try to install README.spiMagnus Hagander2007-12-03
| | | | Hannes Eder
* Add missing documentation for SSPI packets.Magnus Hagander2007-12-03
|
* Improve partitioning example, per Itagaki Takahiro.Tom Lane2007-12-03
|
* Remove obsoleted README files.Tom Lane2007-12-03
|
* Add SGML documentation for contrib/spi and contrib/test_parser.Tom Lane2007-12-03
| | | | The spi documentation is pretty rudimentary, but it's a start.
* Update SGML contrib documentation to catch up with recent changes toTom Lane2007-12-03
| | | | the former README files. Albert Cervera i Areny
* Stamp 8.3beta4.REL8_3_BETA4Tom Lane2007-12-03
|
* Revert COPY OUT to follow the pre-8.3 handling of ASCII control characters,Tom Lane2007-12-03
| | | | | | | | | | namely that \r, \n, \t, \b, \f, \v are dumped as those two-character representations rather than a backslash and the literal control character. I had made it do the other to save some code, but this was ill-advised, because dump files in which these characters appear literally are prone to newline mangling. Fortunately, doing it the old way should only cost a few more lines of code, and not slow down the copy loop materially. Per bug #3795 from Lou Duchez.
* Ensure that all <sect1> and <refentry> tags have IDs. This is neededTom Lane2007-12-02
| | | | | | | to ensure that the resulting webpages have predictable URLs, instead of ever-changing numeric IDs. The new contrib docs were the biggest offender, but some old stuff had the problem too. Also, rename a couple of new contrib sgml files for consistency's sake.
* Remove README files now migrated to SGML docs.Tom Lane2007-12-02
|
* Add SGML docs for contrib/dict_int and contrib/dict_xsyn.Tom Lane2007-12-02
| | | | Albert Cervera i Areny
* Improve the manual's discussion of partitioning. Recommend using aTom Lane2007-12-02
| | | | | | trigger instead of a rule to redirect insertions, use NEW.* notation where appropriate, some other updates and adjustments. David Fetter and Tom Lane
* Mention hash opclasses in 'System Dependencies on Operator Classes',Tom Lane2007-12-02
| | | | which previously only talked about btree opclasses.
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-03 21:51:07 +0000