Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Is it possible for supabase api joins to infer a relationship between two tables without explicit foreign key relationship? Or is there a way to annotate that? For example I have a shop_id row on shop and person table but I get `Could not find a relationship between 'shop' and 'person' in the schema cache`.

Hello <@840058872127291392>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

oh wow is it this: https://github.com/PostgREST/postgrest/pull/2262

Is there anyway around that by annotating "HEY YES THIS IS DEFINITELY RELATED" :p

I think I'll just make an rpc function instead unless there's a way around it.

Hi <:vmathi:812484657547313212> I don't think it's possible, you need to be explicit on relations <@840058872127291392>

Thread was archived by <@840058872127291392>. Anyone can send a message to unarchive it.