aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* Some editorializing on the docs for the dollar-quoting feature: fixTom Lane2004-09-20
| | | | | grammar, don't drop discussions into the middle of unrelated discussions, etc.
* Fix some shortcomings in psql's autocommit-off mode concerning detectionTom Lane2004-09-20
| | | | | | | of commands for which a transaction block should not be forced. Recognize VACUUM and other PreventTransactionChain commands; handle nested /* .. */ comments correctly; handle multibyte encodings correctly. Michael Paesold with some kibitzing from Tom Lane.
* Now that I look, table 8-1 has some other marginal misstatements in it.Tom Lane2004-09-20
| | | | | If we're going to put brackets around optional precision specs in some entries, we'd better do it in all.
* Minor documentation cleanup and improvement.Neil Conway2004-09-20
|
* Put the brackets in the right places in timestamp entries in table 8-1.Tom Lane2004-09-18
| | | | Spotted by Josh Purinton.
* Improve documentation of log rotation options, per Ed L.Tom Lane2004-09-17
|
* Allow WIN1250 as server encoding.Peter Eisentraut2004-09-17
|
* Hyperlink a reference to DROP CAST in the CREATE CAST reference page.Neil Conway2004-09-17
|
* Minor doc tweak: mention that function names can be optionally schema-Neil Conway2004-09-16
| | | | qualified.
* Redesign query-snapshot timing so that volatile functions in READ COMMITTEDTom Lane2004-09-13
| | | | | | | | | | | | | mode see a fresh snapshot for each command in the function, rather than using the latest interactive command's snapshot. Also, suppress fresh snapshots as well as CommandCounterIncrement inside STABLE and IMMUTABLE functions, instead using the snapshot taken for the most closely nested regular query. (This behavior is only sane for read-only functions, so the patch also enforces that such functions contain only SELECT commands.) As per my proposal of 6-Sep-2004; I note that I floated essentially the same proposal on 19-Jun-2002, but that discussion tailed off without any action. Since 8.0 seems like the right place to be taking possibly nontrivial backwards compatibility hits, let's get it done now.
* Fire non-deferred AFTER triggers immediately upon query completion,Tom Lane2004-09-10
| | | | | | | | | | | | | rather than when returning to the idle loop. This makes no particular difference for interactively-issued queries, but it makes a big difference for queries issued within functions: trigger execution now occurs before the calling function is allowed to proceed. This responds to numerous complaints about nonintuitive behavior of foreign key checking, such as http://archives.postgresql.org/pgsql-bugs/2004-09/msg00020.php, and appears to be required by the SQL99 spec. Also take the opportunity to simplify the data structures used for the pending-trigger list, rename them for more clarity, and squeeze out a bit of space.
* Clarify description of SET CONSTRAINTS. Point out that it is stillTom Lane2004-09-08
| | | | missing the ability to schema-qualify constraint names.
* Remove a stray reference to sequences as having tablespaces.Tom Lane2004-09-01
|
* Add a note about the difference between Postgres' treatment of the rightsTom Lane2004-09-01
| | | | of an object owner and the SQL spec's treatment of these rights.
* Add index mention:Bruce Momjian2004-09-01
| | | | | | <P>In pre-8.0 releases, indexes often can not be used unless the data types exactly match the index's column types. This is particularly true of int2, int8, and numeric column indexes.</P>
* Replace log_filename_prefix with more general log_filename parameter,Tom Lane2004-08-31
| | | | | | | to allow DBA to choose the form in which log filenames reflect the current time. Also allow for truncating instead of appending to pre-existing files --- this is convenient when the log filename pattern rewrites the same names cyclically. Per Ed L.
* Avoid ambiguity, as per suggestion from Peter Stricker.Tom Lane2004-08-30
|
* Rather than referring to src/tutorial/README, put the build instructionsTom Lane2004-08-30
| | | | for the tutorial files right here.
* Add note that contrib/rserv is gone.Tom Lane2004-08-30
|
* Add explicit note that empty-string array element values now have toTom Lane2004-08-30
| | | | be written with quotes. Minor copy-editing too.
* Add WAL logging for CREATE/DROP DATABASE and CREATE/DROP TABLESPACE.Tom Lane2004-08-29
| | | | | | | | Fix TablespaceCreateDbspace() to be able to create a dummy directory in place of a dropped tablespace's symlink. This eliminates the open problem of a PANIC during WAL replay when a replayed action attempts to touch a file in a since-deleted tablespace. It also makes for a significant improvement in the usability of PITR replay.
* Update win32 comments.Bruce Momjian2004-08-27
|
* New Win32 wording that mentions "code".Bruce Momjian2004-08-26
|
* Update documentation to prefer CIDR format for pg_hba.conf and use newBruce Momjian2004-08-26
| | | | CIDR column in examples first.
* Update Win32 wording.Bruce Momjian2004-08-26
|
* Add warning about Win32 bugs in this release.Bruce Momjian2004-08-26
|
* Update Japanese FAQ.Bruce Momjian2004-08-26
| | | | Jun Kuwamura
* Update tcp connection faq.Bruce Momjian2004-08-26
|
* Various minor improvements to the SGML documentation: fix some incorrectNeil Conway2004-08-24
| | | | | | SGML markup, add a "deprecated features" section to the 8.0 release notes, untabify release.sgml and runtime.sgml, and make some other minor improvements.
* Update that 8.0 will support MS Win natively.Bruce Momjian2004-08-23
|
* Update newest version number.Bruce Momjian2004-08-23
|
* Seems it would be nice if the ALTER INDEX ref page were actuallyTom Lane2004-08-21
| | | | linked into the docs ...
* Fix typo (extraneous comma).Tom Lane2004-08-21
|
* Mention that to_char(interval) will be removed in 8.1.Bruce Momjian2004-08-21
|
* Fix typo in new ALTER INDEX manual page.Bruce Momjian2004-08-20
|
* Add ALTER INDEX, particularly for moving tablespaces.Bruce Momjian2004-08-20
| | | | Gavin Sherry
* > Please find attached a submission to add a "exit on error" option toBruce Momjian2004-08-20
| | | | | | | | > pg_restore, as it seems that some people have scripts that rely on the > previous "abort on error" default behavior when restoring data with a > direct connection. > > Fabien Coelho
* Use backslash in %USERPROFILE%\.pgpass.Bruce Momjian2004-08-19
|
* Don't use get_home_path so libpq doesn't pull path.c into the library.Bruce Momjian2004-08-19
|
* Remove NT4 mention in release notes.Bruce Momjian2004-08-18
|
* The enclose patch clarifies and makes a more useful example for theBruce Momjian2004-08-18
| | | | | | Global Values in PL/Perl section of the documents. David Fetter
* Replace incorrect example for quote_identBruce Momjian2004-08-18
| | | | Greg Sabino Mullan
* Update release history for 7.4.5.Tom Lane2004-08-18
|
* Chain on to SIGPIPE handler rather than just do action on default.Bruce Momjian2004-08-17
| | | | Always create thread-specific variable.
* Add trivial NULL statement to plpgsql, for Oracle compatibility.Tom Lane2004-08-16
|
* Mark server_encoding and integer_datetimes as GUC_REPORT, per previousTom Lane2004-08-16
| | | | proposals by Oliver Jowett. Update documentation.
* Fix trivial typo.Tom Lane2004-08-15
|
* Minor copy-editing for 7.4.4, 7.3.7, 7.2.5 release notes.Tom Lane2004-08-15
|
* Fix typo, per Andreas Seltenreich.Tom Lane2004-08-14
|
* Add discussion and example about predicate locking and why "serializable"Tom Lane2004-08-14
| | | | | mode isn't really serializable. I had thought this was covered already in our docs, but I sure can't find it.