Horton

Re: Improving RLS planning

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andreas Seltenreich <seltenreich@gmx.de>
Cc: Stephen Frost <sfrost@snowman.net>, Dean Rasheed <dean.a.rasheed@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2017-01-19T21:51:02Z
Lists: pgsql-hackers 
Andreas Seltenreich <seltenreich@gmx.de> writes:
> sqlsmith doesn't seem to like 215b43cdc:

> select 1 from information_schema.usage_privileges
> where information_schema._pg_keysequal(
>    (select null::smallint[]),
>    '{16,25,23}');

> -- TRAP: FailedAssertion("!(!and_clause((Node *) clause))", File: "restrictinfo.c", Line: 81)

Thanks, I'll take a look.

			regards, tom lane

Commits

  1. Improve RLS planning by marking individual quals with security levels.