Re: Musings on Triggers

On Tue, Dec 06, 2005 at 05:36:45PM +0100, A. Kretschmer wrote:
> am  06.12.2005, um 10:49:31 -0500 mailte Joshua Kramer folgendes:
> > Can a trigger in a table in Database_A alter/insert data in a table in
> > Database_B?
>
> No, you can't. (except with dblink)

Or with procedural languages like PL/Perl that allow you to do just
about anything you want (connect to another database, send email,
etc.).  However, a drawback is that you don't get transactional
semantics: if you roll back the transaction there's no way to undo
the trigger's actions.

--
Michael Fuhr