CRITICAL - Select Code Throwing error

[Adithya-Sakaray]

I am using supabase python package to fetch data by joining 2 tables. When I run it in my local machine(mac) all the things are working. When I try it in windows and when I deploy it, I am getting this error thrown below. This error is occurring only to the places where I have used joins. Other routes are working fine.

Error:

{
  status: 'error',
  statusCode: '500',
  response: {'code': 'PGRST108', 'details': None, 'hint': "Verify that 'Recruiter Table' is included in the 'select' query
}

My code is:

details_response = supabase_client.table("Organization Table").select("*, Job Table(*), Recruiter Table(*)").eq("Recruiter Table.is_in_org", True).eq("id", org_id).execute()

The python package version is supabase==2.13.0
My python version is 3.12.3

[GaryAustin1]

It is likely because of your spaces in names. Using capitals and especially spaces is a bad idea in Postgres. Realtime for instance won't work with tables with spaces in the name.

I've never helped anyone with this but you probably need to look into that specifically in your select string. You may need to somehow mark the table nam, but I don't have a suggestion. It is also possible the client just can't handle it.

[GaryAustin1]

I got the same error in a test with JS. I fixed it by doing this:
await supabase].from('cat').select('*, "Space Name"!inner(*)').eq('Space Name.id',1)
Note the double quotes around Space Name in select.

I don't know Python syntax though regarding single and double quotes around each other...