Postgres Pro
Downloads
Home   >   mailing lists

Re: automatically refresh all materialized views? - Mailing list pgsql-general

From Kevin Grittner
Subject Re: automatically refresh all materialized views?
Date
Msg-id 1394565425.99599.YahooMailNeo@web122305.mail.ne1.yahoo.com
Whole thread Raw
In response to Re: automatically refresh all materialized views?  (Marti Raudsepp <marti@juffo.org>)
Responses Re: automatically refresh all materialized views?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: automatically refresh all materialized views?  (Marti Raudsepp <marti@juffo.org>)
List pgsql-general
Tree view 
Marti Raudsepp <marti@juffo.org> wrote:
> Reece Hart <reece@harts.net> wrote:
>
>> I should be able to chase pg_depends entries to create this
>> ordering, right?
>
> Not always, there may be circular dependencies between them.

I haven't been able to think of a way to create circular references
among a set of materialized views, short of committing violence
against the system catalog tables directly. What have I missed?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-general by date:

Previous
From: "Anand Kumar, Karthik"
Date:
Subject: Re: Increase in max_connections
Next
From: John R Pierce
Date:
Subject: Re: replication timeout in pg_basebackup