pg-diff icon indicating copy to clipboard operation
pg-diff copied to clipboard

[BUG] Nested Materialized View Support (Dependency)

Open MarkEnverus opened this issue 1 year ago • 0 comments

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?

MarkEnverus avatar Sep 05 '24 14:09 MarkEnverus