Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
basedonskills opened this issue Mar 19, 2024 · 1 comment
Labels
bug Something isn't working

Comments

@basedonskills
Copy link

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

  • "supabase": "1.150.0",
  • "@supabase/supabase-js": "2.39.8",
@basedonskills basedonskills added the bug Something isn't working label Mar 19, 2024
@steve-chavez
Copy link
Member

Check if these two SQL functions exist:

  • extensions.pgrst_ddl_watch
  • extensions.pgrst_drop_watch

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants