From: Gmail <dmitry.telpt@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16119: pg_dump omits columns specification for matviews
Date: Mon, 18 Nov 2019 11:08:29 -0800
Message-ID: <06CC2CBF-E6A0-47A7-AFD0-90E7B1E59365@gmail.com> (raw)
In-Reply-To: <3391.1573952559@sss.pgh.pa.us>
References: <16119-e64823f30a45a754@postgresql.org>
<3391.1573952559@sss.pgh.pa.us>
Hi Tom,
Sorry for a little delay in response, there was no email access over the weekend =)
You know, everything that seems to be ugly for developer maybe 'desired' for customer and contrary in real world.
So, in our case, we're not owner or primary user of schema, only consume data that is maintained by another app and there is inter-team agreement that we can ONLY have views in their schema, that's a cause of such 'strange' solution.
Thanks for a fast feedback and great job!
Just a question, will the fix be back-ported to current supported branches like 9.4/9.5/9.6 or only included in 12?
Thank you again,
Dmitry
> On Nov 16, 2019, at 5:02 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: dmitry.telpt@gmail.com, tgl@sss.pgh.pa.us, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16119: pg_dump omits columns specification for matviews
In-Reply-To: <06CC2CBF-E6A0-47A7-AFD0-90E7B1E59365@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox