summaryrefslogtreecommitdiff
path: root/doc/src
Commit message (Collapse)AuthorAgeFilesLines
...
* Mark 7.2.2 as newest release.Bruce Momjian2002-08-221-2/+2
|
* Update FAQ.Bruce Momjian2002-08-221-1/+1
|
* Improve wording of upgrade section.Bruce Momjian2002-08-221-20/+17
|
* Fix for documention:Bruce Momjian2002-08-221-4/+3
| | | | | | | | >>" It's also possible to select no escape character by writing ESCAPE ''. >>In this case there is no way to turn off the special meaning of >>underscore and percent signs in the pattern." Joe Conway
* > > I had great difficulty in finding how to change the search path, so hereBruce Momjian2002-08-223-3/+23
| | | | | | > > is a patch to add some cross-referencing. Oliver Elphick
* Remove libpq++ SGML documentation.Bruce Momjian2002-08-223-849/+2
|
* Add a bunch of pseudo-types to replace the behavior formerly associatedTom Lane2002-08-2215-80/+249
| | | | | | with OPAQUE, as per recent pghackers discussion. I still want to do some more work on the 'cstring' pseudo-type, but I'm going to commit the bulk of the changes now before the tree starts shifting under me ...
* Fix bad markup detected by Alvaro HerreraBruce Momjian2002-08-211-17/+17
|
* Fix markup, Alvaro Herrera.Bruce Momjian2002-08-211-3/+3
|
* Enable large file support.Peter Eisentraut2002-08-201-1/+2
| | | | Use off_t and size_t in pg_dump to handle file offset arithmetic correctly.
* This patch improves the behavior of FOUND in PL/PgSQL. In Oracle,Bruce Momjian2002-08-201-12/+60
| | | | | | | | | | | | FOUND is set whenever a SELECT INTO returns > 0 rows, *or* when an INSERT, UPDATE, or DELETE affects > 0 rows. We implemented the first part of this behavior, but not the second. I also improved the documentation on the various situations in which FOUND can be set (excluding inside FOR loops, which I still need to think about), and added some regression tests for this behavior. Neil Conway
* Allow pg_statistics to be reset by calling pg_stat_reset().Bruce Momjian2002-08-201-1/+9
| | | | Christopher Kings-Lynne
* Add current_database().Bruce Momjian2002-08-201-1/+6
| | | | | | | | | | | | | | | > Quick system function to pull out the current database. > > I've used this a number of times to allow stored procedures to find out > where they are. Especially useful for those that do logging or hit a > remote server. > > It's called current_database() to match with current_user(). It's also a necessity for an informational schema. The catalog (database) name is required in a number of places. Rod Taylor
* Add mention of -F not supported by pg_dumpall. Code already disallows it.Bruce Momjian2002-08-201-2/+2
|
* Fix pg_dump to dump serial columns as serials. Per pghackers discussion,Tom Lane2002-08-192-19/+26
| | | | | cause SERIAL column declaration not to imply UNIQUE, so that this can be done without creating an extra index.
* Fix broken tag.Tatsuo Ishii2002-08-191-1/+3
|
* Make pg_dump output more portable and more pleasing to look at.Peter Eisentraut2002-08-182-28/+3
| | | | | | | | | | | | | | | | | The -n and -N options were removed. Quoting is now smart enough to supply quotes if and only if necessary. Numerical types are now printed without quotes, except in cases of special values such as NaN. Boolean values printed as true and false. Most string literals now do not escape whitespace characters (newlines, etc.) for portability. SET SESSION AUTHORIZATION argument is a string literal, to follow SQL. Made commands output by pg_dump use consistent spacing and indentation.
* Add db-local user names, per discussion on hackers.Bruce Momjian2002-08-181-1/+21
|
* Fix typo.Tom Lane2002-08-171-2/+2
|
* [ Newest version of patch applied.]Bruce Momjian2002-08-172-3/+139
| | | | | | | | | | | | | | | | | | This patch is an updated version of the lock listing patch. I've made the following changes: - write documentation - wrap the SRF in a view called 'pg_locks': all user-level access should be done through this view - re-diff against latest CVS One thing I chose not to do is adapt the SRF to use the anonymous composite type code from Joe Conway. I'll probably do that eventually, but I'm not really convinced it's a significantly cleaner way to bootstrap SRF builtins than the method this patch uses (of course, it has other uses...) Neil Conway
* Add libpq connection timeout parameter.Bruce Momjian2002-08-171-1/+10
| | | | Denis A Ustimenko
* Improve documentation of trigger firing queue handling, cleanup.Bruce Momjian2002-08-171-6/+32
| | | | Neil Conway
* Editorial corrections.Tom Lane2002-08-172-26/+50
|
* Broken markup.Tom Lane2002-08-171-2/+2
|
* Add missing links.Tom Lane2002-08-172-3/+5
|
* Add doc file for pg_resetxlog.Bruce Momjian2002-08-171-0/+89
|
* Move pg_controldata to /bin.Bruce Momjian2002-08-171-2/+3
|
* Modify pg_dump to dump foreign-key constraints as constraints, not asTom Lane2002-08-161-4/+18
| | | | | | | sets of triggers. Also modify psql \d command to show foreign key constraints as such and hide the triggers. pg_get_constraintdef() function added to backend to support these. From Rod Taylor, code review and some editorialization by Tom Lane.
* Improve wording.Bruce Momjian2002-08-161-1/+2
|
* Move pg_controldata from /contrib to src/bin.Bruce Momjian2002-08-164-4/+80
|
* This patch improves the "Client Authentication" section of the user'sBruce Momjian2002-08-161-18/+23
| | | | | | guide in a few minor ways. Neil Conway
* This patch improves the "Database Users and Permissions" section ofBruce Momjian2002-08-161-37/+47
| | | | | | | the Administrator's Guide. This section needs a lot more work, but this is a start anyway... Neil Conway
* Tom Lane wrote:Bruce Momjian2002-08-151-4/+47
| | | | | | | | | | | | | | | | | > There's no longer a separate call to heap_storage_create in that routine > --- the right place to make the test is now in the storage_create > boolean parameter being passed to heap_create. A simple change, but > it passeth patch's understanding ... Thanks. Attached is a patch against cvs tip as of 8:30 PM PST or so. Turned out that even after fixing the failed hunks, there was a new spot in bufmgr.c which needed to be fixed (related to temp relations; RelationUpdateNumberOfBlocks). But thankfully the regression test code caught it :-) Joe Conway
* Reorder entry to be alphabetical to match others.Bruce Momjian2002-08-151-74/+74
|
* PostgreSQL 7.2.1 DocumentationBruce Momjian2002-08-151-3/+3
| | | | | | | | | | | | | Chapter 1. libpq - C Library 1.3. Command Execution Functions 1.3.3. Escaping binary strings for inclusion in SQL queries I found the line "The result string length does not include the terminating zero byte of the result." is not right. The result string length does indeed include the terminating zero byte. Christoph Haller
* > Neil Conway <nconway@klamath.dyndns.org> writes:Bruce Momjian2002-08-153-6/+24
| | | | | | | | | | | | | > > This patch improves the documentation of the UPDATE and ALTER TABLE > > commands to elaborate on the effect of specifying an "ONLY" clause. > > Unfortunately this is still only half the truth ... see the > SQL_INHERITANCE configuration variable. Okay, I've attached an updated patch with more information on SQL_INHERITANCE and inheritance behavior in prior releases. Neil Conway
* I'm giving a try at some TODO items. Currently it's the turn of theBruce Momjian2002-08-152-10/+29
| | | | | | | | | | | PGPASSWORDFILE environment variable. I have modified libpq to make use of this variable. I present the first cut here. Currently the format for the file should be host:port:database:user:password Alvaro Herrera
* Add Cyrillic and other encodings for encoding conversion.Tatsuo Ishii2002-08-142-57/+362
| | | | Patches submitted by Kaori Inaba (i-kaori@sra.co.jp).
* Update for longer NAMEDATALEN.Bruce Momjian2002-08-131-1/+1
|
* Change NAMEDATALEN to 64, INDEX_MAX_KEYS/MAX_FUNC_ARGS to 32, per ↵Bruce Momjian2002-08-1310-23/+23
| | | | discussion on hackers.
* Remove obsolete uses of lanispl. Only used in pg_dump now, but can bePeter Eisentraut2002-08-131-3/+5
| | | | removed altogether if pg_dump doesn't need it anymore.
* Correct description of sequence privileges.Peter Eisentraut2002-08-121-4/+5
|
* Change memory-space accounting mechanism in tuplesort.c and tuplestore.cTom Lane2002-08-121-3/+3
| | | | | | | | to make a reasonable attempt at accounting for palloc overhead, not just the requested size of each memory chunk. Since in many scenarios this will make for a significant reduction in the amount of space acquired, partially compensate by doubling the default value of SORT_MEM to 1Mb. Per discussion in pgsql-general around 9-Jun-2002..
* Code review of CLUSTER patch. Clean up problems with relcache gettingTom Lane2002-08-111-1/+2
| | | | confused, toasted data getting lost, etc.
* Create/drop cast now requires ownership of at least one of the types.Peter Eisentraut2002-08-112-19/+7
|
* Editorial improvements.Tom Lane2002-08-111-50/+38
|
* Mention ANALYZE after CLUSTER.Bruce Momjian2002-08-101-4/+8
|
* Major improvement in CLUSTER which preserves table characteristics usingBruce Momjian2002-08-101-21/+15
| | | | | | | | | | | | relfilenode. I sent the CLUSTER patch a few days ago and I think it was missed. I append it again, this time including the regression test files. For the committer, please note that you have to cvs add the files as they don't exist. Maybe add to the parallel and serial schedules also, but I don't know such stuff. Alvaro Herrera (<alvherre[a]atentus.com>)
* psql prints its version number in its startup message, per recentTom Lane2002-08-103-7/+7
| | | | | discussion. Also, cause the \timing command to display time in a format consistent with the backend's EXPLAIN ANALYZE output.
* Allow schema-qualified operator names to be used in the optionalTom Lane2002-08-102-3/+23
| | | | arguments of CREATE OPERATOR.
View Lorry Controller Status