Re: Per-role disabling of LEAKPROOF requirements for row-level security?

2025-09-25 Thread Andreas Lind
due to the "OR" semantics so I think it's better to keep it simple for now. It seems to work well when I test it locally, and I've also fiddled with some automatic tests (not enclosed in the patch). Let me know if the general approach seems sane, then I can work on it some more. Be

Re: Per-role disabling of LEAKPROOF requirements for row-level security?

2025-06-23 Thread Andreas Lind
GER); CREATE POLICY across_tenants ON my_table FOR ALL TO across_tenants_role USING (true); As a bonus, the across_tenants policy doesn't receive the leakproof guardrails. I guess USING (true) is special cased in some way. Best regards, Andreas Lind On Mon, Jun 16, 2025 at 5:59 PM Tom Lane

Per-role disabling of LEAKPROOF requirements for row-level security?

2025-04-21 Thread Andreas Lind
truct available to the planner, but this is beyond my current abilities. Also, it's probably better to get some feedback on the idea before spending too much time optimizing. What do you think? Best regards, Andreas Lind [1] https://www.postgresql.org/message-id/2811772.0XtDgEdalL%40peanuts2 [