t...@tim-landscheidt.de (Tim Landscheidt) writes:
> Alvaro Herrera wrote:
>
>>> > It's on Windows
>
>>> I'd go with notify and a listener written in C using c-client to send
>>> emails, but only because I've used those before.
>
>> I wouldn't write it in C but rather Perl or Python, but whatever s
On Wednesday 12 August 2009 6:27:25 am Jan Verheyden wrote:
> Hi,
>
> I got a bit stuck...
> I was looking for a solution for option a)
>
> Maybe I'll first explain the situation a bit more:
>
> I have one database for patient registration
> Another one for image storage
> And a third one for book
Tim Landscheidt wrote:
> The main disadvantage in using a listener is that it is your
> responsibility to make sure that the listener is listening
> 24/7 - from before the database accepts other connections,
> through network failures, bugs, etc. - otherwise notifica-
> tions will be lost. Therefo
Alvaro Herrera wrote:
>> > It's on Windows
>> I'd go with notify and a listener written in C using c-client to send
>> emails, but only because I've used those before.
> I wouldn't write it in C but rather Perl or Python, but whatever suits
> your fancy should work (Visual Basic anyone?). The
Jasen Betts wrote:
> On 2009-08-12, Jan Verheyden wrote:
> > --_000_E30C7040DE22624185BAD4093190B54437BE5DB4A9EX2007MBX2uzk_
> > Content-Type: text/plain; charset="us-ascii"
> > Content-Transfer-Encoding: quoted-printable
> >
> > It's on Windows
> >
>
> I'd go with notify and a listener written i
On 2009-08-12, Jan Verheyden wrote:
> --_000_E30C7040DE22624185BAD4093190B54437BE5DB4A9EX2007MBX2uzk_
> Content-Type: text/plain; charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> It's on Windows
>
I'd go with notify and a listener written in C using c-client to send
emails, bu
On 2009-08-11, Jan Verheyden wrote:
>
> Hi All,
>
> I was looking in what way it's possible to alert via mail when some conditi=
> ons are true in a database.
>
> Thanks in advance!
Assuming you mean email, and not ink on paper (hmm, OTOH you could load
postcards into a printer)
you could d
UCHER'; 'pgsql-sql@postgresql.org'
Subject: Re: [SQL] mail alert
It looks to me like you want Dennis's #2. Lauch a mailer script from a
trigger function. (Function can be any language you're familiar with
including pgsql if you wish to take advantage of
"\! you
: Jan Verheyden; 'pgsql-sql@postgresql.org'
Subject: Re: [SQL] mail alert
Denis BUCHER wrote:
> Hello,
>
> Jan Verheyden a écrit :
>
>> I was looking in what way it’s possible to alert via mail when some
>> conditions are true in a database.
>>
>
It's on Windows
From: ramasubramanian [mailto:ramasubramania...@renaissance-it.com]
Sent: Wednesday, August 12, 2009 6:01 AM
To: Jan Verheyden; pgsql-sql@postgresql.org
Subject: Re: [SQL] mail alert
Hi,
Can you just tell me whether your database is place on which
server(linux/or windo
is not registered yet, is it best to poll on this column to send a warning, or use a trigger??
Thanks!!
Jan
-Original Message-
From: Rob Sargent [mailto:robjsarg...@gmail.com]
Sent: Wednesday, August 12, 2009 3:38 AM
To: Denis BUCHER
Cc: Jan Verheyden; 'pgsql-sql@postgresql.org&
> - Original Message -
> *From:* Jan Verheyden
> *To:* 'pgsql-sql@postgresql.org' <%27pgsql-...@postgresql.org%27>
> *Sent:* Tuesday, August 11, 2009 6:31 PM
> *Subject:* [SQL] mail alert
>
> Hi All,
>
>
>
> I was looking in what way it’s
Hi,
Can you just tell me whether your database is place on which
server(linux/or windows or..)?
- Original Message -
From: Jan Verheyden
To: 'pgsql-sql@postgresql.org'
Sent: Tuesday, August 11, 2009 6:31 PM
Subject: [SQL] mail alert
Hi All,
I was
Denis BUCHER wrote:
Hello,
Jan Verheyden a écrit :
I was looking in what way it’s possible to alert via mail when some
conditions are true in a database.
a) If the alert is not "very urgent" i.e. you can alter some minutes
later I would do it like this :
1. Create a function that ret
Hello,
Jan Verheyden a écrit :
> I was looking in what way it’s possible to alert via mail when some
> conditions are true in a database.
a) If the alert is not "very urgent" i.e. you can alter some minutes
later I would do it like this :
1. Create a function that returns what you need, most imp
Hi All,
I was looking in what way it's possible to alert via mail when some conditions
are true in a database.
Thanks in advance!
Jan
16 matches
Mail list logo
