Re: 9.5rc1 RLS select policy on insert?

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

* 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 Luke Coldiron 2016-01-07 03:45:35 Re: COPY FROM STDIN
Previous Message Tatsuo Ishii 2016-01-07 01:03:01 Trigger function interface