and this is the

ingredients

table

ingredients

table has this content

and

ingredient-prints

has this

all looks good to me, when are you getting that error? during an insert?

no, when trying to save this FK creation

this is how it's currently. The FK is not created yet...

I click on

Add foreign key relation

and I chose these values

I then click

Save

and get the initial error I shared

could you maybe remove that column and recreate it with the foreign key?

it could be due to the field being nullable, in case you already have some entries

but it's not nullable... you can see the

Allow Nullable

is not checked

looks like removing and recreating with the FK works... no issue here because I had just 10 rows... but I can't see that happening if I had more rows....

is this expected???

this is postgres related, nothing to do with supabase. maybe have a look at stackoverflow for that error to figure out what the problem was in the first place

my hunch is that some of those values that you already had filled in the

master

field were not matching any value in the other column from the other table, so the forign key could not resolve proeprly

alright... thank you for your help with the workaround

noup... it was a single value

but no worries...

null values would have been a problem

there were no null values 😅

supabase related... do you know if it's possible to have the foreign table contents come back in the same level as the main object?

example...

let { data, error, status } = await supabase
      .from('ingredient-prints')
      .select(`*, 
        ingredients (key) 
      `)
      .in('token',tokens)
      .limit(count)

this, is returning this:

{
  "edition": 9,
  "sent": null,
  "recipient": null,
  "from": null,
  "token": "7VTYM6wBgv25Hd9KHmTVQpVwqMDkAq6ctWqQDdX63PV7",
  "master": "DpPbk6h3UhYkAtZxj6Sxzt2bh9QMiqDN68wn9YaVQpBw",
  "ingredients": {
    "key": "doom-chalice"
  }
}

would it be possible to return it as

{
  "edition": 9,
  "sent": null,
  "recipient": null,
  "from": null,
  "token": "7VTYM6wBgv25Hd9KHmTVQpVwqMDkAq6ctWqQDdX63PV7",
  "master": "DpPbk6h3UhYkAtZxj6Sxzt2bh9QMiqDN68wn9YaVQpBw",
  "key": "doom-chalice"
}

?

Please use threads folks, it's easier to keep track of conversations there.

Anyone have a good article or video on Column Level Security? I am a SQL newbie but want to open up reading permissions on a specific column. Bonus points if it is through the supabase cloud UI.

Hi there! Loving supabase so far but I'm struggling with inner joins. Below is an example query that's working on my supabase SQL editor

sql
select p.*
from follows f
join profile p on p.id = f.target_user_id
where f.user_id = '9e7486c7-40f2-41dc-9a4d-467fbe52faee'

I'd love to transform that into a js client select statement. Below is one of my attempts.

js
await supabase
    .from('profile')
    .select('*, follows!inner(id)')
    .eq('follows.user_id', user_id)

Could someone be so kind to help me figure out the exact statement to use? Thanks! profile.id is a foreign key of user.id follows.user_id is a foreign key of user.id

My project got deleted after few days of not using it. How can I restore it?

is there a way i can get a user from auth.users? i have a foreign-key for setting the user in a column, but i want to get that user's data (i.e. identity data)

(or is it better to do something like this https://nikofischer.com/supabase-how-to-query-users-table)

User data from Auth