-
I've got a question regarding remote database relationships and views (in Postgres). I'm working on backing a database that's owned by a fairly long-running Rails app with Hasura. I ran into some issues with polymorphic associations, and created views (non-materialized) on top of the relevant tables so that each type of association could be visible in the graph. For instance:
The problem I'm running into now is, we have another database which has some relationships to the first DB's data, and while I've been able to use remote database relationships to connect them for tables which don't include polymorphic associations, I can't do that with these views. To be clear: When I look at the underlying tables in the Hasura console, I have the option to set up relationships to remote databases, but that option is not visible when looking at the views. But, I can't use a direct relationship from the table because it's dependent on the relationship type column to know which table to find the related object. Is there any way to set up this view-to-remote-DB relationship, or am I going to need to have actual tables to set up the relationship? |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
I was running an older version. Updating to 2.8.1 did the trick. |
Beta Was this translation helpful? Give feedback.
I was running an older version. Updating to 2.8.1 did the trick.