View with infinite recursion causes 400 bad request

[steve-chavez]

Problem

Having:

create view test.view_projects as
select * from test.projects;

create or replace view test.view_projects as
select * from test.view_projects;

Causes:

curl localhost:3000/view_projects -i
HTTP/1.1 400 Bad Request
Transfer-Encoding: chunked
Date: Fri, 23 Feb 2024 22:01:26 GMT
Server: postgrest/12.1 (160caaf)
Content-Type: application/json; charset=utf-8

{"code":"42P17","details":null,"hint":null,"message":"infinite recursion detected in rules for relation \"view_projects\""}

Solution

Turn 42P17 into a 500 status.