N

Neon•16mo ago•

1 reply

technical-ivory

Beginner Question: Materialized View - Refresh how?

I am unable to refresh a materialized view using drizzle & neon, i posted a repro repository if anyone has a moment to check. I want to visit a next js api route to refresh, the console shows its successful, but the data returned is not refreshed in the view unless i manually run

REFRESH MATERIALIZED VIEW

REFRESH MATERIALIZED VIEW

in the neon editor, any ideas?

possibly the error is from nextjs or drizzle, but i don't see any type errors from my implementation of drizzle and i think my next js route handler is not throwing, open to any suggestions!

https://github.com/arm-learning/postgresql-q

edit: ooops, i figured it out