[Lazarus] Postgresql listen/notify
Mark Morgan Lloyd
markMLl.lazarus at telemetry.co.uk
Tue May 8 11:07:18 CEST 2012
Marco van de Voort wrote:
> On Tue, May 08, 2012 at 08:01:45AM +0000, Mark Morgan Lloyd wrote:
>> I don't know whether it should be treated as a candidate for an
>> extension to the sql-db API, since as far as I know there's something
>> comparable (implemented very differently) on Firebird but nothing else.
>
> If it is table or row change notifications, MSSQL has it since iirc version
> 2005.
It's not, PostgreSQL would probably call those triggers. It's a general
notification mechanism which can be used between programs connected to
the same database irrespective of what they're doing with tables, see
http://www.postgresql.org/docs/8.2/static/sql-notify.html (I've
intentionally referenced a fairly old version there, since recent
changes have added an additional parameter etc.).
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinions above are the author's, not those of his employers or colleagues]
More information about the Lazarus
mailing list