aboutsummaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAge
...
* I have applied the following patch to document PQinitSSL() andBruce Momjian2005-10-24
| | | | | | | | | | | 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().
* A bit of minor copy-editing.Tom Lane2005-10-23
|
* I've confirmed 8.1beta4 passes regression tests on all hardware platformsTom Lane2005-10-23
| | | | of RHEL 4. Update supported-platforms list accordingly.
* Add a note about GNU tar's propensity to complain if a file changesTom Lane2005-10-22
| | | | | while tar is copying it. This behavior is unhelpful when taking a base backup. Per gripe from Pallav Kalva back in April.
* Copy-editing for recent documentation changes relevant to WAL,Tom Lane2005-10-22
| | | | full_page_writes, etc.
* Fix documentation to specify the correct range of timezone offsets forTom Lane2005-10-22
| | | | | type time with time zone, ie, +/- 13:59 not +/- 12:00. Also some minor wording improvements.
* Fix typo.Alvaro Herrera2005-10-22
|
* Clean up autovacuum documentation, which was a bit out of sync with whatTom Lane2005-10-21
| | | | | the code actually does, and needed copy-editing anyway. Also take the opportunity to expand the section on routine reindexing.
* Update obsolete URL, per Chris.Tom Lane2005-10-21
|
* Minor PL/PgSQL doc tweak: use current_timestamp rather than now() inNeil Conway2005-10-21
| | | | an example function.
* Clean up some obsolete statements about GiST indexes, and add a sectionTom Lane2005-10-21
| | | | | | 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.)
* Improve testlibpq3.c's example of PQexecParams() usage to include sendingTom Lane2005-10-20
| | | | | | | 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.
* Minor tweak to libpq documentation: make "PREPARE" and "DEALLOCATE" xrefs.Neil Conway2005-10-20
|
* Document the behavior of GRANT/REVOKE in cases where the privilege isTom Lane2005-10-20
| | | | | held by means of role membership, rather than directly. Per discussion and bug fix of a couple weeks ago.
* replace use of predefined perl vars $a and $b with $x and $y - per Greg ↵Andrew Dunstan2005-10-18
| | | | Sabino Mullane
* Add an entry to the discussion of regression test failures about theTom Lane2005-10-18
| | | | | possibility of a failure due to stack overflow when max_stack_depth is not set properly for the platform.
* Code review for regexp_replace patch. Improve documentation and comments,Tom Lane2005-10-18
| | | | | | | 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.
* Clean up libpq's pollution of application namespace by renaming theTom Lane2005-10-17
| | | | | | 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.
* Add note that some versions of OS X require SHMMAX to be an exact multipleTom Lane2005-10-16
| | | | | of 4096. Also add comment explaining why we don't suggest using /etc/sysctl.conf to avoid needing to edit /etc/rc.
* Remove a long comment from cvs.sgml -- AFAICS this is no longer useful,Neil Conway2005-10-15
| | | | or at any rate doesn't belong as a comment in a random SGML file.
* Fix assorted typos in the documentation, and use American spellingNeil Conway2005-10-15
| | | | rather than British. Patch from Michael Fuhr.
* Update 'supported platforms' list with current buildfarm results.Tom Lane2005-10-15
|
* Fix kerberos description: localhost -> server hostname.Bruce Momjian2005-10-15
|
* Merge some user-submitted suggestions for improvement into theNeil Conway2005-10-15
| | | | | documentation. Mostly add some <xref>s, fix a few typos, and document that zlib is required in the installation docs.
* Fix typo.Alvaro Herrera2005-10-15
|
* Fix syslog bug: if any messages are emitted to write_syslog beforeTom Lane2005-10-14
| | | | | | | | | 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.
* fix nonsensical summary row on exampleAndrew Dunstan2005-10-14
|
* Allow times of 24:00:00 to match rounding behavior:Bruce Momjian2005-10-14
| | | | | | | | | | | | | | | 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.
* Add documentation mentioning that there are separate regression testsTom Lane2005-10-13
| | | | for the PL languages and for contrib.
* Improve documentation about CREATEROLE privilege.Tom Lane2005-10-13
|
* Update krb_server_name to document that a missing entry defaults toBruce Momjian2005-10-13
| | | | | | 'localhost'. Improve kerberos error message.
* Update documentation to reflect the new ALTER OWNER rules for allTom Lane2005-10-13
| | | | affected types of objects.
* Describe the behavior of the SQL_ASCII encoding more accurately.Tom Lane2005-10-13
|
* Adjust the discussion of triggers to more clearly guide people in theTom Lane2005-10-13
| | | | | direction of writing triggers in a procedural language, rather than C. Per discussion.
* The patch updates the documentation to reflect the fact that higher valuesBruce Momjian2005-10-13
| | | | | | | | | | | | | | | | | | | | 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
* Turn off list of tables, figures, and examples.Peter Eisentraut2005-10-13
|
* Rewording, use the more common multi-threaded/single-threaded.Bruce Momjian2005-10-13
|
* Clarify causes of possible mismatch between Win32 libraries andBruce Momjian2005-10-13
| | | | applications that use FILE pointers.
* Some additional doc changes based around compression of page images inBruce Momjian2005-10-13
| | | | | | | | | | | | | | | | | 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
* Fix capitalization of example.Bruce Momjian2005-10-13
|
* Update trigger demo to reflect new trigger ordering.Bruce Momjian2005-10-13
|
* Remove extra <para>Bruce Momjian2005-10-13
|
* Update:Bruce Momjian2005-10-13
| | | | | | | | > * Prevent PQfnumber() from lowercasing unquoted the column name > > PQfnumber() should never have been doing lowercasing, but historically > it has so we need a way to prevent it >
* Fix spelling error, per Michael Fuhr.Tom Lane2005-10-12
|
* Remove item:Bruce Momjian2005-10-12
| | | | | | | | < * Prevent libpq's PQfnumber() from lowercasing the column name < < One idea is to lowercase all identifiers except those that are < surrounded by quotes. <
* Add warning about plperl nested named subroutinesBruce Momjian2005-10-12
| | | | Andrew Dunstan
* No longer needed:Bruce Momjian2005-10-12
| | | | | | | | | | | < < * Add code to detect an SMP machine and handle spinlocks accordingly < from distributted.net, http://www1.distributed.net/source, < in client/common/cpucheck.cpp < < On SMP machines, it is possible that locks might be released shortly, < while on non-SMP machines, the backend should sleep so the process < holding the lock can complete and release it.
* Rearrange:Bruce Momjian2005-10-12
| | | | | | | | | < o %Add dumping of comments on composite type columns < o %Add dumping of comments on index columns < o Stop dumping CASCADE on DROP TYPE commands in clean mode > o %Add dumping of comments on index columns and composite type columns 604a603 > o Stop dumping CASCADE on DROP TYPE commands in clean mode
* Done:Bruce Momjian2005-10-12
| | | | | | | < o %Replace crude DELETE FROM method of pg_dumpall --clean for < cleaning of roles with separate DROP commands 608a607 >
* Add:Bruce Momjian2005-10-12
| | | | | | < > o Allow pg_dump --clean to drop roles that own objects or have > privileges