Re: Listen/notify, equivalents on other DBs - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Listen/notify, equivalents on other DBs
Date
Msg-id mu5hjr$k6c$1@ger.gmane.org
Whole thread Raw
In response to Listen/notify, equivalents on other DBs  (Mark Morgan Lloyd <markMLl.pgsql-general@telemetry.co.uk>)
Responses Re: Listen/notify, equivalents on other DBs
List pgsql-general
Mark Morgan Lloyd schrieb am 25.09.2015 um 23:41:
> I'm trying to get support for PostgreSQL's listen/notify into a
> development environment, but since it supports multiple database
> backends: can anybody comment on how many other servers have a
> comparable facility?
>
> Minimal research has allowed me to code something for
> Firebird/Interbase, but I'm not in a position to investigate Oracle,
> IBM, MS and the rest. I'd appreciate any general comments from
> somebody who has broad SQL experience, I'm not asking for example
> code.

For Oracle this would be the "change notification" feature which
goes beyond what Postgres can do if I'm not mistaken as you can
register a query and the client is notified if the result of that
query would change:

http://docs.oracle.com/database/121/JJDBC/dbchgnf.htm#JJDBC28815




pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Test failover for PosgreSql 9.2
Next
From: "Andrus"
Date:
Subject: How to speed up delete where not in