Problem
Adding schemas in db-schemas and then dropping them database side makes postgREST inoperative, it won't serve any requests.
After much discussion on #4364 and #5042, it seems we're stuck with db-schemas for some cases.
Solution
I suggest only validating the first schema in db-schemas, since it will be picked as the "default schema". The rest don't have to be validated.
I also believe this goes in line with recent changes about making the schema cache "best effort" (#4869)..
Problem
Adding schemas in
db-schemasand then dropping them database side makes postgREST inoperative, it won't serve any requests.After much discussion on #4364 and #5042, it seems we're stuck with
db-schemasfor some cases.Solution
I suggest only validating the first schema in
db-schemas, since it will be picked as the "default schema". The rest don't have to be validated.I also believe this goes in line with recent changes about making the schema cache "best effort" (#4869)..