Re: INSERT ... ON CONFLICT UPDATE and RLS - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: INSERT ... ON CONFLICT UPDATE and RLS
Date
Msg-id 20150109004924.GK3062@tamriel.snowman.net
Whole thread Raw
In response to Re: INSERT ... ON CONFLICT UPDATE and RLS  (Peter Geoghegan <pg@heroku.com>)
Responses Re: INSERT ... ON CONFLICT UPDATE and RLS
List pgsql-hackers
Peter,

* Peter Geoghegan (pg@heroku.com) wrote:
> For column level privileges, you wouldn't expect to only get an error
> about not having the relevant update permissions at runtime, when the
> update path happens to be taken. And so it is for RLS.

Right, that's the precedent we should be considering.  Column-level
privileges is a great example- you need both insert and update
privileges for the columns involved for the command to succeed.  It
shouldn't depend on which path actually ends up being taken.
Thanks!
    Stephen

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Turning recovery.conf into GUCs
Next
From: Vladimir Koković
Date:
Subject: Fwd: Re: make check-world regress failed