Unable to track partitioned tables #5071
Description
Hi !
I'm currently trying to track a table that is partitioned over foreign tables.
list of relations
| Schema | Name | Type |
|---|---|---|
| public | users | partitioned table |
| public | users_eu | foreign table |
| public | users_us | foreign table |
Expectation
Track users relation in Hasura's schema.
Actual behaviour
When I open the Hasura console to see the list of trackable entities,
I get user_eu and users_us but users won't show.
note: If I add a PostgreSQL view all_users that does a SELECT * from users; the all_users view shows up in the trackable relations and I'm capable of running INSERT, SELECT and UPDATE queries over it.
Tested against:
- Hasura (
v1.0,v1.2.2,v1.3.0-beta-1) - PostgresQL 12