To: "pgsql-docs@postgresql.org" <pgsql-docs@postgresql.org>
From: Alexander Law <exclusion@gmail.com>
Subject: Invalid field name in RLS description
Message-ID: <905bf384-92a8-20aa-d705-6269534c721a@gmail.com>
Date: Mon, 12 Sep 2016 17:43:37 +0300
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101
 Thunderbird/45.2.0
MIME-Version: 1.0
Content-Type: multipart/mixed;
 boundary="------------D08246A8F9374B463B7C9C8F"
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org

This is a multi-part message in MIME format.
--------------D08246A8F9374B463B7C9C8F
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit

Hello,

It seems, that the RLS description supposes that the users table 
contains the field "user", but it's a reserved keyword.
Patch attached. (The replacement "user_name" selected as corresponding 
to the following examples).

Best regards,
Alexander


--------------D08246A8F9374B463B7C9C8F
Content-Type: text/x-patch;
 name="ddl-rowsecurity_user_column.patch"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="ddl-rowsecurity_user_column.patch"

diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
index a393813..c907081 100644
--- a/doc/src/sgml/ddl.sgml
+++ b/doc/src/sgml/ddl.sgml
@@ -1629,7 +1629,7 @@ CREATE POLICY account_managers ON accounts TO managers
 
 <programlisting>
 CREATE POLICY user_policy ON users
-    USING (user = current_user);
+    USING (user_name = current_user);
 </programlisting>
 
   <para>
@@ -1642,7 +1642,7 @@ CREATE POLICY user_policy ON users
 <programlisting>
 CREATE POLICY user_policy ON users
     USING (true)
-    WITH CHECK (user = current_user);
+    WITH CHECK (user_name = current_user);
 </programlisting>
 
   <para>

--------------D08246A8F9374B463B7C9C8F
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

--------------D08246A8F9374B463B7C9C8F--