Re: BUG #16119: pg_dump omits columns specification for matviews - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #16119: pg_dump omits columns specification for matviews
Date
Msg-id 3391.1573952559@sss.pgh.pa.us
Whole thread Raw
In response to BUG #16119: pg_dump omits columns specification for matviews  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #16119: pg_dump omits columns specification for matviews  (Gmail <dmitry.telpt@gmail.com>)
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> We've faced up with an issue how pg_dump exports materialzed views, it
> doesn't export columns declaration that is legal parameter of CREATE DDL
> instruction.

I figured out what was going wrong here and pushed a fix for it.
I'm still a bit curious about the real use-case, since a materialized
view made from just a VALUES clause seems a bit pointless.

            regards, tom lane



pgsql-bugs by date:

Previous
From: Devrim Gündüz
Date:
Subject: Re: yum repo misconfigured: postgis24_10-2.4.8-6.rhel7.x86_64
Next
From: "唯一★"
Date:
Subject: 回复: 回复: 回复: BUG #16101: tables in the DB is not available after pg_restore