Re: 9.5rc1 RLS select policy on insert? - Mailing list pgsql-general

From Ted Toth
Subject Re: 9.5rc1 RLS select policy on insert?
Date
Msg-id CAFPpqQHC_kY3YWAeE4DYjQvBzPHELuUUVLOGeD6K-ifkUbaDkQ@mail.gmail.com
Whole thread Raw
In response to Re: 9.5rc1 RLS select policy on insert?  (Stephen Frost <sfrost@snowman.net>)
Responses Re: 9.5rc1 RLS select policy on insert?
Re: 9.5rc1 RLS select policy on insert?
List pgsql-general
This happens on simple INSERTs no RETURNING.

On Wed, Jan 6, 2016 at 9:40 PM, Stephen Frost <sfrost@snowman.net> wrote:
> * Ted Toth (txtoth@gmail.com) wrote:
>> I see the insert policy check running but also the select policy using
>> on insert. I don't understand why the select policy is being run.
>> Could it possibly be related to using a sequence on the table?
>
> It's used when SELECT rights are required on the table, such as with an
> INSERT .. RETURNING.
>
> Thanks!
>
> Stephen


pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: What another group does (was Re: Code of Conduct: Is it time?)
Next
From: Tom Lane
Date:
Subject: Re: 9.5rc1 RLS select policy on insert?