On 12/20/18 7:54 AM, Mitar wrote:
> Hi!
>
> Thanks. Care for a link or at least thread subject?
https://www.postgresql.org/message-id/CA%2BFnnTxqScf6mDw_7HLMfu7YTagPrsYUw-bc%3DOKsBQ0TqprvEA%40mail.gmail.com
>
> Also, Googling around this seems a pretty popular request. I am quite
> surprised that there is not something out-of-box available for this,
> efficient and scalable.
>
>
> Mitar
>
> On Thu, Dec 20, 2018 at 7:33 AM Ron <ronljohnsonjr@gmail.com> wrote:
>>
>> 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.
>>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
