| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | lalbin(at)scharp(dot)org |
| Cc: | pgsql-bugs(at)postgresql(dot)org, Kevin Grittner <kgrittn(at)gmail(dot)com> |
| Subject: | Re: BUG #14147: Restore of MatView of Foreign Data Table fails |
| Date: | 2016-05-23 19:07:21 |
| Message-ID: | 17802.1464030441@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
lalbin(at)scharp(dot)org writes:
> I have found that restoration of Materialized Views of Foreign Data Tables
> where user postgres does not have a user mapping will fail. It seems that it
> is trying to execute the Foreign Data Table in some way instead of reading
> the Foreign Table Definition.
This is another variant of a problem that's been complained of multiple
times before: CREATE MATERIALIZED VIEW ... WITH NO DATA runs planning and
even does ExecutorStart for the view's query, causing issues such as lack
of permissions to be exposed. This breaks assorted assumptions in pg_dump
and probably other places. We need to refactor things so that that does
not happen. Kevin, are you planning to fix that anytime soon?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2016-05-23 19:17:45 | Re: BUG #14147: Restore of MatView of Foreign Data Table fails |
| Previous Message | Peter Geoghegan | 2016-05-23 19:02:41 | Re: [BUGS] BUG #14153: Unrecognized node type error when upsert is present in recursive CTE |