Postgres Pro
Downloads
Home   >   mailing lists

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

From Stephen Frost
Subject Re: 9.5rc1 RLS select policy on insert?
Date
Msg-id 20160107034007.GV3685@tamriel.snowman.net
Whole thread Raw
In response to 9.5rc1 RLS select policy on insert?  (Ted Toth <txtoth@gmail.com>)
Responses Re: 9.5rc1 RLS select policy on insert?
List pgsql-general
Tree view 
* 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
Attachment

pgsql-general by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Trigger function interface
Next
From: Luke Coldiron
Date:
Subject: Re: COPY FROM STDIN