Re: [GENERAL] Watching Views

2014-09-18 Thread Nick Guenther
Ah! Your reply was excellent, David. I only found it now, cleaning out my inbox. Comments inline! Quoting David G Johnston david.g.johns...@gmail.com: Nick Guenther wrote As you said, attaching the trigger to a view is useless (for BEFORE/AFTER, which I'm interested in, also only works on

Re: [GENERAL] Watching Views

2014-07-23 Thread Nick Guenther
Quoting David G Johnston david.g.johns...@gmail.com: Nick Guenther wrote Dear List, In principle, I am looking for some way to say ``` CREATE VIEW view13131 AS select (id, name, bank_account) from actors where age 22; WATCH view13131; ``` and get output to stdout like ``` INSERT

Re: [GENERAL] Watching Views

2014-07-23 Thread David G Johnston
Nick Guenther wrote As you said, attaching the trigger to a view is useless (for BEFORE/AFTER, which I'm interested in, also only works on statement level changes, which I would rather not have to deal with). I tried attaching my trigger to a materialized view and found that postgres

[GENERAL] Watching Views

2014-07-17 Thread Nick Guenther
Dear List, I am interested in replicating views of my data in real time to a frontend visualizer. I've looked around, and it seems that most applications in this direction write some ad-hoc json-formatter that spits out exactly the columns it is interested in. I want something more like

Re: [GENERAL] Watching Views

2014-07-17 Thread David G Johnston
Nick Guenther wrote Dear List, I am interested in replicating views of my data in real time to a frontend visualizer. I've looked around, and it seems that most applications in this direction write some ad-hoc json-formatter that spits out exactly the columns it is interested in. I