aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Fix LISTEN/NOTIFY race condition reported by Laurent Birtz, by postponingTom Lane2008-03-12
| | | | | | | | | | | | | | | | | | pg_listener modifications commanded by LISTEN and UNLISTEN until the end of the current transaction. This allows us to hold the ExclusiveLock on pg_listener until after commit, with no greater risk of deadlock than there was before. Aside from fixing the race condition, this gets rid of a truly ugly kludge that was there before, namely having to ignore HeapTupleBeingUpdated failures during NOTIFY. There is a small potential incompatibility, which is that if a transaction issues LISTEN or UNLISTEN and then looks into pg_listener before committing, it won't see any resulting row insertion or deletion, where before it would have. It seems unlikely that anyone would be depending on that, though. This patch also disallows LISTEN and UNLISTEN inside a prepared transaction. That case had some pretty undesirable properties already, such as possibly allowing pg_listener entries to be made for PIDs no longer present, so disallowing it seems like a better idea than trying to maintain the behavior.
* Add to documentation:Bruce Momjian2008-03-11
| | | | | | | | + Setting <varname>statement_timeout</> in + <filename>postgresql.conf</> is not recommended because it + affects all sessions. Backpatch to 8.3.X.
* Back out doc addition that statement_timeout affects autovacuum.Bruce Momjian2008-03-11
|
* Document that statement_timeout is not recommended in postgresql.confBruce Momjian2008-03-11
| | | | because it affects all sessions, including autovacuum.
* Clearify PITR doc wording.Bruce Momjian2008-03-07
|
* Document that enabling asserts can _significantly_ slow down the server.Bruce Momjian2008-03-06
| | | | Back patch to 8.3.X.
* Move client encoding libpq function docs into libpq doc section, andBruce Momjian2008-03-06
| | | | | | just reference them from the localization doc section. Backpatch to 8.3.X.
* Document that increasing the number of checkpoints segments orBruce Momjian2008-03-05
| | | | | checkpoint timeout can incrase the time needed for crash recovery, per suggestion from Simon.
* Show example of ts_headline() using a configuration name.Bruce Momjian2008-03-04
|
* Remove "reliably" from chr(0) doc mention.Bruce Momjian2008-03-03
|
* Document that chr(0) is not supported, and why.Bruce Momjian2008-03-03
|
* Support for building contrib/uuid-ossp with MSVC.Magnus Hagander2008-02-28
| | | | Original patch from Hiroshi Saito, modified by me.
* Change the declaration of struct varlena so that the length word isTom Lane2008-02-23
| | | | | | | | | | | | | | | represented as "char ...[4]" not "int32". Since the length word is never supposed to be accessed via this struct member anyway, this won't break any existing code that is following the rules. The advantage is that C compilers will no longer assume that a pointer to struct varlena is word-aligned, which prevents incorrect optimizations in TOAST-pointer access and perhaps other places. gcc doesn't seem to do this (at least not at -O2), but the problem is demonstrable on some other compilers. I changed struct inet as well, but didn't bother to touch a lot of other struct definitions in which it wouldn't make any difference because there were other fields forcing int alignment anyway. Hopefully none of those struct definitions are used for accessing unaligned Datums.
* Correct XML markup typo, <book> -> </book>Bruce Momjian2008-02-13
| | | | | | | XMLPARSE (DOCUMENT '<?xml version="1.0"?><book><title>Manual</title><chapter>...</chapter></book>') Backpatch to 8.3.X.
* Fix SPI_cursor_open() and SPI_is_cursor_plan() to push the SPI stack beforeTom Lane2008-02-12
| | | | | | | | | | | | | | | | | | | | | doing anything interesting, such as calling RevalidateCachedPlan(). The necessity of this is demonstrated by an example from Willem Buitendyk: during a replan, the planner might try to evaluate SPI-using functions, and so we'd better be in a clean SPI context. A small downside of this fix is that these two functions will now fail outright if called when not inside a SPI-using procedure (ie, a SPI_connect/SPI_finish pair). The documentation never promised or suggested that that would work, though; and they are normally used in concert with other functions, mainly SPI_prepare, that always have failed in such a case. So the odds of breaking something seem pretty low. In passing, make SPI_is_cursor_plan's error handling convention clearer, and fix documentation's erroneous claim that SPI_cursor_open would return NULL on error. Before 8.3 these functions could not invoke replanning, so there is probably no need for back-patching.
* Some small editorialization on the protocol documentation for GSSAPI/SSPITom Lane2008-02-08
| | | | authentication.
* Add "automatically" to HOT release note description.Bruce Momjian2008-02-07
|
* Fix very broken clean.bat for msvc install. The way we used subroutinesMagnus Hagander2008-02-06
| | | | | | | | | | | | | in .bat simply did not work, and it called them in the wrong order, some several times, and some not at all. So this unrolls all subroutine calls. This should fix the issues with clean deleting the wrong files reported by Dave Page. While at it, add the "clean dist" option to act like "make distclean", and no longer remove the flex/bison output files by default. This shuold fix the problem reported by Pavel Golub in bug #3909.
* Fix mistaken duplicate reference to max_fsm_pages, per bug #3926.Tom Lane2008-02-03
| | | | Also make links clickable.
* Minor wordsmithing in release notes' description of asynchronous commit.Tom Lane2008-02-02
|
* Move example of turning off synchronous_commit to a more logical place,Tom Lane2008-02-02
| | | | to wit in the description of that variable rather than some other one.
* Update FAQ for most recent release as 8.3.Bruce Momjian2008-02-01
|
* Update item:Bruce Momjian2008-02-01
| | | | | | < * Improve deadlock detection when deleting items from shared buffers > * Improve deadlock detection when a page cleaning lock conflicts > with a shared buffer that is pinned
* Fix spelling typo in comment.Bruce Momjian2008-01-31
|
* Add comment about possible URL changes for www7.hp.com:Bruce Momjian2008-01-31
| | | | <!-- If this URL chnages replace it with a URL to www.archive.org. -->
* Update spoofing /tmp symlink instructions to be more specific about theBruce Momjian2008-01-31
| | | | name of the needed symlink file.
* Mention synchronize_seqscans GUC variable in release notes.Tom Lane2008-01-31
| | | | Update expected release date.
* Remove the old table of "supported platforms" in favor of a link to theTom Lane2008-01-31
| | | | | | | | buildfarm plus a narrative description of the CPU types and operating systems on which Postgres is likely to work. Now that we've almost completely decoupled CPU and OS considerations, the former tabular style isn't all that enlightening anyway. Perhaps more importantly, no one seems particularly interested in maintaining the table by hand when we have the buildfarm.
* Improve pg_autovacuum documentation to clarify that the enabled field cannotTom Lane2008-01-31
| | | | | | | prevent anti-wraparound vacuuming, and to caution against setting unreasonably small values of freeze_max_age. Also put in a notice that this catalog is likely to disappear entirely in some future release. Per discussion of bug #3898 from Steven Flatt.
* Document the idea of creating a symbolic link in /tmp to prevent serverBruce Momjian2008-01-31
| | | | spoofing when the socket file has been moved.
* Add:Bruce Momjian2008-01-31
| | | | | | | | > * Improve deadlock detection when deleting items from shared buffers > > http://archives.postgresql.org/pgsql-bugs/2008-01/msg00138.php > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00873.php > http://archives.postgresql.org/pgsql-committers/2008-01/msg00365.php
* Add a GUC variable "synchronize_seqscans" to allow clients to disable the newTom Lane2008-01-30
| | | | | synchronized-scanning behavior, and make pg_dump disable sync scans so that it will reliably preserve row ordering. Per recent discussions.
* Improve table referencePeter Eisentraut2008-01-30
|
* Update key words table for 8.3Peter Eisentraut2008-01-30
|
* Update wording:Bruce Momjian2008-01-29
| | | | | < * Add anonymous transactions > * Add autonomous transactions
* Add item:Bruce Momjian2008-01-29
| | | | | | | > * Add anonymous transactions > > http://archives.postgresql.org/pgsql-hackers/2008-01/msg00893.php >
* Remove duplicat item:Bruce Momjian2008-01-29
| | | | < o Allow the PITR process to be debugged and data examined
* markup correctPeter Eisentraut2008-01-29
| | | | from Gevik Babakhani
* Add "Communication Method" row to HA feature matrix documentation.Bruce Momjian2008-01-28
|
* Minor editorial improvements in documentation of session_replication_role;Tom Lane2008-01-27
| | | | | in particular correct the obsolete claim that it can't be changed once any plans have been cached.
* Fix example of de-escaping bytea argument, per Florian Weimer. Also fix exampleAndrew Dunstan2008-01-25
| | | | of escaping bytea return value. Both cases did not handle backslash values properly.
* Change /contrib to contrib for consistency.Peter Eisentraut2008-01-24
|
* Provide a concrete example of parameter expansion in archive_command.Tom Lane2008-01-23
| | | | Per discussion of bug #3877. Simon Riggs, some fixes by moi.
* Avoid mathematical inconsistency in example about avoiding division byTom Lane2008-01-23
| | | | zero with a CASE expression. Per gripe from Russell Smith.
* Reference pgAdmin as a typical client-side tool, rather than theTom Lane2008-01-23
| | | | no-longer-maintained PgAccess. Per Erik Rijkers.
* Improve description of bgwriter_lru_multiplier, per discussion.Tom Lane2008-01-21
|
* Stamp release for 8.3RC2; configure will be stamped by packager.Bruce Momjian2008-01-18
|
* Update Japanese FAQ.Bruce Momjian2008-01-17
| | | | Jun Kuwamura
* Typo fix.Magnus Hagander2008-01-17
| | | | Erik Rijkers
* pgcrypto doc updatesMagnus Hagander2008-01-17
| | | | Marko Kreen
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-05 18:41:19 +0000