Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g8PYz-0007Bb-Qp for pgsql-admin@arkaria.postgresql.org; Fri, 05 Oct 2018 12:50:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g8PYx-0001FT-Px for pgsql-admin@arkaria.postgresql.org; Fri, 05 Oct 2018 12:50:35 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g8PYx-0001FD-IV for pgsql-admin@lists.postgresql.org; Fri, 05 Oct 2018 12:50:35 +0000 Received: from sdcsmtp.sdc-world.com ([24.153.34.136]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g8PYu-0004U8-Fk for pgsql-admin@postgresql.org; Fri, 05 Oct 2018 12:50:34 +0000 X-ASG-Debug-ID: 1538743829-1075dd169d11f390001-ysJW5H Received: from sdcsrvex01.sdc-world.com (sdcsrvex01.sdc-world.com [192.168.11.133]) by sdcsmtp.sdc-world.com with ESMTP id sPOqsAnNUwoPcsAc (version=TLSv1 cipher=AES128-SHA bits=128 verify=NO) for ; Fri, 05 Oct 2018 08:50:29 -0400 (EDT) X-Barracuda-Envelope-From: denise.ferrell@sdc-world.com X-ASG-Whitelist: Client Received: from SDCX.sdc-world.com (192.168.11.131) by SDCSRVEX01.sdc-world.com (192.168.11.133) with Microsoft SMTP Server (TLS) id 8.3.485.1; Fri, 5 Oct 2018 08:50:29 -0400 Received: from SDCX.sdc-world.com (192.168.11.131) by SDCX.sdc-world.com (192.168.11.131) with Microsoft SMTP Server (TLS) id 15.0.1347.2; Fri, 5 Oct 2018 08:50:28 -0400 Received: from SDCX.sdc-world.com ([::1]) by SDCX.sdc-world.com ([::1]) with mapi id 15.00.1347.000; Fri, 5 Oct 2018 08:50:28 -0400 From: "Ferrell, Denise SDC" To: "pgsql-admin@postgresql.org" Subject: Auto update on a query Thread-Topic: Auto update on a query X-ASG-Orig-Subj: Auto update on a query Thread-Index: AQHUXKnOz9SIIxGLxECDIbdr0jAzTw== Date: Fri, 5 Oct 2018 12:50:28 +0000 Message-ID: <1538743828462.38830@sdc-world.com> References: <1538731399550-0.post@n3.nabble.com> In-Reply-To: <1538731399550-0.post@n3.nabble.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-ms-exchange-transport-fromentityheader: Hosted x-originating-ip: [138.162.0.42] Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Barracuda-Connect: sdcsrvex01.sdc-world.com[192.168.11.133] X-Barracuda-Start-Time: 1538743829 X-Barracuda-Encrypted: AES128-SHA X-Barracuda-URL: https://192.168.11.136:443/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at sdc-world.com X-Barracuda-Scan-Msg-Size: 203 X-Barracuda-BRTS-Status: 1 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk =0A= Using Redhat 6, Postgres 9.5=0A= =0A= I have a user that wants to run a query once and then automatically receive= updates (inserts) without having to rerun the query. Any ideas would be a= ppreciated.=0A= =0A= r,=0A= Denise=