summaryrefslogtreecommitdiff
path: root/doc/src
AgeCommit message (Collapse)Author
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
2005-10-13Update:Bruce Momjian
> * 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 >
2005-10-12Fix spelling error, per Michael Fuhr.Tom Lane
2005-10-12Remove item:Bruce Momjian
< * Prevent libpq's PQfnumber() from lowercasing the column name < < One idea is to lowercase all identifiers except those that are < surrounded by quotes. <
2005-10-12Add warning about plperl nested named subroutinesBruce Momjian
Andrew Dunstan
2005-10-12No longer needed:Bruce Momjian
< < * 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.
2005-10-12Rearrange:Bruce Momjian
< 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
2005-10-12Done:Bruce Momjian
< o %Replace crude DELETE FROM method of pg_dumpall --clean for < cleaning of roles with separate DROP commands 608a607 >
2005-10-12Add:Bruce Momjian
< > o Allow pg_dump --clean to drop roles that own objects or have > privileges