Server: Hasura Event on View errors "...is a view. Views cannot have row-level BEFORE or AFTER triggers."

[jozef-slezak]

Version Information

Server Version: v2.8.4-cloud.1

What is the current behaviour?

Hasura displays toast error".is a view. Views cannot have row-level BEFORE or AFTER triggers." from postgres when I try to create event on db view.

What is the expected behaviour?

I can trigger event on certain rows (where condition) by db views or other way.

How to reproduce the issue?

Try to create even for DB view because I want event only certain rows. Hasura displays toast error from postgres.

Screenshots or Screencast

Any possible solutions?

Maybe use INSTEAD OF rather then AFTER in create trigger expression.
https://stackoverflow.com/questions/16887884/pl-pgsql-after-insert-trigger-on-a-view-with-a-storages-rule
https://www.postgresql.org/docs/current/sql-createtrigger.html

or add "where condition" to event form (which would be more conveniet for hasura users).