From b32685a999a3d60dbf1f5443ceb2d39d7464d1df Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Thu, 5 Oct 2000 19:48:34 +0000 Subject: Add proofreader's changes to docs. Fix misspelling of disbursion to dispersion. --- doc/src/sgml/Makefile | 4 +- doc/src/sgml/ref/allfiles.sgml | 4 +- doc/src/sgml/ref/alter_table.sgml | 4 +- doc/src/sgml/ref/copy.sgml | 12 +- doc/src/sgml/ref/create_aggregate.sgml | 4 +- doc/src/sgml/ref/create_database.sgml | 8 +- doc/src/sgml/ref/create_function.sgml | 18 +- doc/src/sgml/ref/create_index.sgml | 4 +- doc/src/sgml/ref/create_language.sgml | 8 +- doc/src/sgml/ref/create_rule.sgml | 10 +- doc/src/sgml/ref/create_sequence.sgml | 4 +- doc/src/sgml/ref/create_table.sgml | 34 +-- doc/src/sgml/ref/create_trigger.sgml | 4 +- doc/src/sgml/ref/create_type.sgml | 6 +- doc/src/sgml/ref/declare.sgml | 10 +- doc/src/sgml/ref/drop_database.sgml | 4 +- doc/src/sgml/ref/drop_operator.sgml | 6 +- doc/src/sgml/ref/drop_rule.sgml | 4 +- doc/src/sgml/ref/ecpg-ref.sgml | 4 +- doc/src/sgml/ref/explain.sgml | 6 +- doc/src/sgml/ref/fetch.sgml | 12 +- doc/src/sgml/ref/grant.sgml | 8 +- doc/src/sgml/ref/initdb.sgml | 9 +- doc/src/sgml/ref/initlocation.sgml | 4 +- doc/src/sgml/ref/insert.sgml | 4 +- doc/src/sgml/ref/ipcclean.sgml | 4 +- doc/src/sgml/ref/lock.sgml | 18 +- doc/src/sgml/ref/notify.sgml | 6 +- doc/src/sgml/ref/pg_ctl-ref.sgml | 414 +++++++++++++++++++++++++++++++++ doc/src/sgml/ref/pg_dump.sgml | 8 +- doc/src/sgml/ref/pg_dumpall.sgml | 4 +- doc/src/sgml/ref/pgaccess-ref.sgml | 10 +- doc/src/sgml/ref/pgctl-ref.sgml | 414 --------------------------------- doc/src/sgml/ref/postgres-ref.sgml | 4 +- doc/src/sgml/ref/postmaster.sgml | 4 +- doc/src/sgml/ref/psql-ref.sgml | 33 ++- doc/src/sgml/ref/reindex.sgml | 6 +- doc/src/sgml/ref/revoke.sgml | 6 +- doc/src/sgml/ref/select.sgml | 6 +- doc/src/sgml/ref/set.sgml | 10 +- doc/src/sgml/ref/unlisten.sgml | 6 +- doc/src/sgml/ref/vacuum.sgml | 4 +- doc/src/sgml/release.sgml | 4 +- 43 files changed, 578 insertions(+), 578 deletions(-) create mode 100644 doc/src/sgml/ref/pg_ctl-ref.sgml delete mode 100644 doc/src/sgml/ref/pgctl-ref.sgml (limited to 'doc/src') diff --git a/doc/src/sgml/Makefile b/doc/src/sgml/Makefile index 9ee2eb847cf..3b93cb96c69 100644 --- a/doc/src/sgml/Makefile +++ b/doc/src/sgml/Makefile @@ -8,7 +8,7 @@ # # # IDENTIFICATION -# $Header: /cvsroot/pgsql/doc/src/sgml/Makefile,v 1.21 2000/10/05 16:57:23 petere Exp $ +# $Header: /cvsroot/pgsql/doc/src/sgml/Makefile,v 1.22 2000/10/05 19:48:16 momjian Exp $ # #---------------------------------------------------------------------------- @@ -79,7 +79,7 @@ APPLICATIONS= createdb.sgml createlang.sgml createuser.sgml \ pgaccess-ref.sgml \ pgadmin-ref.sgml \ pg-config-ref.sgml \ - pgctl-ref.sgml \ + pg_ctl-ref.sgml \ pgtclsh.sgml \ pgtksh.sgml \ postgres-ref.sgml \ diff --git a/doc/src/sgml/ref/allfiles.sgml b/doc/src/sgml/ref/allfiles.sgml index 1bb3a0769d1..b13993f7af0 100644 --- a/doc/src/sgml/ref/allfiles.sgml +++ b/doc/src/sgml/ref/allfiles.sgml @@ -1,5 +1,5 @@ @@ -121,7 +121,7 @@ Complete list of usable sgml source files in this directory. - + diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index aa133b493bb..72ae3201022 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ @@ -273,7 +273,7 @@ ALTER TABLE table DROP CONSTRAINT < Removes a table constraint (such as a check constraint, unique constraint, or foreign key constraint). To - remove a unique constraint, drop a unique index, + remove a unique constraint, drop a unique index. To remove other kinds of constraints you need to recreate and reload the table, using other parameters to the diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 4772ad0530a..07d46eb56aa 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -1,5 +1,5 @@ @@ -210,7 +210,7 @@ ERROR: reason You must have select access on any table whose values are read by COPY, and either - insert or update access to a + insert or update access to a table into which values are being inserted by COPY. The backend also needs appropriate Unix permissions for any file read or written by COPY. @@ -293,7 +293,7 @@ ERROR: reason The actual format for each instance is -<attr1><separator><attr2><separator>...<separator><attrn><newline> +<attr1><separator><attr2><separator>...<separator><attrn><newline>. The oid is placed on the beginning of the line if WITH OIDS is specified. @@ -331,7 +331,7 @@ ERROR: reason In the case of COPY BINARY, the first four bytes in the file will be the number of instances in the file. If this number is zero, the COPY BINARY command - will read until end of file is encountered. Otherwise, it will + will read until end-of-file is encountered. Otherwise, it will stop reading when this number of instances has been read. Remaining data in the file will be ignored. @@ -414,7 +414,7 @@ The following example copies a table to standard output, COPY country TO stdout USING DELIMITERS '|'; - To copy data from a Unix file into a table "country": + To copy data from a Unix file into a table country: COPY country FROM '/usr1/proj/bray/sql/country_data'; @@ -434,7 +434,7 @@ has the termination sequence on the last line): \. - The same data, output in binary format on a Linux/i586 machine. + The following is the same data, output in binary format on a Linux/i586 machine. The data is shown after filtering through the Unix utility od -c. The table has three fields; the first is char(2) diff --git a/doc/src/sgml/ref/create_aggregate.sgml b/doc/src/sgml/ref/create_aggregate.sgml index 2571a027b3e..16d2e5b8248 100644 --- a/doc/src/sgml/ref/create_aggregate.sgml +++ b/doc/src/sgml/ref/create_aggregate.sgml @@ -1,5 +1,5 @@ @@ -162,7 +162,7 @@ CREATE for base types such as min(int4) and avg(float8) are already provided in the base distribution. If one defines new types or needs an aggregate function not - already provided then CREATE AGGREGATE + already provided, then CREATE AGGREGATE can be used to provide the desired features. diff --git a/doc/src/sgml/ref/create_database.sgml b/doc/src/sgml/ref/create_database.sgml index 1c5daa62631..d9e371b1be8 100644 --- a/doc/src/sgml/ref/create_database.sgml +++ b/doc/src/sgml/ref/create_database.sgml @@ -1,5 +1,5 @@ @@ -115,7 +115,7 @@ CREATE DATABASE name [ WITH LOCATIO The expansion of the specified dbpath - (see below how) failed. Check the path you entered or make sure that the + (see below) failed. Check the path you entered or make sure that the environment variable you are referencing does exist. @@ -138,7 +138,7 @@ CREATE DATABASE name [ WITH LOCATIO These are most likely related to insufficient permissions on the data directory, a full disk, or other file system problems. The user under - which the database server is running, must have access to the location. + which the database server is running must have access to the location. @@ -177,7 +177,7 @@ CREATE DATABASE name [ WITH LOCATIO If the server is compiled with ALLOW_ABSOLUTE_DBPATHS (not so by default), absolute path names, as identified by a leading slash - (e.g. '/usr/local/pgsql/data'), + (e.g., '/usr/local/pgsql/data'), are allowed as well. diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index cb484a41a44..81982c11b70 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -1,5 +1,5 @@ @@ -60,7 +60,7 @@ CREATE FUNCTION name ( [ opaque. - opaque indicates that the function + Opaque indicates that the function accepts arguments of a non-SQL type such as char *. @@ -71,7 +71,7 @@ CREATE FUNCTION name ( [ The return data type. The output type may be specified as a base type, complex type, - , + , or . The modifier indicates that the function will return a set of items, @@ -103,7 +103,7 @@ CREATE FUNCTION name ( [ This form of the AS clause is used for - dynamically-linked, C language functions when the function name in + dynamically linked, C language functions when the function name in the C language source code is not the same as the name of the SQL function. The string obj_file is the name of the file @@ -118,7 +118,7 @@ CREATE FUNCTION name ( [ langname - may be 'sql', + May be 'sql', 'C', 'newC', 'internal', 'newinternal', or 'plname', @@ -189,7 +189,7 @@ CREATE iscachable - indicates that the function always + indicates that the function always returns the same result when given the same argument values (i.e., it does not do database lookups or otherwise use information not directly present in its parameter list). The optimizer uses @@ -243,7 +243,7 @@ CREATE The full SQL92 type syntax is allowed for input arguments and return value. However, some details of the - type specification (e.g. the precision field for + type specification (e.g., the precision field for numeric types) are the responsibility of the underlying function implementation and are silently swallowed (i.e., not recognized or @@ -263,7 +263,7 @@ CREATE errors at link time. To get around that, give them different C names (for example, use the argument types as part of the C names), then specify those names in the AS clause of CREATE FUNCTION. - If the AS clause is left empty then CREATE FUNCTION + If the AS clause is left empty, then CREATE FUNCTION assumes the C name of the function is the same as the SQL name. @@ -322,7 +322,7 @@ CREATE TABLE product ( This example creates a function that does type conversion between the - user defined type complex, and the internal type point. The + user-defined type complex, and the internal type point. The function is implemented by a dynamically loaded object that was compiled from C source. For Postgres to find a type conversion function automatically, the sql function has diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index 44956f78bd5..550187ef462 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -1,5 +1,5 @@ @@ -305,7 +305,7 @@ ERROR: Cannot create index: 'index_name' already exists. bigbox_ops both support rtree indices on the box data type. The difference between them is that bigbox_ops - scales box coordinates down, to avoid floating point exceptions from + scales box coordinates down, to avoid floating-point exceptions from doing multiplication, addition, and subtraction on very large floating-point coordinates. If the field on which your rectangles lie is about 20,000 units square or larger, you should use diff --git a/doc/src/sgml/ref/create_language.sgml b/doc/src/sgml/ref/create_language.sgml index 7e95f4310b8..bab3aa4797e 100644 --- a/doc/src/sgml/ref/create_language.sgml +++ b/doc/src/sgml/ref/create_language.sgml @@ -1,5 +1,5 @@ @@ -169,7 +169,7 @@ ERROR: PL handler function funcname The call handler for a procedural language must be written - in a compiled language such as 'C' and registered with + in a compiled language such as C and registered with Postgres as a function taking no arguments and returning the opaque type, a placeholder for unspecified or undefined types. @@ -206,7 +206,7 @@ ERROR: PL handler function funcnamepg_proc table entry. This may be the source text in the procedural language itself (like for PL/Tcl), a pathname to a - file or anything else that tells the call handler what to + file, or anything else that tells the call handler what to do in detail. @@ -295,7 +295,7 @@ ERROR: PL handler function funcname - This is a template for a PL handler written in 'C': + This is a template for a PL handler written in C: #include "executor/spi.h" #include "commands/trigger.h" diff --git a/doc/src/sgml/ref/create_rule.sgml b/doc/src/sgml/ref/create_rule.sgml index 12be4c87e40..2717037aa89 100644 --- a/doc/src/sgml/ref/create_rule.sgml +++ b/doc/src/sgml/ref/create_rule.sgml @@ -1,5 +1,5 @@ @@ -71,7 +71,7 @@ CREATE RULE name AS ON Any SQL WHERE clause, new or - old can appear instead of an instance + old, can appear instead of an instance variable whenever an instance variable is permissible in SQL. @@ -81,7 +81,7 @@ CREATE RULE name AS ON Any SQL statement, new or - old can appear instead of an instance + old, can appear instead of an instance variable whenever an instance variable is permissible in SQL. @@ -133,7 +133,7 @@ CREATE The semantics of a rule is that at the time an individual instance is - accessed, inserted, updated, or deleted, there is a old instance (for + accessed, inserted, updated, or deleted, there is an old instance (for selects, updates and deletes) and a new instance (for inserts and updates). If the event @@ -190,7 +190,7 @@ ON UPDATE TO emp-1.salary WHERE emp-2.name = "Joe" condition part of the rule occurs. Alternately, the action part will be done - instead of the user command. In this later case, the + instead of the user command. In this latter case, the action can be the keyword NOTHING. diff --git a/doc/src/sgml/ref/create_sequence.sgml b/doc/src/sgml/ref/create_sequence.sgml index 00e90009488..4916b8b649b 100644 --- a/doc/src/sgml/ref/create_sequence.sgml +++ b/doc/src/sgml/ref/create_sequence.sgml @@ -1,5 +1,5 @@ @@ -109,7 +109,7 @@ CREATE SEQUENCE seqname [ INCREMENT The option enables sequence numbers to be preallocated and stored in memory for faster access. The minimum - value is 1 (only one value can be generated at a time, i.e. no cache) + value is 1 (only one value can be generated at a time, i.e., no cache) and this is also the default. diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 8a56bae48b7..2610d04c466 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ @@ -123,7 +123,7 @@ CREATE [ TEMPORARY | TEMP ] TABLE tablecolumn (a table constraint) and PRIMARY KEY (a column constraint) - are mutually exclusive.. See the table constraint clause for + are mutually exclusive. See the table constraint clause for more information. @@ -177,7 +177,7 @@ ERROR ERROR: Relation 'table' already exists - which occurs at runtime, if the table specified already exists + , which occurs at runtime if the table specified already exists in the database. @@ -696,7 +696,7 @@ ERROR: Cannot insert a duplicate key into a unique index. NOT NULL constraint, does not violate a UNIQUE constraint. (This deviates from the SQL92 definition, but is a more sensible convention. See the section on compatibility for more - details.). + details.) Each UNIQUE column constraint must name a column that is @@ -853,7 +853,7 @@ ERROR: Cannot insert a duplicate key into a unique index. - This occurs at run-time if one tries to insert a duplicate value into + This occurs at runtime if one tries to insert a duplicate value into a column subject to a PRIMARY KEY constraint. @@ -882,7 +882,7 @@ ERROR: Cannot insert a duplicate key into a unique index. Postgres automatically creates a unique index to assure - data integrity. (See CREATE INDEX statement) + data integrity (see CREATE INDEX statement). The PRIMARY KEY constraint should name a set of columns that is @@ -1157,7 +1157,7 @@ ERROR: name referential integrity values in a referenced column of a referenced table. - A value added to this column are matched against the values of the + A value added to this column is matched against the values of the referenced table and referenced column using the given match type. In addition, when the referenced column data is changed, actions are run upon this column's matching data. @@ -1420,8 +1420,8 @@ CREATE TABLE distributors ( Description The PRIMARY KEY constraint specifies a rule that a group of one - or more distinct columns of a table may contain only unique, - (non duplicate), non-null values. The column definitions of + or more distinct columns of a table may contain only unique + (nonduplicate), non-null values. The column definitions of the specified columns do not have to include a NOT NULL constraint to be included in a PRIMARY KEY constraint. @@ -1505,7 +1505,7 @@ CREATE TABLE distributors ( default match type if none is specified. MATCH FULL will not allow one column of a multi-column foreign key to be NULL unless all foreign key columns are NULL. The default MATCH type - allows a some foreign key columns to be NULL while other parts + allows some foreign key columns to be NULL while other parts of the foreign key are not NULL. MATCH PARTIAL is currently not supported. @@ -1696,7 +1696,7 @@ ERROR: name referential integrity Description The FOREIGN KEY constraint specifies a rule that a group of one - or more distinct columns of a table are related to a group + or more distinct columns of a table is related to a group of distinct columns in the referenced table. @@ -1853,7 +1853,7 @@ CREATE TABLE distributors ( SQL92 - In addition to the locally-visible temporary table, SQL92 also defines a + In addition to the locally visible temporary table, SQL92 also defines a CREATE GLOBAL TEMPORARY TABLE statement, and optionally an ON COMMIT clause: @@ -1981,7 +1981,7 @@ DEFAULT niladic_user_function | niladic_datetime_function | NULL - An assertion is a special type of integrity constraint and share + An assertion is a special type of integrity constraint and shares the same namespace as other constraints. However, an assertion is not necessarily dependent on one particular base table as constraints are, so SQL-92 provides the CREATE ASSERTION statement @@ -2052,10 +2052,10 @@ CREATE ASSERTION name CHECK ( condition< - - - SET CONSTRAINT changes the foreign key constraint mode only for - the current transaction. + + SET CONSTRAINT changes the foreign key constraint mode + only for the current transaction. + INITIALLY IMMEDIATE diff --git a/doc/src/sgml/ref/create_trigger.sgml b/doc/src/sgml/ref/create_trigger.sgml index c1b6e380298..c4fbe0203bf 100644 --- a/doc/src/sgml/ref/create_trigger.sgml +++ b/doc/src/sgml/ref/create_trigger.sgml @@ -1,5 +1,5 @@ @@ -119,7 +119,7 @@ CREATE operation is attempted on a tuple (before constraints are checked and the INSERT, UPDATE or DELETE is attempted) or - AFTER the operation has been attempted (e.g. after constraints + AFTER the operation has been attempted (e.g., after constraints are checked and the INSERT, UPDATE or DELETE has completed). If the diff --git a/doc/src/sgml/ref/create_type.sgml b/doc/src/sgml/ref/create_type.sgml index c921c78d567..095a630a73d 100644 --- a/doc/src/sgml/ref/create_type.sgml +++ b/doc/src/sgml/ref/create_type.sgml @@ -1,5 +1,5 @@ @@ -237,7 +237,7 @@ CREATE in which case Postgres assumes that the new type has the same format as the Postgres-supplied data type, "text". - To indicate that a type is variable-length, set + To indicate that a type is variable length, set internallength to . The external representation is similarly specified using the @@ -249,7 +249,7 @@ CREATE To indicate that a type is an array and to indicate that a type has array elements, indicate the type of the array element using the element keyword. For example, to define - an array of 4 byte integers ("int4"), specify + an array of 4-byte integers ("int4"), specify ELEMENT = int4 diff --git a/doc/src/sgml/ref/declare.sgml b/doc/src/sgml/ref/declare.sgml index 803949a1eaa..0e0f41ecaaa 100644 --- a/doc/src/sgml/ref/declare.sgml +++ b/doc/src/sgml/ref/declare.sgml @@ -1,5 +1,5 @@ @@ -40,7 +40,7 @@ DECLARE cursorname [ BINARY ] [ INS cursorname - The name of the cursor to be used in subsequent FETCH operations.. + The name of the cursor to be used in subsequent FETCH operations. @@ -96,7 +96,7 @@ DECLARE cursorname [ BINARY ] [ INS SQL92 keyword indicating that the cursor will be used - in a readonly mode. Since this is the only cursor access mode + in a read only mode. Since this is the only cursor access mode available in Postgres this keyword has no effect. @@ -227,7 +227,7 @@ ERROR: Named portals may only be used in begin/end transaction blocks and Postgres does not resolve byte ordering or representation issues for binary cursors. Therefore, if your client machine and server machine use different - representations (e.g. "big-endian" versus "little-endian"), + representations (e.g., "big-endian" versus "little-endian"), you will probably not want your data returned in binary format. However, binary cursors may be a @@ -306,7 +306,7 @@ DECLARE liahona CURSOR interactively. SQL92 allows embedded or modular cursors to update database information. - All Postgres cursors are readonly. + All Postgres cursors are read only. The BINARY keyword is a Postgres extension. diff --git a/doc/src/sgml/ref/drop_database.sgml b/doc/src/sgml/ref/drop_database.sgml index 363a4ab5cc7..13007e9cb91 100644 --- a/doc/src/sgml/ref/drop_database.sgml +++ b/doc/src/sgml/ref/drop_database.sgml @@ -1,5 +1,5 @@ @@ -91,7 +91,7 @@ DROP DATABASE name ERROR: dropdb: cannot be executed on an open database - You cannot be connected to the the database your are about to remove. + You cannot be connected to the database your are about to remove. Instead, you could connect to template1 or any other database and run this command again. diff --git a/doc/src/sgml/ref/drop_operator.sgml b/doc/src/sgml/ref/drop_operator.sgml index e97c74fe476..6c707960b56 100644 --- a/doc/src/sgml/ref/drop_operator.sgml +++ b/doc/src/sgml/ref/drop_operator.sgml @@ -1,5 +1,5 @@ @@ -92,7 +92,7 @@ ERROR: RemoveOperator: left unary operator 'oper - This message occurs if the specified left unary operator + This message occurs if the left unary operator specified does not exist. @@ -103,7 +103,7 @@ ERROR: RemoveOperator: right unary operator 'ope - This message occurs if the specified right unary operator + This message occurs if the right unary operator specified does not exist. diff --git a/doc/src/sgml/ref/drop_rule.sgml b/doc/src/sgml/ref/drop_rule.sgml index cb14be418c9..597f7462af3 100644 --- a/doc/src/sgml/ref/drop_rule.sgml +++ b/doc/src/sgml/ref/drop_rule.sgml @@ -1,5 +1,5 @@ @@ -62,7 +62,7 @@ DROP - Message returned if successfully. + Message returned if successful. diff --git a/doc/src/sgml/ref/ecpg-ref.sgml b/doc/src/sgml/ref/ecpg-ref.sgml index 474462638c7..a5e98e8cfdd 100644 --- a/doc/src/sgml/ref/ecpg-ref.sgml +++ b/doc/src/sgml/ref/ecpg-ref.sgml @@ -1,5 +1,5 @@ @@ -248,7 +248,7 @@ EXEC SQL INCLUDE sqlca; from C statements, sqlca (which includes the sqlca.h header file) MUST be lowercase. This is because the EXEC SQL prefix indicates that this INCLUDE will be parsed by ecpg. - ecpg observes case sensitivity (SQLCA.h will not be found.) + ecpg observes case sensitivity (SQLCA.h will not be found). EXEC SQL INCLUDE can be used to include other header files as long as case sensitivity is observed. diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml index c31935b3237..1786cd9a2e7 100644 --- a/doc/src/sgml/ref/explain.sgml +++ b/doc/src/sgml/ref/explain.sgml @@ -1,5 +1,5 @@ @@ -104,8 +104,8 @@ EXPLAIN This command displays the execution plan that the Postgres planner generates for the supplied query. The execution plan shows how - the table(s) referenced by the query will be scanned --- by plain - sequential scan, index scan etc --- and if multiple tables are + the table(s) referenced by the query will be scanned---by plain + sequential scan, index scan, etc.---and if multiple tables are referenced, what join algorithms will be used to bring together the required tuples from each input table. diff --git a/doc/src/sgml/ref/fetch.sgml b/doc/src/sgml/ref/fetch.sgml index cb5c33fdcb7..eb6f3ddd549 100644 --- a/doc/src/sgml/ref/fetch.sgml +++ b/doc/src/sgml/ref/fetch.sgml @@ -1,5 +1,5 @@ @@ -42,7 +42,7 @@ FETCH [ FORWARD | BACKWARD | RELATIVE ] [ # selector - defines the fetch direction. It can be one + defines the fetch direction. It can be one of the following: @@ -88,7 +88,7 @@ FETCH [ FORWARD | BACKWARD | RELATIVE ] [ ## - A signed integer that specify how many rows to fetch. + A signed integer that specifies how many rows to fetch. Note that a negative integer is equivalent to changing the sense of FORWARD and BACKWARD. @@ -190,7 +190,7 @@ ERROR: FETCH/RELATIVE at current position is not supported SQL92 allows one to repetitively retrieve the cursor at its "current position" using the syntax -FETCH RELATIVE 0 FROM cursor +FETCH RELATIVE 0 FROM cursor. @@ -198,7 +198,7 @@ FETCH RELATIVE 0 FROM cursor Postgres does not currently support this notion; in fact the value zero is reserved to indicate that all rows should be retrieved and is equivalent to specifying the ALL keyword. - If the RELATIVE keyword has been used, the Postgres + If the RELATIVE keyword has been used, Postgres assumes that the user intended SQL92 behavior and returns this error message. @@ -295,7 +295,7 @@ FETCH RELATIVE 0 FROM cursor The following examples traverses a table using a cursor. --- set up and use a cursor: +-- Set up and use a cursor: BEGIN WORK; DECLARE liahona CURSOR FOR SELECT * FROM films; diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index de406f798ba..9770c3dd542 100644 --- a/doc/src/sgml/ref/grant.sgml +++ b/doc/src/sgml/ref/grant.sgml @@ -1,5 +1,5 @@ @@ -161,7 +161,7 @@ GRANT privilege [, ...] ON - The name of a user to whom grant privileges. PUBLIC is a short form + The name of a user to whom to grant privileges. PUBLIC is a short form representing all users. @@ -242,7 +242,7 @@ ERROR: ChangeAcl: class "object" n Currently, to grant privileges in Postgres - to only few columns, you must + to only a few columns, you must create a view having desired columns and then grant privileges to that view. @@ -325,7 +325,7 @@ GRANT privilege [, ...] - Fields are compatible with the those in the Postgres + Fields are compatible with those in the Postgres implementation, with the following additions: diff --git a/doc/src/sgml/ref/initdb.sgml b/doc/src/sgml/ref/initdb.sgml index 2ee434511b9..0c2204157d8 100644 --- a/doc/src/sgml/ref/initdb.sgml +++ b/doc/src/sgml/ref/initdb.sgml @@ -1,5 +1,5 @@ @@ -148,7 +148,7 @@ initdb [ --pgdata|-D dbdir ] By default, when initdb - determines that error prevent it from completely creating the database + determines that an error prevented it from completely creating the database system, it removes any files it may have created before determining that it can't finish the job. This option inhibits any tidying-up and is thus useful for debugging. @@ -212,7 +212,7 @@ initdb [ --pgdata|-D dbdir ] database. When you create a new database, everything in the template1 database is copied. It contains catalog tables filled in for things like the - builtin types. + built-in types. @@ -220,7 +220,8 @@ initdb [ --pgdata|-D dbdir ] because you cannot run the database server as root either, but the server needs to have access to the files initdb creates. Furthermore, during the initialization phase, when there are no - users and no access controls installed, postgres will only connect with + users and no access controls installed, Postgres + will only connect with the name of the current Unix user, so you must log in under the account that will own the server process. diff --git a/doc/src/sgml/ref/initlocation.sgml b/doc/src/sgml/ref/initlocation.sgml index 3f0bbad5793..c4c2d182ae9 100644 --- a/doc/src/sgml/ref/initlocation.sgml +++ b/doc/src/sgml/ref/initlocation.sgml @@ -1,5 +1,5 @@ @@ -80,7 +80,7 @@ initlocation directory In order to use this command you must be logged in (using 'su', for example) - the database superuser. + as the database superuser. diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index 3fad81efdd6..a265ebaba43 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -1,5 +1,5 @@ @@ -130,7 +130,7 @@ INSERT 0 # INSERT allows one to insert new rows into a class or table. One can insert - a single row at time or several rows as a result of a query. + a single row at a time or several rows as a result of a query. The columns in the target list may be listed in any order. diff --git a/doc/src/sgml/ref/ipcclean.sgml b/doc/src/sgml/ref/ipcclean.sgml index 6063c332937..22e94a85de2 100644 --- a/doc/src/sgml/ref/ipcclean.sgml +++ b/doc/src/sgml/ref/ipcclean.sgml @@ -1,5 +1,5 @@ @@ -80,7 +80,7 @@ semget: No space left on device is running, the shared memory and semaphores allocated by the postmaster will be deleted. This will result in a general failure of the - backends servers started by that + backend servers started by that postmaster. diff --git a/doc/src/sgml/ref/lock.sgml b/doc/src/sgml/ref/lock.sgml index 07d415f8fb2..32a8e2d0c95 100644 --- a/doc/src/sgml/ref/lock.sgml +++ b/doc/src/sgml/ref/lock.sgml @@ -1,5 +1,5 @@ @@ -74,7 +74,7 @@ LOCK [ TABLE ] name IN SHARE ROW EX Automatically acquired by SELECT...FOR UPDATE. - While it is a shared lock, may be upgrade later to a ROW EXCLUSIVE lock. + While it is a shared lock, may be upgraded later to a ROW EXCLUSIVE lock. @@ -170,7 +170,7 @@ LOCK [ TABLE ] name IN SHARE ROW EX This lock mode is also acquired by an unqualified - LOCK TABLE (i.e. the command without an explicit + LOCK TABLE (i.e., the command without an explicit lock mode option). @@ -230,7 +230,7 @@ ERROR name: Table does not exist. for the duration of a transaction. Postgres always uses the least restrictive lock mode whenever possible. LOCK TABLE - provided for cases when you might need more restrictive locking. + provides for cases when you might need more restrictive locking. @@ -298,7 +298,7 @@ ERROR name: Table does not exist. To read data in their real current state when running a transaction at the SERIALIZABLE isolation level you have to execute a LOCK TABLE - statement before execution any DML statement, when the transaction defines + statement before executing any DML statement, when the transaction defines what concurrent changes will be visible to itself. @@ -306,15 +306,15 @@ ERROR name: Table does not exist. In addition to the requirements above, if a transaction is going to - change data in a table then SHARE ROW EXCLUSIVE lock mode should + change data in a table, then SHARE ROW EXCLUSIVE lock mode should be acquired to prevent deadlock conditions when two concurrent transactions attempt to lock the table in SHARE mode and then try to change data in this table, both (implicitly) acquiring - ROW EXCLUSIVE lock mode that conflicts with concurrent SHARE lock. + ROW EXCLUSIVE lock mode that conflicts with a concurrent SHARE lock. - To continue with the deadlock (when two transaction wait one another) + To continue with the deadlock (when two transaction wait for one another) issue raised above, you should follow two general rules to prevent deadlock conditions: @@ -337,7 +337,7 @@ ERROR name: Table does not exist. Transactions should acquire two conflicting lock modes only if - one of them is self-conflicting (i.e. may be held by one + one of them is self-conflicting (i.e., may be held by one transaction at time only). If multiple lock modes are involved, then transactions should always acquire the most restrictive mode first. diff --git a/doc/src/sgml/ref/notify.sgml b/doc/src/sgml/ref/notify.sgml index ca22f29e606..0e5748a736f 100644 --- a/doc/src/sgml/ref/notify.sgml +++ b/doc/src/sgml/ref/notify.sgml @@ -1,5 +1,5 @@ @@ -136,7 +136,7 @@ NOTIFY the notify event will not be delivered to its connected frontend until just after the transaction is completed (either committed or aborted). Again, the reasoning is that if a notify were delivered within a transaction that was - later aborted, one would want the notification to be undone somehow --- but + later aborted, one would want the notification to be undone somehow---but the backend cannot "take back" a notify once it has sent it to the frontend. So notify events are only delivered between transactions. The upshot of this is that applications using NOTIFY for real-time signaling @@ -156,7 +156,7 @@ NOTIFY It is common for a frontend that sends NOTIFY to be listening on the same notify name itself. In that case it will get back a notify event, just like all the other listening frontends. Depending on the - application logic, this could result in useless work --- for example, + application logic, this could result in useless work---for example, re-reading a database table to find the same updates that that frontend just wrote out. In Postgres 6.4 and later, it is possible to avoid such extra work by noticing whether the notifying backend diff --git a/doc/src/sgml/ref/pg_ctl-ref.sgml b/doc/src/sgml/ref/pg_ctl-ref.sgml new file mode 100644 index 00000000000..0e367e4ccc4 --- /dev/null +++ b/doc/src/sgml/ref/pg_ctl-ref.sgml @@ -0,0 +1,414 @@ + + + + + + pg_ctl + + Application + + + + + pg_ctl + + + Starts, stops, and restarts postmaster + + + + + + 2000-04-05 + + + +pg_ctl [-w] [-D datadir][-p path] [-o "options"] start +pg_ctl [-w] [-D datadir] [-m [s[mart]|f[ast]|i[mmediate]]] stop +pg_ctl [-w] [-D datadir] [-m [s[mart]|f[ast]|i[mmediate]] + [-o "options"] restart +pg_ctl [-D datadir] status + + + + + Inputs + + + + + + -w + + + Wait for the database server to come up, by + watching for creation of the pid file (PGDATA/postmaster.pid). + Times out after 60 seconds. + + + + + + -D datadir + + + Specifies the database location for this database installation. + + + + + + -p path + + + Specifies the path to the postmaster image. + + + + + + -o "options" + + + Specifies options to be passed directly to + postmaster. + + + The parameters are usually surrounded by single or double + quotes to ensure that they are passed through as a group. + + + + + + -m mode + + + Specifies the shutdown mode. + + + + smart + s + + + smart mode waits for all + the clients to logout. This is the default. + + + + + + fast + f + + + Fast mode sends SIGTERM to the backends; that means + active transactions get rolled back. + + + + + + immediate + i + + + Immediate mode sends SIGUSR1 + to the backends and lets them abort. In this case, database recovery + will be necessary on the next start-up. + + + + + + + + + + start + + + Start up postmaster. + + + + + + stop + + + Shut down postmaster. + + + + + + restart + + + Restart the postmaster, performing + a stop/start sequence. + + + + + + status + + + Show the current state of postmaster. + + + + + + + + + + 1999-11-07 + + + Outputs + + + + + pg_ctl: postmaster is state (pid: #) + + + Postmaster status. + + + + + + If there is an error condition, the backend error message will be displayed. + + + + + + + Description + + + pg_ctl is a utility for starting, + stopping or restarting postmaster. + + + + + + Usage + + + + + Starting postmaster + + + + To start up postmaster: + + +$ pg_ctl start + + + + + If -w is supplied, pg_ctl waits for the database server to come up, by + watching for creation of the pid file (PGDATA/postmaster.pid), for up + to 60 seconds. + + + + Parameters to invoke postmaster are + taken from the following sources: + + + + + Path to postmaster: found in the command search path. + + + + + + Database directory: PGDATA environment variable. + + + + + + Other parameters: + PGDATA/postmaster.opts.default. + + + + + + + postmaster.opts.default contains parameters + for postmaster. + + + + Note that postmaster.opts.default is + installed by initdb from + lib/postmaster.opts.default.sample + under the Postgres installation + directory (lib/postmaster.opts.default.sample + is copied from + src/bin/pg_ctl/postmaster.opts.default.sample + while installing Postgres). + + + + To override the default parameters you can use , + and options. + + + + An example of starting the + postmaster, blocking until + postmaster comes up is: + +$ pg_ctl -w start + + + + + To specify the postmaster binary path, + try: + + +$ pg_ctl -p /usr/local/pgsq/bin/postmaster start + + + + + For a postmaster using port 5433, and + running without fsync, use: + + +$ pg_ctl -o "-o -F -p 5433" start + + + + + + + Stopping postmaster + + + + +$ pg_ctl stop + + + stops postmaster. Using the switch allows one + to control how the backend shuts down. + + waits for postmaster to shut down. + specifies the shut down mode. + + + + + + Restarting postmaster + + + + This is almost equivalent to stopping the + postmaster then starting it + again except that the parameters used before stopping + it would be used too. This is done by saving them in + $PGDATA/postmaster.opts file. + , , , + , and + + can also be used in the restarting mode and they have the same meanings as + described above. + + + + To restart postmaster in the simplest + form: + + +$ pg_ctl restart + + + + + To restart postmaster, + waiting for it to shut down and to come up: + + +$ pg_ctl -w restart + + + + + To restart using port 5433 and disabling fsync after restarting: + + +$ pg_ctl -o "-o -F -p 5433" restart + + + + + + + postmaster status + + + + To get status information from postmaster: + + +$ pg_ctl status + + + + + Here is a sample output from pg_ctl: + + +pg_ctl: postmaster is running (pid: 13718) +options are: +/usr/local/src/pgsql/current/bin/postmaster +-p 5433 +-D /usr/local/src/pgsql/current/data +-B 64 +-b /usr/local/src/pgsql/current/bin/postgres +-N 32 +-o '-F' + + + + + + + diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index ac853761c2b..f0d1facfca2 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -1,5 +1,5 @@ @@ -69,7 +69,7 @@ pg_dump [ -h host ] [ -p -c - Clean(drop) schema prior to create. + Clean (drop) schema prior to create. @@ -171,7 +171,7 @@ pg_dump [ -h host ] [ -p -v - Specifies verbose mode + Specifies verbose mode. @@ -199,7 +199,7 @@ pg_dump [ -h host ] [ -p postmaster is running. Defaults to using a local Unix domain socket - rather than an IP connection.. + rather than an IP connection. diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml index 33d64e9e655..02bf45e4050 100644 --- a/doc/src/sgml/ref/pg_dumpall.sgml +++ b/doc/src/sgml/ref/pg_dumpall.sgml @@ -1,5 +1,5 @@ @@ -106,7 +106,7 @@ pg_dumpall [ -h host ] [ -p -v - Specifies verbose mode + Specifies verbose mode. diff --git a/doc/src/sgml/ref/pgaccess-ref.sgml b/doc/src/sgml/ref/pgaccess-ref.sgml index 7fc553fea70..04a9e116eb8 100644 --- a/doc/src/sgml/ref/pgaccess-ref.sgml +++ b/doc/src/sgml/ref/pgaccess-ref.sgml @@ -1,5 +1,5 @@ @@ -80,7 +80,7 @@ pgaccess [ dbname ] - Opens any database on a specified host at the specified port, + Open any database on a specified host at the specified port, username and password. @@ -93,7 +93,7 @@ pgaccess [ dbname ] - Saves preferences in ~/.pgaccessrc file. + Save preferences in ~/.pgaccessrc file. @@ -213,10 +213,10 @@ pgaccess [ dbname ] - Execute with optional user input parameters; e.g. + Execute with optional user input parameters; e.g., select * from invoices where year=[parameter "Year of selection"] - + . diff --git a/doc/src/sgml/ref/pgctl-ref.sgml b/doc/src/sgml/ref/pgctl-ref.sgml deleted file mode 100644 index 4b0e81b4489..00000000000 --- a/doc/src/sgml/ref/pgctl-ref.sgml +++ /dev/null @@ -1,414 +0,0 @@ - - - - - - pg_ctl - - Application - - - - - pg_ctl - - - Starts, stops, and restarts postmaster - - - - - - 2000-04-05 - - - -pg_ctl [-w] [-D datadir][-p path] [-o "options"] start -pg_ctl [-w] [-D datadir] [-m [s[mart]|f[ast]|i[mmediate]]] stop -pg_ctl [-w] [-D datadir] [-m [s[mart]|f[ast]|i[mmediate]] - [-o "options"] restart -pg_ctl [-D datadir] status - - - - - Inputs - - - - - - -w - - - Wait for the database server comes up, by - watching for creation of the pid file (PGDATA/postmaster.pid). - Times out after 60 seconds. - - - - - - -D datadir - - - Specifies the database location for this database installation. - - - - - - -p path - - - Specifies the path to the postmaster image. - - - - - - -o "options" - - - Specifies options to be passed directly to - postmaster. - - - The parameters are usually surrounded by single- or double - quotes to ensure that they are passed through as a group. - - - - - - -m mode - - - Specifies the shutdown mode. - - - - smart - s - - - smart mode waits for all - the clients to logout. This is the default. - - - - - - fast - f - - - Fast mode sends SIGTERM to the backends, that means - active transactions get rolled back. - - - - - - immediate - i - - - Immediate mode sends SIGUSR1 - to the backends and lets them abort. In this case, database recovery - will be necessary on the next start-up. - - - - - - - - - - start - - - Start up postmaster. - - - - - - stop - - - Shut down postmaster. - - - - - - restart - - - Restart the postmaster, performing - a stop/start sequence. - - - - - - status - - - Show the current state of postmaster. - - - - - - - - - - 1999-11-07 - - - Outputs - - - - - pg_ctl: postmaster is state (pid: #) - - - Postmaster status. - - - - - - If there is an error condition, the backend error message will be displayed. - - - - - - - Description - - - pg_ctl is a utility for starting, - stopping or restarting postmaster. - - - - - - Usage - - - - - Starting postmaster - - - - To start up postmaster: - - -$ pg_ctl start - - - - - If -w is supplied, pg_ctl waits for the database server comes up, by - watching for creation of the pid file (PGDATA/postmaster.pid), for up - to 60 seconds. - - - - Parameters to invoke postmaster are - taken from the following sources: - - - - - Path to postmaster: found in the command search path. - - - - - - Database directory: PGDATA environment variable. - - - - - - Other parameters: - PGDATA/postmaster.opts.default. - - - - - - - postmaster.opts.default contains parameters - for postmaster. - - - - Note that postmaster.opts.default is - installed by initdb from - lib/postmaster.opts.default.sample - under the Postgres installation - directory (lib/postmaster.opts.default.sample - is copied from - src/bin/pg_ctl/postmaster.opts.default.sample - while installing Postgres). - - - - To override the default parameters you can use , - and options. - - - - An example of starting the - postmaster, blocking until - postmaster comes up is: - -$ pg_ctl -w start - - - - - To specify the postmaster binary path, - try: - - -$ pg_ctl -p /usr/local/pgsq/bin/postmaster start - - - - - For a postmaster using port 5433, and - running without fsync, use: - - -$ pg_ctl -o "-o -F -p 5433" start - - - - - - - Stopping postmaster - - - - -$ pg_ctl stop - - - stops postmaster. Using the switch allows one - to control how the backend shuts down. - - waits for postmaster to shut down. - specifies the shut down mode. - - - - - - Restarting postmaster - - - - This is almost equivalent to stopping the - postmaster then starting it - again except that the parameters used before stopping - it would be used too. This is done by saving them in - $PGDATA/postmaster.opts file. - , , , - , and - - can also be used in the restarting mode and they have same meanings as - described above. - - - - To restart postmaster in the simplest - form: - - -$ pg_ctl restart - - - - - To restart postmaster, - waiting for it to shut down and to come up: - - -$ pg_ctl -w restart - - - - - To restart using port 5433 and disabling fsync after restarting: - - -$ pg_ctl -o "-o -F -p 5433" restart - - - - - - - postmaster status - - - - To get status information from postmaster: - - -$ pg_ctl status - - - - - Here is a sample output from pg_ctl: - - -pg_ctl: postmaster is running (pid: 13718) -options are: -/usr/local/src/pgsql/current/bin/postmaster --p 5433 --D /usr/local/src/pgsql/current/data --B 64 --b /usr/local/src/pgsql/current/bin/postgres --N 32 --o '-F' - - - - - - - diff --git a/doc/src/sgml/ref/postgres-ref.sgml b/doc/src/sgml/ref/postgres-ref.sgml index 7650ddd9457..4f795665390 100644 --- a/doc/src/sgml/ref/postgres-ref.sgml +++ b/doc/src/sgml/ref/postgres-ref.sgml @@ -1,5 +1,5 @@ @@ -325,7 +325,7 @@ postgres [ -B nBuffers ] [ -C ] [ - Indicates to the backend server that it has been started by a postmaster - and make different assumptions about buffer pool management, file + and makes different assumptions about buffer pool management, file descriptors, etc. Switches following -p are restricted to those considered "secure". diff --git a/doc/src/sgml/ref/postmaster.sgml b/doc/src/sgml/ref/postmaster.sgml index dda77314c80..eba01b30d4d 100644 --- a/doc/src/sgml/ref/postmaster.sgml +++ b/doc/src/sgml/ref/postmaster.sgml @@ -1,5 +1,5 @@ @@ -173,7 +173,7 @@ postmaster [ -B nBuffers ] [ -D PGPORT is not set, then defaults to the value established when Postgres was compiled (normally 5432). If you specify a port other than the - default port then all frontend applications (including + default port, then all frontend applications (including psql) must specify the same port using either command-line options or PGPORT. diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 14eea7324df..c91420342e0 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -1,5 +1,5 @@ @@ -72,7 +72,7 @@ Postgres documentation If an argument is found that does not belong to any option it will be interpreted as the database name (or the user name, if the database name is also given). Not all these options are required, defaults do apply. - If you omit the host name psql will connect via a UNIX domain socket + If you omit the host name psql will connect via a Unix domain socket to a server on the local host. The default port number is compile-time determined. Since the database server uses the same default, you will not have to specify the port in most @@ -153,8 +153,8 @@ testdb=> The format of a psql command is the backslash, followed immediately by a command verb, then any arguments. The arguments - are separated from the command verb and each other by any number of white - space characters. + are separated from the command verb and each other by any number of + whitespace characters. @@ -252,7 +252,7 @@ testdb=> - If the connection attempt failed (wrong username, access denied, etc.) the + If the connection attempt failed (wrong username, access denied, etc.), the previous connection will be kept if and only if psql is in interactive mode. When executing a non-interactive script, processing will immediately stop with an error. This distinction was chosen as a user @@ -405,7 +405,7 @@ testdb=> If pattern (a regular expression) is specified, only matching functions are shown. If the form \df+ is used, additional information about - each function, including language and description is shown. + each function, including language and description, is shown. @@ -424,7 +424,7 @@ testdb=> If pattern is specified, - it is a regular expression restricts the listing to those objects + it is a regular expression that restricts the listing to those objects whose name matches. If one appends a + to the command name, each object is listed with its associated description, if any. @@ -741,7 +741,7 @@ lo_import 152801 Saves future query results to the file - filename or pipe future + filename or pipes future results into a separate Unix shell to execute command. If no arguments are specified, the query output will be reset to @@ -1174,7 +1174,7 @@ Access permissions for database "test" \? - Get help information about the slash (\) commands. + Get help information about the backslash (\) commands. @@ -1288,7 +1288,7 @@ Access permissions for database "test" Use the file filename as the source of queries instead of reading queries interactively. After the file is processed, psql terminates. - This in many ways equivalent to the internal command \i. + This is in many ways equivalent to the internal command \i. Using this option is subtly different from writing @@ -1772,8 +1772,8 @@ bar documentation of the large object interface for more information.) Since psql has no way to tell if you already have a transaction in progress when you call one of its internal - commands \lo_export, \lo_import, - \lo_unlink it must take some arbitrary action. This + commands (\lo_export, \lo_import, + \lo_unlink) it must take some arbitrary action. This action could either be to roll back any transaction that might already be in progress, or to commit any such transaction, or to do nothing at all. In the last case you must provide your own @@ -1900,7 +1900,7 @@ testdb=> SELECT * FROM :foo; A popular application of this facility is to refer to the last inserted - OID in subsequent statement to build a foreign key + OID in subsequent statements to build a foreign key scenario. Another possible use of this mechanism is to copy the contents of a file into a field. First load the file into a variable and then proceed as above. @@ -2021,7 +2021,7 @@ testdb=> \set content `sed -e "s/'/\\\\\\'/g" < my_file.txt`%digits If digits starts with - 0x the rest of the characters are interpreted at a + 0x the rest of the characters are interpreted as a hexadecimal digit and the character with the corresponding code is substituted. If the first digit is 0 the characters are interpreted as on octal number and the corresponding character is @@ -2184,7 +2184,6 @@ peter@localhost testdb=> SELECT * FROM my_table; (4 rows) - Notice how the int4 columns in right aligned while the text column in left aligned. You can make this table look differently by using the \pset command: @@ -2271,9 +2270,9 @@ second | four if you get strange messages, keep this in mind. For example testdb=> \foo -Field separator is "oo". +Field separator is "oo", - is perhaps not what one would expect. + which is perhaps not what one would expect. diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml index 51c4e77c1e9..6e5722ae85f 100644 --- a/doc/src/sgml/ref/reindex.sgml +++ b/doc/src/sgml/ref/reindex.sgml @@ -1,5 +1,5 @@ @@ -115,9 +115,9 @@ REINDEX REINDEX is used to recover corrupted system indexes. - In order to run REINDEX command,Postmaster must be shutdown and + In order to run REINDEX command, postmaster must be shut down and stand-alone Postgres should be started instead with options -O and - -P(an option to ignore system indexes). Note that we couldn't rely + -P (an option to ignore system indexes). Note that we couldn't rely on system indexes for the recovery of system indexes. diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml index 23d1da2ae12..88ef05aeb03 100644 --- a/doc/src/sgml/ref/revoke.sgml +++ b/doc/src/sgml/ref/revoke.sgml @@ -1,5 +1,5 @@ @@ -375,8 +375,8 @@ REVOKE GRANT OPTION FOR privilege [ If user1 gives a privilege WITH GRANT OPTION to user2, - and user2 gives it to user3 then if user1 try revoke - this privilege it fails if he/she specify the RESTRICT + and user2 gives it to user3, then if user1 tries revoke + this privilege it fails if he specify the RESTRICT keyword. diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 5ca738796ed..6977d10164e 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -1,5 +1,5 @@ @@ -321,7 +321,7 @@ WHERE boolean_expr where cond_op can be one of: =, <, <=, >, >= or <>, a conditional operator like ALL, ANY, IN, LIKE, or a - locally-defined operator, + locally defined operator, and log_op can be one of: AND, OR, NOT. SELECT will ignore all rows for which the WHERE condition does not return @@ -584,7 +584,7 @@ SELECT name FROM distributors ORDER BY code; When using LIMIT, it is a good idea to use an ORDER BY clause that constrains the result rows into a unique order. Otherwise you will get - an unpredictable subset of the query's rows --- you may be asking for + an unpredictable subset of the query's rows---you may be asking for the tenth through twentieth rows, but tenth through twentieth in what ordering? You don't know what ordering, unless you specified ORDER BY. diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml index 605fbebcaad..a614143a42c 100644 --- a/doc/src/sgml/ref/set.sgml +++ b/doc/src/sgml/ref/set.sgml @@ -1,5 +1,5 @@ @@ -236,13 +236,13 @@ SELECT setseed(value); TIMEZONE - The possible values for timezone depends on your operating + The possible values for time zone depends on your operating system. For example, on Linux /usr/share/zoneinfo contains the database of time zones. - Here are some valid values for timezone: + Here are some valid values for time zone: @@ -362,7 +362,7 @@ SELECT setseed(value); SET DATESTYLE TO Postgres,European; - Set the timezone for Berkeley, California, using double quotes to + Set the time zone for Berkeley, California, using double quotes to preserve the uppercase attributes of the time zone specifier (note that the date/time format is ISO here): @@ -375,7 +375,7 @@ SELECT CURRENT_TIMESTAMP AS today; 1998-03-31 07:41:21-08 - Set the timezone for Italy (note the required single or double quotes to handle + Set the time zone for Italy (note the required single or double quotes to handle the special characters): diff --git a/doc/src/sgml/ref/unlisten.sgml b/doc/src/sgml/ref/unlisten.sgml index 7cbba21120d..74305cba60c 100644 --- a/doc/src/sgml/ref/unlisten.sgml +++ b/doc/src/sgml/ref/unlisten.sgml @@ -1,5 +1,5 @@ @@ -72,7 +72,7 @@ UNLISTEN { notifyname | * } - Acknowledgement that statement has executed. + Acknowledgment that statement has executed. @@ -115,7 +115,7 @@ UNLISTEN { notifyname | * } classname - needs not to be a valid class name but can be any string valid + need not be a valid class name but can be any string valid as a name up to 32 characters long. diff --git a/doc/src/sgml/ref/vacuum.sgml b/doc/src/sgml/ref/vacuum.sgml index a61f48ca797..3928408a4a3 100644 --- a/doc/src/sgml/ref/vacuum.sgml +++ b/doc/src/sgml/ref/vacuum.sgml @@ -1,5 +1,5 @@ @@ -159,7 +159,7 @@ NOTICE: Index index: Pages 28; VACUUM ANALYZE collects statistics representing the - disbursion of the data in each column. + dispersion of the data in each column. This information is valuable when several query execution paths are possible. diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml index 9a7bc3e5880..8383fa1bdc6 100644 --- a/doc/src/sgml/release.sgml +++ b/doc/src/sgml/release.sgml @@ -1,5 +1,5 @@ @@ -2388,7 +2388,7 @@ enclose unused functions in #ifdef NOT_USED(Bruce) Remove call to difftime() in timestamp support to fix SunOS(Bruce & Thomas) Changes for Digital Unix Portability fix for pg_dumpall(Bruce) -Rename pg_attribute.attnvals to attdisbursion(Bruce) +Rename pg_attribute.attnvals to attdispersion(Bruce) "intro/unix" manual page now "pgintro"(Bruce) "built-in" manual page now "pgbuiltin"(Bruce) "drop" manual page now "drop_table"(Bruce) -- cgit v1.2.3