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
User is undefined
(FK) with inconsistent behaviour
#24037
Comments
Hey there,
Thanks! |
Hi @encima, Thank you for the reply! The schema is identical, but not the rows inside the tables.
It's straightforward and mostly works for other users. It seems like only 1 particular user got Any relevant RLS policies for the table(s):
and I also use this pattern for enabling UPDATE and INSERT for
On a side note, I got some errors notification on this, one example: Detects when Supabase Auth Could this be something? if so, how do I set it up so that only authenticated users can insert, update, or delete rows in Thank you so much @encima |
Bug report
I have a table row
inventory_product
and one of the columns isuser_id
(FK to user table).As you can see from the images below, it's pretty simple and straightforward:
This is the data from
user
table:This is the
inventory_product
with FK to that user:However, when I try to print the
name
,email
, andid
of the user who created the row, they all return toundefined
:This is weird because you can see it's not undefined on the DB.
Describe the bug
I have a table with rows; one of them is
user_id
, which is an FK touser
table.Some rows work as expected, I can see the
name
,email
,id
as expected. However, some rows just showundefined
even when there's a user attached to it.To Reproduce
I cannot reproduce this. I have debugged the problem locally, and all user data returned properly. Therefore, I am very confused why on production, the user
name
,email
, andid
areundefined
when there is clearly a user attached to the row.Expected behavior
I should be able to see the user
name
,email
,id
as expected.System information
The text was updated successfully, but these errors were encountered: