Yep, we try to keep all the sql in functions/procedures as it makes
updates a lot easier and keeps the business logic seperate from the
client application.
We use native compiled front ends (Delphi) for windows and Lazarus for
everything else. When you keep everything in a function/proc it make
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 a
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
> "Ted" == Ted Byers <[EMAIL PROTECTED]> writes:
Ted> Here is a general question relating to this. The problem involves due
Ted> diligence related to environmental protection. Consider a distributed
Ted> application to support this. You have a facility with an
Ted> environmental monitoring
- Original Message -
From: "Vivek Khera" <[EMAIL PROTECTED]>
To: "PG-General General"
Sent: Wednesday, December 28, 2005 11:48 AM
Subject: Re: [GENERAL] sending mail from Postgres
On Dec 28, 2005, at 8:28 AM, Christopher Browne wrote:
Some separat
Tony Caduto schrieb:
> Tino Wildenhain wrote:
>
>> How do you stop your server sending mail in case a transaction goes
>> wild and is sending mails for every updated row in a some megs table?
>>
>
> It would not be smart to send a email via a trigger that updates or
> inserts 1000s of rows would
On Dec 28, 2005, at 8:28 AM, Christopher Browne wrote:
Some separate process (perhaps polling, perhaps using NOTIFY/LISTEN)
would then grab messages from the table and submit them to [whatever
is the communications layer].
That is a clean sort of design for that sort of thing.
This is precis
Tino Wildenhain wrote:
How do you stop your server sending mail in case a transaction goes
wild and is sending mails for every updated row in a some megs table?
It would not be smart to send a email via a trigger that updates or
inserts 1000s of rows would it? All the times I have used PL P
Tony Caduto schrieb:
> Tino,
> I am talking about corporate apps, there would never be thousands of
> emails in the email servers inbound queue from just a few database
> applications. (anyway a thousand emails in a Postfix queue is nothing)
>
> Sometimes it is best to send the email right from th
And you can code a trigger that fires when there is a difference of 60
days between dates(I have apps that do so...,and the trigger sends a email)
I guess I should expand on this more, the trigger is fired via a
insert/update into a table called logons, when a user logs on to the
system a re
Tino,
I am talking about corporate apps, there would never be thousands of
emails in the email servers inbound queue from just a few database
applications. (anyway a thousand emails in a Postfix queue is nothing)
Sometimes it is best to send the email right from the client app, but in
many sit
> On Tue, 2005-12-27 at 20:58 -0800, Randal L. Schwartz wrote:
>> > "Tony" == Tony Caduto <[EMAIL PROTECTED]> writes:
>>
>> Tony> Check out my site at http://www.amsoftwaredesign.com
>>
>> Tony> and click on the forums link, I have some examples on how to send a
>> Tony> email from a function
Tony Caduto schrieb:
> Randal L. Schwartz wrote:
>
>> I fear for the future.
>>
>> Did someone forget what a "database" is for?
>>
>
> You have nothing to fear but fear itself
> (FDR http://historymatters.gmu.edu/d/5057/)
>
> Let us see why this might be handy(sending a email or connecting t
Randal L. Schwartz wrote:
I fear for the future.
Did someone forget what a "database" is for?
You have nothing to fear but fear itself
(FDR http://historymatters.gmu.edu/d/5057/)
Let us see why this might be handy(sending a email or connecting to a
socket server).
The email function
On Tue, 2005-12-27 at 20:58 -0800, Randal L. Schwartz wrote:
> > "Tony" == Tony Caduto <[EMAIL PROTECTED]> writes:
>
> Tony> Check out my site at http://www.amsoftwaredesign.com
>
> Tony> and click on the forums link, I have some examples on how to send a
> Tony> email from a function using p
> "Tony" == Tony Caduto <[EMAIL PROTECTED]> writes:
Tony> Check out my site at http://www.amsoftwaredesign.com
Tony> and click on the forums link, I have some examples on how to send a
Tony> email from a function using plperl, also how to connect to a simple
Tony> socket server and send messa
Aftab Alam wrote:
Hi there,
How can i send mail form postgresql.
which language i can use,for that some thing i have to install for postgres.
Kindly suggest.
thanx & regards
aftab
Check out my site at http://www.amsoftwaredesign.com
and click on the forums link, I have some examples on ho
Hi there,
How can i send mail form postgresql.
which language i can use,for that some thing i have to install for postgres.
Kindly suggest.
thanx & regards
aftab
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settin
18 matches
Mail list logo
