Re: Q on SELECT column list pushdown from view to table

Karsten Hilbert <Karsten.Hilbert@gmx.net> writes:
> I expected this:

>     set role "restricted-role";
>     -- this works:
>     select public_col from t_partially_private;
>     -- this fails: with "permission denied on table t_partially_private"
>     select public_col from v_partially_private;

> to work but selecting from the view fails.

Works fine if you don't mess with the view's security_invoker
status.

            regards, tom lane