| From: | Chris Jones <chris(at)mt(dot)sri(dot)com> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Re: a primer on trigger? |
| Date: | 2001-05-04 20:33:55 |
| Message-ID: | 20010504143355.J10812@mt.sri.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, May 04, 2001 at 12:59:54PM -0700, Stephan Szabo wrote:
> The problem is that you have the problem in reverse then, unless what's
> done by the trigger is "optional" sortof. What happens if there is an
> error, and you can't do the outside operation? You once again end up
> out of sync with the database, but this time the outside thing is missing
> the records. You still need something to come in every so often and make
> sure stuff is correct.
>
> This whole class of things is just ugly.
I'm a little weak on database theory, but isn't this what two-phase
commit is for?
Chris
--
chris(at)mt(dot)sri(dot)com -----------------------------------------------------
Chris Jones SRI International, Inc.
www.sri.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mitch Vincent | 2001-05-04 20:46:51 | Re: Newbie Question |
| Previous Message | Joseph Shraibman | 2001-05-04 20:31:58 | Re: Auto-timestamp generator (attached) |