Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Row Level Security UPDATE Confusion - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: [HACKERS] Row Level Security UPDATE Confusion
Date
Msg-id 20170413203143.GS9812@tamriel.snowman.net
Whole thread Raw
In response to Re: [HACKERS] Row Level Security UPDATE Confusion  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] Row Level Security UPDATE Confusion  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Tree view 
* Robert Haas (robertmhaas@gmail.com) wrote:
> On Thu, Apr 6, 2017 at 4:05 PM, Rod Taylor <rod.taylor@gmail.com> wrote:
> > I'm a little confused on why a SELECT policy fires against the NEW record
> > for an UPDATE when using multiple FOR policies. The ALL policy doesn't seem
> > to have that restriction.
>
> My guess is that you have found a bug.

Indeed.  Joe's been looking into it and I'm hoping to find some time to
dig into it shortly.

Thanks!

Stephen

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [HACKERS] \if, \elseif, \else, \endif (was Re: PSQL commands:\quit_if, \quit_unless)
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Quals not pushed down into lateral