Re: Watching for view changes - Mailing list pgsql-general

From Ron
Subject Re: Watching for view changes
Date
Msg-id 8ce68eb6-4bae-447c-b9d2-f25e0c02546d@gmail.com
Whole thread Raw
In response to Watching for view changes  (Mitar <mmitar@gmail.com>)
Responses Re: Watching for view changes  (Mitar <mmitar@gmail.com>)
List pgsql-general
On 12/20/18 3:17 AM, Mitar wrote:
> Hi!
>
> I am trying to see how I could use NOTIFY/LISTEN to watch changes of a
> complicated SELECT query which spans multiple tables. Ideally, I would
> like to leave to PostgreSQL to determine when some data (and which
> data) in the result of the SELECT query has changed. So I am thinking
[snip]

There was a LONG thread on this list a few months ago about monitoring for 
DDL changes.  It should prove helpful (or cause you to despair).


-- 
Angular momentum makes the world go 'round.


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: libpq PQexecParams & value placeholders
Next
From: Mitar
Date:
Subject: Re: Watching for view changes