RLS and LEAKPROOF functions - Mailing list pgsql-hackers

From Ted Toth
Subject RLS and LEAKPROOF functions
Date
Msg-id CAFPpqQEK-L9xCxuyvq6qz43gUpcgK2geoV=TbOdoVA8A05kNaA@mail.gmail.com
Whole thread Raw
Responses Re: RLS and LEAKPROOF functions  (Noah Misch <noah@leadboat.com>)
List 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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [patch] A \pivot command for psql
Next
From: Robert Haas
Date:
Subject: Re: WIP: SCRAM authentication