[trivial patch] Ellipsis whitespace in SQL docs

Поиск
Список
Период
Сортировка
От Christoph Berg
Тема [trivial patch] Ellipsis whitespace in SQL docs
Дата
Msg-id 20101129084301.GA3278@msgid.df7cb.de
обсуждение исходный текст
Ответы Re: [trivial patch] Ellipsis whitespace in SQL docs  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
Дерево обсуждения 
Hi,

here's a trivial patch:
Changed several occurrences of ",..." to ", ..." in SQL syntax to be
consistent with the rest.

diff --git a/doc/src/sgml/ref/alter_default_privileges.sgml b/doc/src/sgml/ref/alter_default_privileges.sgml
index e1aa293..c27466f 100644
*** a/doc/src/sgml/ref/alter_default_privileges.sgml
--- b/doc/src/sgml/ref/alter_default_privileges.sgml
*************** ALTER DEFAULT PRIVILEGES
*** 29,40 **** <phrase>where <replaceable class="parameter">abbreviated_grant_or_revoke</replaceable> is one
of:</phrase> GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER } 
!     [,...] | ALL [ PRIVILEGES ] }     ON TABLES     TO { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] [ WITH GRANT OPTION ]  GRANT { { USAGE | SELECT | UPDATE } 
!     [,...] | ALL [ PRIVILEGES ] }     ON SEQUENCES     TO { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] [ WITH GRANT OPTION ]  
--- 29,40 ---- <phrase>where <replaceable class="parameter">abbreviated_grant_or_revoke</replaceable> is one
of:</phrase> GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER } 
!     [, ...] | ALL [ PRIVILEGES ] }     ON TABLES     TO { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] [ WITH GRANT OPTION ]  GRANT { { USAGE | SELECT | UPDATE } 
!     [, ...] | ALL [ PRIVILEGES ] }     ON SEQUENCES     TO { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] [ WITH GRANT OPTION ]  
*************** GRANT { EXECUTE | ALL [ PRIVILEGES ] }
*** 44,57 ****  REVOKE [ GRANT OPTION FOR ]     { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER
}
!     [,...] | ALL [ PRIVILEGES ] }     ON TABLES     FROM { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...]     [ CASCADE | RESTRICT ]  REVOKE [ GRANT OPTION FOR ]
{{ USAGE | SELECT | UPDATE } 
!     [,...] | ALL [ PRIVILEGES ] }     ON SEQUENCES     FROM { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...]     [ CASCADE | RESTRICT ] 
--- 44,57 ----  REVOKE [ GRANT OPTION FOR ]     { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES | TRIGGER
}
!     [, ...] | ALL [ PRIVILEGES ] }     ON TABLES     FROM { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...]     [ CASCADE | RESTRICT ]  REVOKE [ GRANT OPTION FOR ]
{{ USAGE | SELECT | UPDATE } 
!     [, ...] | ALL [ PRIVILEGES ] }     ON SEQUENCES     FROM { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...]     [ CASCADE | RESTRICT ] 
diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml
index 082e2e8..72ecc45 100644
*** a/doc/src/sgml/ref/grant.sgml
--- b/doc/src/sgml/ref/grant.sgml
*************** PostgreSQL documentation
*** 22,44 ****  <refsynopsisdiv> <synopsis> GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES |
TRIGGER} 
!     [,...] | ALL [ PRIVILEGES ] }     ON { [ TABLE ] <replaceable class="PARAMETER">table_name</replaceable> [, ...]
       | ALL TABLES IN SCHEMA <replaceable class="PARAMETER">schema_name</replaceable> [, ...] }     TO { [ GROUP ]
<replaceableclass="PARAMETER">role_name</replaceable> | PUBLIC } [, ...] [ WITH GRANT OPTION ]  GRANT { { SELECT |
INSERT| UPDATE | REFERENCES } ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) 
!     [,...] | ALL [ PRIVILEGES ] ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) }     ON [ TABLE ]
<replaceableclass="PARAMETER">table_name</replaceable> [, ...]     TO { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] [ WITH GRANT OPTION ]  GRANT { { USAGE | SELECT | UPDATE } 
!     [,...] | ALL [ PRIVILEGES ] }     ON { SEQUENCE <replaceable class="PARAMETER">sequence_name</replaceable> [,
...]         | ALL SEQUENCES IN SCHEMA <replaceable class="PARAMETER">schema_name</replaceable> [, ...] }     TO { [
GROUP] <replaceable class="PARAMETER">role_name</replaceable> | PUBLIC } [, ...] [ WITH GRANT OPTION ]  
! GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }     ON DATABASE
<replaceable>database_name</replaceable>[, ...]     TO { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] [ WITH GRANT OPTION ]  
--- 22,44 ----  <refsynopsisdiv> <synopsis> GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES |
TRIGGER} 
!     [, ...] | ALL [ PRIVILEGES ] }     ON { [ TABLE ] <replaceable class="PARAMETER">table_name</replaceable> [, ...]
        | ALL TABLES IN SCHEMA <replaceable class="PARAMETER">schema_name</replaceable> [, ...] }     TO { [ GROUP ]
<replaceableclass="PARAMETER">role_name</replaceable> | PUBLIC } [, ...] [ WITH GRANT OPTION ]  GRANT { { SELECT |
INSERT| UPDATE | REFERENCES } ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) 
!     [, ...] | ALL [ PRIVILEGES ] ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) }     ON [ TABLE ]
<replaceableclass="PARAMETER">table_name</replaceable> [, ...]     TO { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] [ WITH GRANT OPTION ]  GRANT { { USAGE | SELECT | UPDATE } 
!     [, ...] | ALL [ PRIVILEGES ] }     ON { SEQUENCE <replaceable class="PARAMETER">sequence_name</replaceable> [,
...]         | ALL SEQUENCES IN SCHEMA <replaceable class="PARAMETER">schema_name</replaceable> [, ...] }     TO { [
GROUP] <replaceable class="PARAMETER">role_name</replaceable> | PUBLIC } [, ...] [ WITH GRANT OPTION ]  
! GRANT { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }     ON DATABASE
<replaceable>database_name</replaceable>[, ...]     TO { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] [ WITH GRANT OPTION ]  
*************** GRANT { USAGE | ALL [ PRIVILEGES ] }
*** 59,69 ****     ON LANGUAGE <replaceable>lang_name</replaceable> [, ...]     TO { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] [ WITH GRANT OPTION ]  
! GRANT { { SELECT | UPDATE } [,...] | ALL [ PRIVILEGES ] }     ON LARGE OBJECT <replaceable
class="PARAMETER">loid</replaceable>[, ...]     TO { [ GROUP ] <replaceable class="PARAMETER">role_name</replaceable> |
PUBLIC} [, ...] [ WITH GRANT OPTION ]  
! GRANT { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }     ON SCHEMA <replaceable>schema_name</replaceable> [, ...]
   TO { [ GROUP ] <replaceable class="PARAMETER">role_name</replaceable> | PUBLIC } [, ...] [ WITH GRANT OPTION ]  
