Reload Schema Cache
Hi, I recently changed a certain relationship in my database. When I tried to grab data from the database, it said "If a new relationship was created, try reloading the schema cache." How can I go about reloading the schema cache?
4 Replies
NOTIFY pgrst, 'reload schema'
from https://postgrest.org/en/stable/schema_cache.html#reloading-with-notify
This may or may not fix your issue as it also generates that error if your relations are not setup correctly for your use.I saw this, but how do I go about using it? Do I create a postgres function that I call w an rpc? is there an easy way to just run it in the website?
Oh sorry, run it in the sql editor in the dashboard...
Got it - thanks!