Re: Watching for view changes

From: Mitar <mmitar(at)gmail(dot)com>
To: George Neuner <gneuner2(at)comcast(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Watching for view changes
Date: 2018-12-24 09:01:37
Message-ID: CAKLmikOWV8_SDsD=8GQYdNYW1WuZn9MuZYRPhxmunNp3q4a5Cg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

On Sun, Dec 23, 2018 at 11:59 PM George Neuner <gneuner2(at)comcast(dot)net> wrote:
> IIRC the cache table's name is generated. I don't know the proper
> incantations to get it from the catalogs, but an easy way to find it
> is to put the materialized view into its own tablespace, then search
> pg_tables for objects in that space.

Oh, what a trick. :-)

Mitar

--
http://mitar.tnode.com/
https://twitter.com/mitar_m

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitar 2018-12-24 09:16:53 Re: Watching for view changes
Previous Message Mitar 2018-12-24 09:01:08 Re: Watching for view changes