Computed relationships: Could not find a relationship

[putheng]

Bug report

Computed relationships: Could not find a relationship

Describe the bug

Try to get computed relationships from foreigndb_fdw server by create a local table name loans that has order_id and create a function call orders

This is loans table

orders function

product_orders from foreigndb_fdw server

To Reproduce

Call RESTApi url /rest/v1/loans?select=*,orders i got one-to-one relationship https://postgrest.org/en/stable/api.html#computed-cols

Call RESTApi with url /rest/v1/loans?select=*,orders(*) https://postgrest.org/en/stable/api.html#computed-relationships

Expected behavior

It should return setof relationship table https://postgrest.org/en/stable/api.html#computed-relationships

Additional context

Any way, I try to define the opposite one-to-many relationship

than return multiple row instead of one-to-many

[steve-chavez]

Could you share your postgREST version? It can be done as mentioned here.

Also try doing NOTIFY pgrst, 'reload schema';.

[putheng]

This is my version "info": { "description": "standard public schema", "title": "PostgREST API", "version": "9.0.1.20220717 (pre-release) (d2df289)" }

[putheng]

Solved by upgrading PostgREST to 10.1.1 (aaa4fbc)

[kevinmlong]

I'm using a self-hosted Supabase and I switched out the postgrest container to postgrest/postgrest:v10.1.1.20221215, but I'm still seeing an issue with queries using !inner returning an array of 1 instead of an object. For those that have successfully got this working, any thoughts?