--- 59,69 ----     ON LANGUAGE <replaceable>lang_name</replaceable> [, ...]     TO { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] [ WITH GRANT OPTION ]  
! GRANT { { SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] }     ON LARGE OBJECT <replaceable
class="PARAMETER">loid</replaceable>[, ...]     TO { [ GROUP ] <replaceable class="PARAMETER">role_name</replaceable> |
PUBLIC} [, ...] [ WITH GRANT OPTION ]  
! GRANT { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }     ON SCHEMA <replaceable>schema_name</replaceable> [,
...]    TO { [ GROUP ] <replaceable class="PARAMETER">role_name</replaceable> | PUBLIC } [, ...] [ WITH GRANT OPTION ]  
diff --git a/doc/src/sgml/ref/revoke.sgml b/doc/src/sgml/ref/revoke.sgml
index 8f8bd43..204c986 100644
*** a/doc/src/sgml/ref/revoke.sgml
--- b/doc/src/sgml/ref/revoke.sgml
*************** PostgreSQL documentation
*** 23,29 **** <synopsis> REVOKE [ GRANT OPTION FOR ]     { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES
|TRIGGER } 
!     [,...] | ALL [ PRIVILEGES ] }     ON { [ TABLE ] <replaceable class="PARAMETER">table_name</replaceable> [, ...]
       | ALL TABLES IN SCHEMA <replaceable>schema_name</replaceable> [, ...] }     FROM { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] 
--- 23,29 ---- <synopsis> REVOKE [ GRANT OPTION FOR ]     { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | REFERENCES
|TRIGGER } 
!     [, ...] | ALL [ PRIVILEGES ] }     ON { [ TABLE ] <replaceable class="PARAMETER">table_name</replaceable> [, ...]
        | ALL TABLES IN SCHEMA <replaceable>schema_name</replaceable> [, ...] }     FROM { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...] 
