How to reload schema cache?

[mathiasrscom]

Hi,

I'm getting the following error message, when trying to run the dev server using yarn dev:

{ hint: 'If a new foreign key between these entities was created in the database, try reloading the schema cache.', message: 'Could not find a relationship between products and prices in the schema cache' }

I'm using the Stripe Subscription template provided by Supabase in the SQL section and the repo:
https://github.com/vercel/nextjs-subscription-payments

How and where can I reload the schema cache?

[steve-chavez]

Hey @mathiassdev,

Can you try doing:

NOTIFY pgrst, 'reload schema';

The above should reload PostgREST schema cache.

[steve-chavez]

On any SQL client

[GaryAustin1]

@jesper-bylund and specifically the SQL editor in the dashboard if you are not using your own 3rd party client.

[JUDE-EQ]

cool, still working today

[usman-javed1]

how i can do this from nodejs

[GaryAustin1]

Write a postgres function and call it with rpc.