Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).

From: Kirill Reshke <reshkekirill(at)gmail(dot)com>
To: vignesh C <vignesh21(at)gmail(dot)com>
Cc: jian he <jian(dot)universality(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)oss(dot)nttdata(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).
Date: 2025-04-01 10:18:55
Message-ID: CALdSSPiNtJMQFhSWSJnkwqwTkDAe3nqTjZ2yqs9jZVC6SYh6FA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, 1 Apr 2025, 11:45 vignesh C, <vignesh21(at)gmail(dot)com> wrote:

>
> One thing I noticed was that if the materialized view is not refreshed
> user will get stale data
>
> Should we document this?
>

Does this patch alter thus behaviour? User will get stale data even on
HEAD, why should we take a care within this thread?

>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Luca Vallisa 2025-04-01 10:24:46 Re: Self referential foreign keys in partitioned table not working as expected
Previous Message Christoph Berg 2025-04-01 10:18:30 Re: Self referential foreign keys in partitioned table not working as expected