Re: Question on triggers and plpgsql - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Question on triggers and plpgsql
Date
Msg-id 20050408155040.GC27718@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Question on triggers and plpgsql  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
On Fri, Apr 08, 2005 at 11:35:47AM -0400, Tom Lane wrote:
> What this does do for you is replace the risk of phantom emails (mail
> sent but corresponding action inside the database never committed)
> with the risk of duplicate emails (mail-sender sends you another one
> after it restarts).  In most cases I think I'd prefer the latter.

Me too.  Besides, you already have this risk with SMTP, because a
message can be queued and accepted on the remote side when the local
side goes away, so that the session is completed improperly. 
Depending on configuration and a bunch of painful start-up
possibilities with the server, you might well get a duplicate copy of
a mail transmitted later.  (In the present age, given the remarkable
quality of networks and mail servers everyone has, you almost never
have this happen any more.  But it's still strictly speaking
possible.)

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The fact that technology doesn't work is no bar to success in the marketplace.    --Philip Greenspun


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Question on triggers and plpgsql
Next
From: Richard Huxton
Date:
Subject: Re: Question on triggers and plpgsql