How to reload metadata cache when updating "hdb_catalog".hdb_metadata table?

[iosifnicolae2]

Hi.

We would like to trigger a cache reload when the hdb_catalog.hdb_metadata table is updated directly from PostgreSQL using an AFTER UPDATE trigger.

Is it possible to trigger Hasura cache sync from PostgreSQL?

I've quite a lot of hours trying to figure out how to do this but not success until now.

[iosifnicolae2]

The idea is that we generate inherited_roles dynamically, so we've created a BEFORE update trigger on hdb_metadata table to override inherited_roles at runtime.