Select works intermittently / fails while insert works (Next.js + Supabase)

[domenicopulli-afk]

Hi everyone,

I’m working on a Next.js app using Supabase.

I have a strange issue:

• INSERT into "birds" table works correctly
• SELECT queries sometimes fail or return empty
• Frontend shows: "TypeError: Load failed"
• Dropdowns depending on SELECT stop working

Example query:

const { data, error } = await supabase
.from("birds")
.select("*")
.eq("breed_id", breed_id)

Context:

• Table: birds
• Fields: breed_id, sex, status
• I recently updated CHECK constraints (sex/status)
• Data exists and is valid
• No errors on insert

Suspicions:

• Row Level Security blocking SELECT
• Policy misconfiguration
• Cached schema issue

Has anyone experienced SELECT failing while INSERT works?

Thanks

[GaryAustin1]

What is your USING Policy for Select? You have to meet that.