N
Neonβ€’12mo ago
rising-crimson

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 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 πŸ˜†
1 Reply
optimistic-gold
optimistic-goldβ€’12mo ago
You should share what you found out! Someone might have the same question πŸ˜„

Did you find this page helpful?