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.