Hello,
that is just the point:
cf
"
are that the materialized view cannot subsequently be directly updated
and that the query used to create the materialized view is stored in
exactly the same way that a view's query is stored, so that fresh data
can be generated for the materialized view with:
"
On Fri, Aug 22, 2025, at 23:40, David G. Johnston wrote:
> On Fri, Aug 22, 2025 at 2:23 PM PG Doc comments form
> wrote:
>> Unless I'm completely mistaken, the second code example on
>> https://www.postgresql.org/docs/current/rules-materializedviews.html, i.e
>> this:
>>
>> CREATE TABLE mymatvie
On Fri, Aug 22, 2025 at 2:23 PM PG Doc comments form
wrote:
> Unless I'm completely mistaken, the second code example on
> https://www.postgresql.org/docs/current/rules-materializedviews.html, i.e
> this:
>
> CREATE TABLE mymatview AS SELECT * FROM mytab;
>
> Should instead by
>
> CREATE VIEW mym
