Accessing different schemas with Accept-Profile

[warflash]

Hey there!

I'm currently stuck with accessing different schemas of my db, feedback would be massively appreciated.
I added my schema to postgrest.conf like so: db-schemas = "public, example_schema, restarted postgres to make sure everything is reloaded and then added Accept-Profile: example_schema to my calls.

The response message I'm getting is the following:

 {
    "hint": null,
    "details": null,
    "code": "42P01",
    "message": "relation \"public.collect\" does not exist"
} 

which makes is look like postgrest is not even trying to find and use the schema specified in the request?

Not really sure where to go from here - any hint is appreciated 😊

[steve-chavez]

The response message I'm getting is the following:

Can you share the request you're doing?

[warflash]

Sure, here's a screenshot of the setup I'm running:
It turned out to be a bit all over the place but I tried including everything to make sure I'm not missing something^^

[laurenceisla]

@warflash Does it give you the same response using curl?

curl "http://localhost:3000/collect" \
  -H "Accept-Profile: bdo_data"

[warflash]

@laurenceisla Yes, using curl yields the same response:

[laurenceisla]

I see. Try changing the schema name to anything else, like: Accept-Profile: wrong. If it gives you the same error, then the config file is interpreting it as only one schema, then try completely stopping PostgREST and starting it again.

[warflash]

Oh wow.
For some reason the .service file was pointing to a backup version of the postgrest config which did not have the updated schemas 🤦‍♂️
Been banging my head against the wall the entire day because of this...
Thank you both for helping out!