Craig Ringer <cr...@2ndquadrant.com> writes: > On 09/04/2013 11:22 PM, Tom Lane wrote: >> AFAICT, to deal with update/delete the RLS patch needs to constrain order >> of qual application without the crutch of having a separate level of >> subquery; and it's that behavior that I have zero confidence in, either >> as to whether it works as submitted or as to our odds of not breaking it >> in the future.
> Wouldn't CASE do that job, albeit in a somewhat ugly manner, and also > protect against malicious RLS functions? You mean wrap all the query quals in a CASE? Sure, if you didn't mind totally destroying any optimization possibilities. If you did that, every table scan would become a seqscan and every join a nestloop. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers