From 17f0b55d155716d7eb0489a838bf48394240accf Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Sun, 18 Nov 2001 20:35:02 +0000 Subject: [PATCH] Initial round of tweakage for man pages --- doc/src/sgml/Makefile | 6 +++--- doc/src/sgml/ref/alter_table.sgml | 14 +++++++------- doc/src/sgml/ref/create_function.sgml | 8 ++++---- doc/src/sgml/ref/create_language.sgml | 6 +++--- doc/src/sgml/ref/create_table.sgml | 10 +++++----- doc/src/sgml/ref/createdb.sgml | 4 ++-- doc/src/sgml/ref/ecpg-ref.sgml | 17 +++++++++++------ doc/src/sgml/ref/grant.sgml | 22 +++++++++++----------- doc/src/sgml/ref/load.sgml | 8 ++++---- doc/src/sgml/ref/pg_dump.sgml | 8 ++++---- doc/src/sgml/ref/revoke.sgml | 8 ++++---- doc/src/sgml/ref/set_session_auth.sgml | 7 +++---- 12 files changed, 61 insertions(+), 57 deletions(-) diff --git a/doc/src/sgml/Makefile b/doc/src/sgml/Makefile index 24870b518d0..8756602faca 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.44 2001/11/16 16:29:56 petere Exp $ +# $Header: /cvsroot/pgsql/doc/src/sgml/Makefile,v 1.45 2001/11/18 20:35:02 petere Exp $ # #---------------------------------------------------------------------------- @@ -67,10 +67,10 @@ DEFAULTSECTION := $(sqlmansect_dummy) man: $(ALLSGML) $(NSGMLS) $(NSGMLS_FLAGS) $(srcdir)/book-decl.sgml $(srcdir)/reference.sgml \ - | $(SGMLSPL) $(D2MSCRIPT) --lowercase --section $(DEFAULTSECTION) + | $(SGMLSPL) $(D2MSCRIPT) --lowercase --section $(DEFAULTSECTION) --date "`date '+%Y-%m-%d'`" # One more time, to resolve cross-references $(NSGMLS) $(NSGMLS_FLAGS) $(srcdir)/book-decl.sgml $(srcdir)/reference.sgml \ - | $(SGMLSPL) $(D2MSCRIPT) --lowercase --section $(DEFAULTSECTION) + | $(SGMLSPL) $(D2MSCRIPT) --lowercase --section $(DEFAULTSECTION) --date "`date '+%Y-%m-%d'`" $(mkinstalldirs) man1 man$(DEFAULTSECTION) mv *.1 man1/ mv *.$(DEFAULTSECTION) man$(DEFAULTSECTION)/ diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index b5be516c52e..73f07467cbe 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ @@ -161,14 +161,14 @@ ALTER TABLE table ALTER TABLE changes the definition of an existing table. The ADD COLUMN form adds a new column to the table - using the same syntax as . + using the same syntax as . The ALTER COLUMN SET/DROP DEFAULT forms allow you to set or remove the default for the column. Note that defaults only apply to subsequent INSERT commands; they do not cause rows already in the table to change. The ALTER COLUMN SET STATISTICS form allows you to set the statistics-gathering target for subsequent - operations. + operations. The RENAME clause causes the name of a table or column to change without changing any of the data contained in the affected table. Thus, the table or column will @@ -176,7 +176,7 @@ ALTER TABLE table executed. The ADD table constraint definition clause adds a new constraint to the table using the same syntax as . + linkend="SQL-CREATETABLE" endterm="SQL-CREATETABLE-TITLE">. The DROP CONSTRAINT constraint clause drops all constraints on the table (and its children) that match constraint. The OWNER clause changes the owner of the table to the user @@ -204,7 +204,7 @@ ALTER TABLE table You can use the SET DEFAULT form of ALTER TABLE to set the default later. (You may also want to update the already existing rows to the - new default value, using .) + new default value, using .) @@ -212,10 +212,10 @@ ALTER TABLE table dependencies are not yet checked. The CASCADE option is unsupported. Currently DROP CONSTRAINT drops only CHECK constraints. To remove a PRIMARY or UNIQUE constraint, drop the - relevant index using the command. + relevant index using the command. To remove FOREIGN KEY constraints you need to recreate and reload the table, using other parameters to the - command. + command. For example, to drop all constraints on a table distributors: diff --git a/doc/src/sgml/ref/create_function.sgml b/doc/src/sgml/ref/create_function.sgml index 543733620b9..5a4c49cb633 100644 --- a/doc/src/sgml/ref/create_function.sgml +++ b/doc/src/sgml/ref/create_function.sgml @@ -1,10 +1,10 @@ - CREATE FUNCTION + CREATE FUNCTION SQL - Language Statements @@ -130,7 +130,7 @@ CREATE [ OR REPLACE ] FUNCTION name class="parameter">plname, where plname is the name of a created procedural language. See - + for details. For backward compatibility, the name may be enclosed by single quotes. @@ -244,7 +244,7 @@ CREATE [ OR REPLACE ] FUNCTION name When repeated CREATE FUNCTION calls refer to the same object file, the file is only loaded once. To unload and reload the file (perhaps during development), use the command. + linkend="sql-load" endterm="sql-load-title"> command. diff --git a/doc/src/sgml/ref/create_language.sgml b/doc/src/sgml/ref/create_language.sgml index ad88c3f84c0..922e5275caf 100644 --- a/doc/src/sgml/ref/create_language.sgml +++ b/doc/src/sgml/ref/create_language.sgml @@ -1,5 +1,5 @@ @@ -177,12 +177,12 @@ ERROR: PL handler function funcname - Use the command to create a new + Use the command to create a new function. - Use , or better yet the , or better yet the script, to drop procedural languages. diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 8607f895df2..e583c188dd2 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,11 +1,11 @@ - CREATE TABLE + CREATE TABLE SQL - Language Statements @@ -448,7 +448,7 @@ and table_constraint is: constraint that is not deferrable will be checked immediately after every command. Checking of constraints that are deferrable may be postponed until the end of the transaction - (using the command). + (using the command). NOT DEFERRABLE is the default. Only foreign key constraints currently accept this clause. All other constraint types are not deferrable. @@ -466,7 +466,7 @@ and table_constraint is: statement. This is the default. If the constraint is INITIALLY DEFERRED, it is checked only at the end of the transaction. The constraint check time can be - altered with the command. + altered with the command. @@ -554,7 +554,7 @@ and table_constraint is: index for each unique constraint and primary key constraint to enforce the uniqueness. Thus, it is not necessary to create an explicit index for primary key columns. (See for more information.) + linkend="sql-createindex" endterm="sql-createindex-title"> for more information.) diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml index cd1426dea90..4149af6466a 100644 --- a/doc/src/sgml/ref/createdb.sgml +++ b/doc/src/sgml/ref/createdb.sgml @@ -1,5 +1,5 @@ @@ -192,7 +192,7 @@ Postgres documentation If there is an error condition, the backend error message will be displayed. - See + See and for possibilities. diff --git a/doc/src/sgml/ref/ecpg-ref.sgml b/doc/src/sgml/ref/ecpg-ref.sgml index eefc0ff5a9e..766f53c598a 100644 --- a/doc/src/sgml/ref/ecpg-ref.sgml +++ b/doc/src/sgml/ref/ecpg-ref.sgml @@ -1,5 +1,5 @@ @@ -23,9 +23,14 @@ Postgres documentation 1999-07-20 - -ecpg [ -v ] [ -t ] [ -I include-path ] [ -o outfile ] file1 [ file2 ] [ ... ] - + + ecpg + -v + -t + -I include-path + -o outfile + file + @@ -58,7 +63,7 @@ ecpg [ -v ] [ -t ] [ -I include-path ] [ -o outfile ] file1 [ file2 ] [ ... ] - -I path + -I include-path Specify an additional include path. @@ -73,7 +78,7 @@ ecpg [ -v ] [ -t ] [ -I include-path ] [ -o outfile ] file1 [ file2 ] [ ... ] - -o + -o outfile Specifies that ecpg should write all its output to outfile. diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml index 1cd7de8c9bc..fab1c758d00 100644 --- a/doc/src/sgml/ref/grant.sgml +++ b/doc/src/sgml/ref/grant.sgml @@ -1,11 +1,11 @@ - GRANT + GRANT SQL - Language Statements @@ -49,9 +49,9 @@ GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,.. SELECT - Allows from any column of the + Allows from any column of the specified table, view, or sequence. Also allows the use of - FROM. + FROM. @@ -60,8 +60,8 @@ GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,.. INSERT - Allows of a new row into the - specified table. Also allows TO. + Allows of a new row into the + specified table. Also allows TO. @@ -70,7 +70,7 @@ GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,.. UPDATE - Allows of any column of the + Allows of any column of the specified table. SELECT ... FOR UPDATE also requires this privilege (besides the SELECT privilege). For sequences, this @@ -84,7 +84,7 @@ GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,.. DELETE - Allows the of a row from the + Allows the of a row from the specified table. @@ -95,7 +95,7 @@ GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,.. Allows the creation of a rule on the table/view. (See statement). + linkend="sql-createrule" endterm="sql-createrule-title"> statement). @@ -116,7 +116,7 @@ GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,.. Allows the creation of a trigger on the specified table. (See - statement). + statement). @@ -177,7 +177,7 @@ GRANT { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,.. - The command is used to revoke access + The command is used to revoke access privileges. diff --git a/doc/src/sgml/ref/load.sgml b/doc/src/sgml/ref/load.sgml index 786f8dbcb7a..5368d9a926d 100644 --- a/doc/src/sgml/ref/load.sgml +++ b/doc/src/sgml/ref/load.sgml @@ -1,10 +1,10 @@ - LOAD + LOAD SQL - Language Statements @@ -29,12 +29,12 @@ LOAD 'filename' shared library file that has been changed since the backend first loaded it. To make use of the shared library, function(s) in it need to be declared using the command. + linkend="sql-createfunction" endterm="sql-createfunction-title"> command. The filename is specified in the same way as for shared library - names in ; in particular, one + names in ; in particular, one may rely on a search path and automatic addition of the system's standard shared library filename extension. See the Programmer's Guide for more detail. diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index e0f44e5c57b..61b0b26c93b 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -1,5 +1,5 @@ @@ -462,9 +462,9 @@ Postgres documentation \connect command. This command actually opens a new connection, which might require manual interaction (e.g., passwords). If you use the - , then + option, then pg_dump will instead output commands. This has + linkend="sql-set-session-authorization" endterm="sql-set-session-authorization-title"> commands. This has the same effect, but it requires that the user restoring the database from the generated script be a database superuser. This option effectively overrides the @@ -472,7 +472,7 @@ Postgres documentation - Since is a + Since is a standard SQL command, whereas \connect only works in , this option also enhances the theoretical portability of the output script. diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml index e1729b3d72a..afa75d851ee 100644 --- a/doc/src/sgml/ref/revoke.sgml +++ b/doc/src/sgml/ref/revoke.sgml @@ -1,11 +1,11 @@ - REVOKE + REVOKE SQL - Language Statements @@ -33,7 +33,7 @@ REVOKE { { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES | TRIGGER } [,. - See the description of the command for + See the description of the command for the meaning of the privilege types. @@ -76,7 +76,7 @@ REVOKE ALL PRIVILEGES ON kinds FROM manuel; SQL92 - The compatibility notes of the command + The compatibility notes of the command apply analogously to REVOKE. The syntax summary is: diff --git a/doc/src/sgml/ref/set_session_auth.sgml b/doc/src/sgml/ref/set_session_auth.sgml index faae220e1d6..09a94249b63 100644 --- a/doc/src/sgml/ref/set_session_auth.sgml +++ b/doc/src/sgml/ref/set_session_auth.sgml @@ -1,18 +1,17 @@ - + 2001-04-21 - SET SESSION AUTHORIZATION + SET SESSION AUTHORIZATION SQL - Language Statements SET SESSION AUTHORIZATION - set the session user identifier and the current user identifier - of the current session + set the session user identifier and the current user identifier of the current session -- 2.39.5