Re: BUG #16119: pg_dump omits columns specification for matviews

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: dmitry(dot)telpt(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16119: pg_dump omits columns specification for matviews
Date: 2019-11-17 01:02:39
Message-ID: 3391.1573952559@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message 唯一★ 2019-11-17 14:40:49 回复: 回复: 回复: BUG #16101: tables in the DB is not available after pg_restore
Previous Message Devrim Gündüz 2019-11-17 00:25:00 Re: yum repo misconfigured: postgis24_10-2.4.8-6.rhel7.x86_64