| From: | Christoph Berg <cb(at)df7cb(dot)de> | 
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> | 
| Subject: | [trivial patch] Ellipsis whitespace in SQL docs | 
| Date: | 2010-11-29 08:43:02 | 
| Message-ID: | 20101129084301.GA3278@msgid.df7cb.de | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | 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 ] <replaceable class="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 ] <replaceable class="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 ] <replaceable class="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 ] <replaceable class="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 ] <replaceable class="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 ] <replaceable class="PARAMETER">role_name</replaceable> | PUBLIC } [, ...]
      [ CASCADE | RESTRICT ]
  
  REVOKE [ GRANT OPTION FOR ]
!     { { 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 ] <replaceable class="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 ] <replaceable class="PARAMETER">role_name</replaceable> | PUBLIC } [, ...]
      [ CASCADE | RESTRICT ]
  
  REVOKE [ GRANT OPTION FOR ]
!     { { 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(at)df7cb(dot)de | http://www.df7cb.de/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dimitri Fontaine | 2010-11-29 09:26:35 | Re: pg_execute_from_file review | 
| Previous Message | David Fetter | 2010-11-29 06:58:40 | Re: Patch to add a primary key using an existing index |