summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
2005-10-25Add:Bruce Momjian
> > o Add auto-expanded mode so expanded output is used if the row > length is wider than the screen width. > > Consider using auto-expanded mode for backslash commands like \df+.
2005-10-25Convert explanation of interval change into something resembling grammaticalTom Lane
English, and fix the incorrect example.
2005-10-25Small grammar correction.Tom Lane
2005-10-25Update 24 hours/1 day distinction in release notes.Bruce Momjian
2005-10-25Update the URL for "The Hitch-Hiker's Guide to Evolutionary Computation".Bruce Momjian
Sergey E. Koposov
2005-10-24Add:Bruce Momjian
> * Allow user-defined functions retuning a domain value to enforce domain > constraints
2005-10-24More forcefully recommend MD5 over crypt authentication.Bruce Momjian
2005-10-24Fix incorrect wording about function failure time on unsafe ops - theseAndrew Dunstan
are now caught by the validator. And a small visit from the perl style police: check the return value from open().
2005-10-24I have applied the following patch to document PQinitSSL() andBruce Momjian
PQregisterThreadLock(). I also remove the crypt() mention in the libpq threading section and added a single sentence in the client-auth manual page under crypt(). Crypt authentication is so old now that a separate paragraph about it seemed unwise. I also added a comment about our use of locking around pqGetpwuid().
2005-10-23A bit of minor copy-editing.Tom Lane
2005-10-23I've confirmed 8.1beta4 passes regression tests on all hardware platformsTom Lane
of RHEL 4. Update supported-platforms list accordingly.
2005-10-22Add a note about GNU tar's propensity to complain if a file changesTom Lane
while tar is copying it. This behavior is unhelpful when taking a base backup. Per gripe from Pallav Kalva back in April.
2005-10-22Copy-editing for recent documentation changes relevant to WAL,Tom Lane
full_page_writes, etc.
2005-10-22Fix documentation to specify the correct range of timezone offsets forTom Lane
type time with time zone, ie, +/- 13:59 not +/- 12:00. Also some minor wording improvements.
2005-10-22Fix typo.Alvaro Herrera
2005-10-21Clean up autovacuum documentation, which was a bit out of sync with whatTom Lane
the code actually does, and needed copy-editing anyway. Also take the opportunity to expand the section on routine reindexing.
2005-10-21Update obsolete URL, per Chris.Tom Lane
2005-10-21Minor PL/PgSQL doc tweak: use current_timestamp rather than now() inNeil Conway
an example function.
2005-10-21Clean up some obsolete statements about GiST indexes, and add a sectionTom Lane
documenting GiST crash recovery procedures, as requested some time ago by Teodor. (The GiST chapter doesn't seem quite the right place for the latter, but I'm not sure what else to do with it.)
2005-10-20Improve testlibpq3.c's example of PQexecParams() usage to include sendingTom Lane
a parameter in binary format. Also, add a TIP explaining how to use casts in the query text to avoid needing to specify parameter types by OID. Also fix bogus spacing --- apparently somebody expanded the tabs in the example programs to 8 spaces instead of 4 when transposing them into SGML.
2005-10-20Minor tweak to libpq documentation: make "PREPARE" and "DEALLOCATE" xrefs.Neil Conway
2005-10-20Document the behavior of GRANT/REVOKE in cases where the privilege isTom Lane
held by means of role membership, rather than directly. Per discussion and bug fix of a couple weeks ago.
2005-10-18replace use of predefined perl vars $a and $b with $x and $y - per Greg ↵Andrew Dunstan
Sabino Mullane
2005-10-18Add an entry to the discussion of regression test failures about theTom Lane
possibility of a failure due to stack overflow when max_stack_depth is not set properly for the platform.
2005-10-18Code review for regexp_replace patch. Improve documentation and comments,Tom Lane
fix problems with replacement-string backslashes that aren't followed by one of the expected characters, avoid giving the impression that replace_text_regexp() is meant to be called directly as a SQL function, etc.
2005-10-17Clean up libpq's pollution of application namespace by renaming theTom Lane
exported routines of ip.c, md5.c, and fe-auth.c to begin with 'pg_'. Also get rid of the vestigial fe_setauthsvc/fe_getauthsvc routines altogether.
2005-10-16Add note that some versions of OS X require SHMMAX to be an exact multipleTom Lane
of 4096. Also add comment explaining why we don't suggest using /etc/sysctl.conf to avoid needing to edit /etc/rc.
2005-10-15Remove a long comment from cvs.sgml -- AFAICS this is no longer useful,Neil Conway
or at any rate doesn't belong as a comment in a random SGML file.
2005-10-15Fix assorted typos in the documentation, and use American spellingNeil Conway
rather than British. Patch from Michael Fuhr.
2005-10-15Update 'supported platforms' list with current buildfarm results.Tom Lane
2005-10-15Fix kerberos description: localhost -> server hostname.Bruce Momjian
2005-10-15Merge some user-submitted suggestions for improvement into theNeil Conway
documentation. Mostly add some <xref>s, fix a few typos, and document that zlib is required in the installation docs.
2005-10-15Fix typo.Alvaro Herrera
2005-10-14Fix syslog bug: if any messages are emitted to write_syslog beforeTom Lane
the facility has been set, the facility gets set to LOCAL0 and cannot be changed later. This seems reasonably plausible to happen, particularly at higher debug log levels, though I am not certain it explains Han Holl's recent report. Easiest fix is to teach the code how to change the value on-the-fly, which is nicer anyway. I made the settings PGC_SIGHUP to conform with log_destination.
2005-10-14fix nonsensical summary row on exampleAndrew Dunstan
2005-10-14Allow times of 24:00:00 to match rounding behavior:Bruce Momjian
regression=# select '23:59:59.9'::time(0); time ---------- 24:00:00 (1 row) This is bad because: regression=# select '24:00:00'::time(0); ERROR: date/time field value out of range: "24:00:00" The last example now works.
2005-10-13Add documentation mentioning that there are separate regression testsTom Lane
for the PL languages and for contrib.
2005-10-13Improve documentation about CREATEROLE privilege.Tom Lane
2005-10-13Update krb_server_name to document that a missing entry defaults toBruce Momjian
'localhost'. Improve kerberos error message.
2005-10-13Update documentation to reflect the new ALTER OWNER rules for allTom Lane
affected types of objects.
2005-10-13Describe the behavior of the SQL_ASCII encoding more accurately.Tom Lane
2005-10-13Adjust the discussion of triggers to more clearly guide people in theTom Lane
direction of writing triggers in a procedural language, rather than C. Per discussion.
2005-10-13The patch updates the documentation to reflect the fact that higher valuesBruce Momjian
of client_min_messages (fatal + panic) are valid and also fixes a slight issue with how psql tried to display error messages that aren't sent to the client. We often tell people to ignore errors in response to requests for things like "drop if exists", but there's no good way to completely hide this without upping client_min_messages past ERROR. When running a file like SET client_min_messages TO 'FATAL'; DROP TABLE doesntexist; with "psql -f filename" you get an error prefix of "psql:/home/username/filename:3" even though there is no error message to prefix because it isn't sent to the client. Kris Jurka
2005-10-13Turn off list of tables, figures, and examples.Peter Eisentraut
2005-10-13Rewording, use the more common multi-threaded/single-threaded.Bruce Momjian
2005-10-13Clarify causes of possible mismatch between Win32 libraries andBruce Momjian
applications that use FILE pointers.
2005-10-13Some additional doc changes based around compression of page images inBruce Momjian
WAL and the interaction of the new full_page_writes parameter with PITR. The too-small WAL first sect1 has been merged with the one following sect1 for clarity. Some minor comments have been made in the WAL config section also. Passes SGML make and proofread for typos. Files changed: patching file doc/src/sgml/backup.sgml patching file doc/src/sgml/config.sgml patching file doc/src/sgml/wal.sgml Simon Riggs
2005-10-13Fix capitalization of example.Bruce Momjian
2005-10-13Update trigger demo to reflect new trigger ordering.Bruce Momjian
2005-10-13Remove extra <para>Bruce Momjian