| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Musings on Triggers |
| Date: | 2005-12-06 17:16:56 |
| Message-ID: | 20051206171656.GA97243@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | operationsengineer1 | 2005-12-06 18:29:57 | Re: SQL Statement Help Needed |
| Previous Message | Walter | 2005-12-06 17:01:02 | CSV file - Using COPY Command - Double-Quotes |