Re: Advice on using materialized views

2021-12-12 Thread Wicher
On Thu, 09 Dec 2021 16:06:27 + "Phil Endecott" wrote: > Thanks both for your replies. > > Wicher wrote: > > On Mon, 06 Dec 2021 18:48:47 + > > "Phil Endecott" wrote: > >> and > >> I need to modify the definition of a view

Re: Advice on using materialized views

2021-12-07 Thread Wicher
On Mon, 06 Dec 2021 18:48:47 + "Phil Endecott" wrote: > and > I need to modify the definition of a view that filters the "new" > values from the raw table each time the materialised view is > refreshed. You won't necessarily need to rewrite the "recent data" view definitions, I think. Wh

Re: How to reveal the codes of functions properly?

2021-11-30 Thread Wicher
On Tue, 30 Nov 2021 20:17:32 + Shaozhong SHI wrote: > In what environment, that did not work. > > > On Tuesday, 30 November 2021, Rob Sargent wrote: > > > On 11/30/21 9:30 AM, Shaozhong SHI wrote: > > > > Any one can shed the light on this? > > > > Regards, > > > > David > > > > \sf+ func

DDL tools for working with views in dependency order?

2021-11-29 Thread Wicher
on solving this mundane-sounding problem, and I'm curious towards any existing approaches and any PostgreSQL-native primitives that may be of aid. Please share your thoughts and comments! Thanks and regards, Wicher