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
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 to a
socket
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 plperl, also how
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
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
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 the
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
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
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 it? All
- Original Message -
From: Vivek Khera [EMAIL PROTECTED]
To: PG-General General pgsql-general@postgresql.org
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 separate process
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 program.
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
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
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
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
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
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 messages, plus
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 plperl, also how
18 matches
Mail list logo