search

supabase / supabase-js

An isomorphic Javascript client for Supabase. Query your Supabase database, subscribe to realtime events, upload and download files, browse typescript examples, invoke postgres functions via rpc, invoke supabase edge functions, query pgvector.
https://supabase.com
MIT License
2.83k stars 219 forks source link

Newly added column doesn't exist on update, but when I fetch, it's visible #989

Open basedonskills opened 1 month ago

basedonskills commented 1 month ago

Describe the bug

I've added a new column to my users table named "onboarded". But when I try to update the column it says it doesn't exist. When I fetch the user before the update I see the column being FALSE. Updating the user without this column (updating other columns instead) works without an issue..

Expected behavior

The column exists in the database as well as when I fetch the user. I expect to be able to update it.

Screenshots

Screenshot 2024-03-19 at 22 42 39 Screenshot 2024-03-19 at 22 43 12

System information

steve-chavez commented 4 weeks ago

Check if these two SQL functions exist:

Some migration tools might somehow drop those functions that are required for the JS client to be up2date with the db.