Re: sending mail from Postgres - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: sending mail from Postgres
Date
Msg-id 43B3126B.4010909@wildenhain.de
Whole thread Raw
In response to Re: sending mail from Postgres  (Tony Caduto <tony.caduto@amsoftwaredesign.com>)
Responses Re: sending mail from Postgres
List pgsql-general
Tony Caduto schrieb:
> Tino Wildenhain wrote:
>
>>
>> We do not talk about exceptions here. I'm talking about transactions.
>> And you never know who will be aborting a transaction after your
>> call to the function. No need for referral to the fine manuals :-)
>>
>
> Common Tino, you let users abort transactions? Who else is going to be
> aborting transactions besides you the programmer?
> I would never allow that as they would mess everything up.

Actually not. There are several reasons why a transaction can
abort - do you cover all your queries in functions?
This would be a little bit unusual, to say at least.
Every query can fail. Its useless to do error
catching in your app if the server actually rolled back
due to an error and yet sent the mail :-)

Just curious, what framework do you use for your frontend
applications?

Have a nice day
Tino

pgsql-general by date:

Previous
From: Tony Caduto
Date:
Subject: Re: sending mail from Postgres
Next
From: Chris Travers
Date:
Subject: Re: FW: Re[2]: new beginner to postgresql. Looking at