*************** REVOKE [ GRANT OPTION FOR ]
*** 31,51 ****  REVOKE [ GRANT OPTION FOR ]     { { SELECT | INSERT | UPDATE | REFERENCES } ( <replaceable
class="PARAMETER">column</replaceable>[, ...] ) 
!     [,...] | ALL [ PRIVILEGES ] ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) }     ON [ TABLE ]
<replaceableclass="PARAMETER">table_name</replaceable> [, ...]     FROM { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...]     [ CASCADE | RESTRICT ]  REVOKE [ GRANT OPTION FOR ]
{{ USAGE | SELECT | UPDATE } 
!     [,...] | ALL [ PRIVILEGES ] }     ON { SEQUENCE <replaceable class="PARAMETER">sequence_name</replaceable> [,
...]         | ALL SEQUENCES IN SCHEMA <replaceable>schema_name</replaceable> [, ...] }     FROM { [ GROUP ]
<replaceableclass="PARAMETER">role_name</replaceable> | PUBLIC } [, ...]     [ CASCADE | RESTRICT ]  REVOKE [ GRANT
OPTIONFOR ] 
!     { { CREATE | CONNECT | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ] }     ON DATABASE
<replaceable>database_name</replaceable>[, ...]     FROM { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...]     [ CASCADE | RESTRICT ] 
--- 31,51 ----  REVOKE [ GRANT OPTION FOR ]     { { SELECT | INSERT | UPDATE | REFERENCES } ( <replaceable
class="PARAMETER">column</replaceable>[, ...] ) 
!     [, ...] | ALL [ PRIVILEGES ] ( <replaceable class="PARAMETER">column</replaceable> [, ...] ) }     ON [ TABLE ]
<replaceableclass="PARAMETER">table_name</replaceable> [, ...]     FROM { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...]     [ CASCADE | RESTRICT ]  REVOKE [ GRANT OPTION FOR ]
{{ USAGE | SELECT | UPDATE } 
!     [, ...] | ALL [ PRIVILEGES ] }     ON { SEQUENCE <replaceable class="PARAMETER">sequence_name</replaceable> [,
...]         | ALL SEQUENCES IN SCHEMA <replaceable>schema_name</replaceable> [, ...] }     FROM { [ GROUP ]
<replaceableclass="PARAMETER">role_name</replaceable> | PUBLIC } [, ...]     [ CASCADE | RESTRICT ]  REVOKE [ GRANT
OPTIONFOR ] 
!     { { CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] }     ON DATABASE
<replaceable>database_name</replaceable>[, ...]     FROM { [ GROUP ] <replaceable
class="PARAMETER">role_name</replaceable>| PUBLIC } [, ...]     [ CASCADE | RESTRICT ] 
*************** REVOKE [ GRANT OPTION FOR ]
*** 76,88 ****     [ CASCADE | RESTRICT ]  REVOKE [ GRANT OPTION FOR ]
!     { { SELECT | UPDATE } [,...] | ALL [ PRIVILEGES ] }     ON LARGE OBJECT <replaceable
class="PARAMETER">loid</replaceable>[, ...]     FROM { [ GROUP ] <replaceable class="PARAMETER">role_name</replaceable>
|PUBLIC } [, ...]     [ CASCADE | RESTRICT ]  REVOKE [ GRANT OPTION FOR ] 
!     { { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }     ON SCHEMA <replaceable>schema_name</replaceable> [, ...]
 FROM { [ GROUP ] <replaceable class="PARAMETER">role_name</replaceable> | PUBLIC } [, ...]     [ CASCADE | RESTRICT ] 
--- 76,88 ----     [ CASCADE | RESTRICT ]  REVOKE [ GRANT OPTION FOR ]
!     { { SELECT | UPDATE } [, ...] | ALL [ PRIVILEGES ] }     ON LARGE OBJECT <replaceable
class="PARAMETER">loid</replaceable>[, ...]     FROM { [ GROUP ] <replaceable class="PARAMETER">role_name</replaceable>
|PUBLIC } [, ...]     [ CASCADE | RESTRICT ]  REVOKE [ GRANT OPTION FOR ] 
!     { { CREATE | USAGE } [, ...] | ALL [ PRIVILEGES ] }     ON SCHEMA <replaceable>schema_name</replaceable> [, ...]
  FROM { [ GROUP ] <replaceable class="PARAMETER">role_name</replaceable> | PUBLIC } [, ...]     [ CASCADE | RESTRICT ] 
diff --git a/doc/src/sgml/sql.sgml b/doc/src/sgml/sql.sgml
index 2a42c8d..c19e823 100644
*** a/doc/src/sgml/sql.sgml
--- b/doc/src/sgml/sql.sgml
*************** DROP VIEW <replaceable class="parameter"
*** 1968,1974 ****  <programlisting> INSERT INTO <replaceable class="parameter">table_name</replaceable> (<replaceable
class="parameter">name_of_attr_1</replaceable>
!     [, <replaceable class="parameter">name_of_attr_2</replaceable> [,...]])     VALUES (<replaceable
class="parameter">val_attr_1</replaceable>[, <replaceable class="parameter">val_attr_2</replaceable> [, ...]]);
</programlisting>     </para> 
--- 1968,1974 ----  <programlisting> INSERT INTO <replaceable class="parameter">table_name</replaceable> (<replaceable
class="parameter">name_of_attr_1</replaceable>
!     [, <replaceable class="parameter">name_of_attr_2</replaceable> [, ...]])     VALUES (<replaceable
class="parameter">val_attr_1</replaceable>[, <replaceable class="parameter">val_attr_2</replaceable> [, ...]]);
</programlisting>     </para> 


Christoph
--
cb@df7cb.de | http://www.df7cb.de/

В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Patch to add a primary key using an existing index
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: [trivial patch] Ellipsis whitespace in SQL docs