--ELM1175917744-26605-0_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"

Tom Lane wrote:
> Russell Smith writes:
> > Tom Lane wrote:
> >> The entire *point* of that paragraph is that we don't have the
> >> feature. This proposed change is surely not an improvement...
> >>
> > Maybe removing the entire example would be more helpful. I don't find
> > it clear to have a command outline in a compatibility block.
>
> True, there doesn't seem to be any point in providing a full syntax
> summary rather than just saying "the SQL spec says you can grant
> privileges on columns but we don't support that yet".

Agreed. Patch attached and applied. I don't see any other cases of
this in our documentation.

--
Bruce Momjian http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

--ELM1175917744-26605-0_
Content-Transfer-Encoding: 7bit
Content-Type: text/x-diff
Content-Disposition: inline; filename="/rtmp/diff"

Index: doc/src/sgml/ref/grant.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/ref/grant.sgml,v
retrieving revision 1.64
diff -c -c -r1.64 grant.sgml
*** doc/src/sgml/ref/grant.sgml 1 Feb 2007 00:28:19 -0000 1.64
--- doc/src/sgml/ref/grant.sgml 7 Apr 2007 03:45:36 -0000
***************
*** 520,533 ****



! The SQL standard allows setting privileges for individual columns
! within a table:
!
!
! GRANT privileges
! ON table [ ( column [, ...] ) ] [, ...]
! TO { PUBLIC | username [, ...] } [ WITH GRANT OPTION ]
!



--- 520,527 ----



! PostgreSQL does not support the SQL-standard
! functionality of setting privileges for individual columns.



Index: doc/src/sgml/ref/revoke.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/ref/revoke.sgml,v
retrieving revision 1.42
diff -c -c -r1.42 revoke.sgml
*** doc/src/sgml/ref/revoke.sgml 31 Jan 2007 23:26:04 -0000 1.42
--- doc/src/sgml/ref/revoke.sgml 7 Apr 2007 03:45:37 -0000
***************
*** 231,245 ****


The compatibility notes of the command
! apply analogously to REVOKE. The syntax summary is:
!
!
! REVOKE [ GRANT OPTION FOR ] privileges
! ON object [ ( column [, ...] ) ]
! FROM { PUBLIC | username [, ...] }
! { RESTRICT | CASCADE }
!
! One of RESTRICT or CASCADE
is required according to the standard, but PostgreSQL
assumes RESTRICT by default.

--- 231,238 ----


The compatibility notes of the command
! apply analogously to REVOKE.
! RESTRICT or CASCADE
is required according to the standard, but PostgreSQL
assumes RESTRICT by default.


--ELM1175917744-26605-0_
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

--ELM1175917744-26605-0_--