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@xxxxxxxxx> 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@xxxxxxxxxxx
