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

From: Gmail <dmitry(dot)telpt(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #16119: pg_dump omits columns specification for matviews
Date: 2019-11-18 19:08:29
Message-ID: 06CC2CBF-E6A0-47A7-AFD0-90E7B1E59365@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> 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 Thushara Wijeratna 2019-11-18 19:52:15 Re: BUG #16123: DST not respected for America/Sao_Paulo in `timestamp` function
Previous Message PG Bug reporting form 2019-11-18 18:41:43 BUG #16125: Crash of PostgreSQL's wal sender during logical replication