Horton

Re: Re: [HACKERS] Postgresql OO Patch

Hannu Krosing <hannu@tm.ee>

View thread
From: Hannu Krosing <hannu@tm.ee>
To: Marten Feldtmann <marten@feki.toppoint.de>
Cc: Chris Bitmead <chrisb@nimrod.itg.telstra.com.au>, "Robert B. Easter" <reaster@comptechnews.com>, Peter Eisentraut <peter_e@gmx.net>, Postgres Hackers List <hackers@postgresql.org>, pgsql-general@postgresql.org
Date: 2000-05-24T14:17:48Z
Lists: pgsql-hackers 
Marten Feldtmann wrote:
> 
>  But here again an active system may be build on top of the system we
> already have:
> 
>  - update, insert, deletes are catched via triggers (on commit)
>    these trigger functions do retrieve the object-id of the objects
>    changed and write the result into a special table.
> 
>  - another software has notification on this special table and managed
>    the ip-commuication to the clients.

Extending NOTIFY to take at least ONE string argument or OID would go a 
long long way. Even better would be for it to take an "Object", in the 
one-supertable sense.

So triggers or whatever can just notify interested parties about changes.

This has been on my personal todo for severeal years already ;)

--------------
Hannu