Re: 9.5rc1 RLS select policy on insert?

Поиск
Список
Период
Сортировка
От Ted Toth
Тема Re: 9.5rc1 RLS select policy on insert?
Дата
Msg-id CAFPpqQHC_kY3YWAeE4DYjQvBzPHELuUUVLOGeD6K-ifkUbaDkQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 9.5rc1 RLS select policy on insert?  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: 9.5rc1 RLS select policy on insert?
Re: 9.5rc1 RLS select policy on insert?
Список 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 по дате отправления:

Предыдущее
От: Vick Khera
Дата:
Сообщение: Re: What another group does (was Re: Code of Conduct: Is it time?)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 9.5rc1 RLS select policy on insert?