Horton

Re: EphemeralNamedRelation and materialized view

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Yugo NAGATA <nagata@sraoss.co.jp>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, pgsql-hackers@postgresql.org
Date: 2024-11-18T04:49:20Z
Lists: pgsql-hackers 
On Fri, Nov 15, 2024 at 05:36:47PM +0900, Yugo NAGATA wrote:
> I agree that raising an internal error is not enough. I attached a updated
> patch that outputs a message saying that an ENR can't be used in a matview.

Hmm..  To get a better idea of the scope you are foreseeing here,
should this include some test coverage?
--
Michael

Commits

  1. Disallow NAMEDTUPLESTORE RTEs in stored views, rules, etc.

  2. When creating materialized views, use REFRESH to load data.