Respected Sir, I am Aditya, a student currently working on a research project with my professor, where we are addressing the cyclic RLS policy problem in PostgreSQL.
The issue is that when a SECURITY DEFINER UDF is not used and the rewriter encounters a cyclic policy, PostgreSQL throws an "infinite recursion" error in the terminal. This behavior is also acknowledged in the official PostgreSQL test cases. Our goal is to find a solution to this problem and potentially contribute the fix to the PostgreSQL community. It would be incredibly valuable to have your guidance on this. Being able to solve this problem in PostgreSQL would be a significant achievement, and I believe your expertise could greatly help us move in the right direction. Thank you for your time and consideration. Regards, Aditya.
