Re: 9.5rc1 RLS select policy on insert?

From: Ted Toth <txtoth(at)gmail(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: 9.5rc1 RLS select policy on insert?
Date: 2016-01-07 14:18:00
Message-ID: CAFPpqQHC_kY3YWAeE4DYjQvBzPHELuUUVLOGeD6K-ifkUbaDkQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

This happens on simple INSERTs no RETURNING.

On Wed, Jan 6, 2016 at 9:40 PM, Stephen Frost <sfrost(at)snowman(dot)net> wrote:
> * Ted Toth (txtoth(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-01-07 14:27:18 Re: 9.5rc1 RLS select policy on insert?
Previous Message Vick Khera 2016-01-07 13:11:11 Re: What another group does (was Re: Code of Conduct: Is it time?)