PostgREST Infinite Recursion on Constraint after removing constraint
We had a bad constraint on a table causing infinite recursion. We've verified that the table can now be queried directly with the same query without issues after removing that constraint. However after removing the constraint, PostgREST requests are still returning
At this point the only constraints on the impacted table are just foreign key relationships. But even simple selects by the primary key of the table are returning this behavior. Super strange.
infinite recursion detected in policy for relation \"users\"NOTIFY pgrst, 'reload schema'At this point the only constraints on the impacted table are just foreign key relationships. But even simple selects by the primary key of the table are returning this behavior. Super strange.
