Re: Row security violation error is misleading

On Tue, Apr 7, 2015 at 5:11 AM, Craig Ringer  wrote:
> postgres=> INSERT INTO clients (account_name, account_manager) VALUES
> ('peters', 'peter'), ('johannas', 'johanna');
> ERROR:  44000: new row violates WITH CHECK OPTION for "clients"
> DETAIL:  Failing row contains (7, johannas, johanna).
> LOCATION:  ExecWithCheckOptions, execMain.c:1683
>
>
> ... yet "clients" is a table, not a view, and cannot have a WITH CHECK
> OPTION clause.
>
> There is no reference to the policy being violated or to the fact that it's
> row security involved.


FWIW, I also think that this is very confusing.

-- 
Peter Geoghegan