pg-diff
pg-diff copied to clipboard
[BUG] Nested Materialized View Support (Dependency)
I have a materialized view that has another materialized view inside of it
job_success_history_by_today => references => job_success_history_by_day
When I make a change to job_success_history_by_day - pg-diff tries to DROP the view which is can't since its referenced by job_success_history_by_today.
DROP MATERIALIZED VIEW IF EXISTS "public"."job_success_history_by_day"; CREATE MATERIALIZED VIEW IF NOT EXISTS "public"."job_success_history_by_day" AS SELECT nomadjobname,
Can pg-diff detect the dependency and do an ALTER if the view exists?