Horton

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

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: dmitry.telpt@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Date: 2019-11-17T01:02:39Z
Lists: 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

Commits

  1. Further fix dumping of views that contain just VALUES(...).