RLS bug? - Mailing list pgsql-bugs

From Peter Geoghegan
Subject RLS bug?
Date
Msg-id CAM3SWZTitxzNhwhCDwDHUVf6R-rg+FZGn-jxSoPxjaaJn3jzZA@mail.gmail.com
Whole thread Raw
Responses Re: RLS bug?
Re: RLS bug?
List pgsql-bugs
Example session, from master branch:

postgres=# create table rowtest (key int4 primary key, val text);
CREATE TABLE
postgres=# alter table rowtest enable row level security;
ALTER TABLE
postgres=# create role bob;
CREATE ROLE
postgres=# CREATE POLICY test ON rowtest
    FOR INSERT
    TO bob
    WITH CHECK (key % 3 = 0 );
CREATE POLICY
postgres=# CREATE POLICY test2 ON rowtest
    FOR UPDATE
    TO bob
    WITH CHECK (key % 2 = 0 );
CREATE POLICY
postgres=# \d rowtest
    Table "public.rowtest"
 Column |  Type   | Modifiers
--------+---------+-----------
 key    | integer | not null
 val    | text    |
Indexes:
    "rowtest_pkey" PRIMARY KEY, btree (key)
Policies:
    POLICY "test" FOR INSERT
      TO bob
      WITH CHECK ((key % 3) = 0)
    POLICY "test2"
      TO bob
      WITH CHECK ((key % 2) = 0)


Why is the policy "test2" not listed as applying only "FOR UPDATE"? If
this is the intended behavior, it is not consistent with the
documentation, which states: "Using UPDATE for a policy means that it
will apply to UPDATE commands".
--
Peter Geoghegan

pgsql-bugs by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: BUG #12320: json parsing with embedded double quotes
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: BUG #12328: can't install the postgresql