supabase db diff and supabase db pull not capturing RLS policies in views

[officialankan]

Describe the bug
I love views with RLS to reduce complex queries. I also like local development. When combining the two I always have to manually add the RLS part when pushing or pulling migrations.

To Reproduce
Steps to reproduce the behavior:

1. Create a view with RLS (security_invoker=true) remotely or localy.
2. pull or push
3. in the generated diff, the security_invoker is not always there (I have seen it sometime, but can't see why it won't show anymore)

Expected behavior
The full settings of the view should be diffed.

System information

Much love! I really enjoy supabase.

[sweatybridge]

Is this a duplicate of #792?

[officialankan]

Is this a duplicate of #792?

Yes, it is...

[sweatybridge]

Thanks for confirming. I will close this issue as a duplicate.

The fix requires updating the underlying diff tool from migra to pg-schema-diff. It will likely be addressed by this upstream PR when it's merged stripe/pg-schema-diff#132

[bplunkett-stripe]

Thanks for confirming. I will close this issue as a duplicate.

The fix requires updating the underlying diff tool from migra to pg-schema-diff. It will likely be addressed by this upstream PR when it's merged stripe/pg-schema-diff#132

pg-schema-diff doesn't support views yet. So that will need to be implemented first.