Re: [GENERAL] Create Action for psql when NOTIFY Recieved

2017-08-29 Thread Jerry Regan
Stuart, Thank you! I will investigate. /s/jr Consultant Concerto GR Mobile: 612.208.6601 Concerto - a composition for orchestra and a soloist > On 29Aug, 2017, at 7:52 AM, Stuart Bishop <stu...@stuartbishop.net> wrote: > > On 29 August 2017 at 08:42, Jerry Re

Re: [GENERAL] Create Action for psql when NOTIFY Recieved

2017-08-29 Thread Jerry Regan
writes: >> On Mon, Aug 28, 2017 at 1:28 PM, Jerry Regan < >> jerry.re...@concertoglobalresources.com> wrote: >>> My concern is how, after LISTENing in psql, I can tell it what to do when >>> the NOTItFY is received. > >> ​As far as I am aware you cannot.

Re: [GENERAL] Create Action for psql when NOTIFY Recieved

2017-08-29 Thread Jerry Regan
David, Thanks for your response! /s/jr Consultant Concerto GR Mobile: 612.208.6601 Concerto - a composition for orchestra and a soloist > On 28Aug, 2017, at 5:36 PM, David G. Johnston <david.g.johns...@gmail.com> > wrote: > > On Mon, Aug 28, 2017 at 1:28 PM, Jerry

Re: [GENERAL] Create Action for psql when NOTIFY Recieved

2017-08-29 Thread Jerry Regan
: 612.208.6601 Concerto - a composition for orchestra and a soloist > On 28Aug, 2017, at 6:08 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > > "David G. Johnston" <david.g.johns...@gmail.com> writes: >> On Mon, Aug 28, 2017 at 1:28 PM, Jerry Regan < >> jerry.re

[GENERAL] Create Action for psql when NOTIFY Recieved

2017-08-28 Thread Jerry Regan
I have a 9.4 database. I think I’ve read all the LISTEN and NOTIFY entries in PostgreSQL documentation. I’ve done internet searches, hopefully asking the correct question. But I’m stumped. I want psql to LISTEN for a NOTIFY that a trigger, yet to be defined, issues AFTER INSERT into the

Re: [GENERAL] Using 'WITH SELECT' Results Do Not Match 'SELECT FROM ' Results

2017-07-04 Thread Jerry Regan
:12, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > >> On 07/03/2017 05:20 PM, Jerry Regan wrote: >> Adrian, >> Thank you for your reply! >> I apologize in advance for not being detailed below. Hard to do from my >> phone. >> I did have to move the

Re: [GENERAL] Using 'WITH SELECT' Results Do Not Match 'SELECT FROM ' Results

2017-07-04 Thread Jerry Regan
the other. Thanks again! /s/jr Sent from my iPhone > On Jul 3, 2017, at 18:21, Adrian Klaver <adrian.kla...@aklaver.com> wrote: > >> On 07/02/2017 10:33 AM, Jerry Regan wrote: >> For reasons beyond my control, I am using Postgresql 9.4 on a MacBookPro >> (develop

[GENERAL] Using 'WITH SELECT' Results Do Not Match 'SELECT FROM ' Results

2017-07-03 Thread Jerry Regan
For reasons beyond my control, I am using Postgresql 9.4 on a MacBookPro (development system). I use pgadminIII and psql for clients (I tried and didn’t like the pgadmin4 UI; pg_dump, pg_restore also seem to be dumbed down). My question: I have some performance test results in table