RLS and LEAKPROOF functions

From: Ted Toth <txtoth(at)gmail(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: RLS and LEAKPROOF functions
Date: 2015-08-11 14:27:17
Message-ID: CAFPpqQEK-L9xCxuyvq6qz43gUpcgK2geoV=TbOdoVA8A05kNaA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I built an index on a jsonb column of a table with RLS enabled but it
was not being used. Turns out the the function jsonb_contains needed
to be LEAKPROOF (thanks Joe Conway). However I do not actually know if
jsonb_contains is LEAKPROOF. Who's responsibility is it to insure
functions are leakproof? It would be useful if this function was
documented and there was an indication as to it's leakproofness.

Ted

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2015-08-11 14:28:15 Re: WIP: SCRAM authentication
Previous Message Robert Haas 2015-08-11 14:13:48 Re: [patch] A \pivot command for psql