From: | Mark Morgan Lloyd <markMLl(dot)pgsql-general(at)telemetry(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)PostgreSQL(dot)org |
Subject: | Re: Listen/notify, equivalents on other DBs |
Date: | 2015-09-28 08:23:38 |
Message-ID: | muatec$qp1$1@pye-srv-01.telemetry.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thomas Kellerer wrote:
> 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
Thanks for that, very useful. There's minimal info on the
Firebird/Interbase equivalent at
http://www.firebirdsql.org/file/documentation/papers_presentations/Power_Firebird_events.pdf
but my recollection is that it's very lightweight- no useful payload.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
From | Date | Subject | |
---|---|---|---|
Next Message | Ramesh T | 2015-09-28 12:45:00 | Format |
Previous Message | Michael Paquier | 2015-09-28 07:30:39 | Re: issue, dumping and restoring tables with table inheritance can alter column order |