Skip site navigation (1) Skip section navigation (2)

Re: Email notification pgAgent

From: Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com>
To: Dave Page <dpage(at)pgadmin(dot)org>, pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Email notification pgAgent
Date: 2010-12-31 15:09:22
Message-ID: AANLkTim0mj8r-QV0cO0BnUnWrFXDyhrnXZ=iJGfKNZ-w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-hackers
Hi,

back to the main topic: Email notification.

This week I tried to use the wxSMTP library for the email notification
feature - without success. There are two versions of the lib. One will not
be supported in the future, the other is an alpha or beta. I hope this
extensions will be available as a contrib module for wx in the near future.
I also couldn't find any other multi platform library, which is open source.
Do you know one?

Another idea was to use a command line tool, which is available for *nix and
windows (http://caspian.dotconf.net/menu/Software/SendEmail/) and invoke it
via Exec in pgAgent.

Is this a practicable way for you?

Jasmin


2010/12/31 Dave Page <dpage(at)pgadmin(dot)org>

> On Wed, Dec 29, 2010 at 7:30 PM, Jasmin Dizdarevic
> <jasmin(dot)dizdarevic(at)gmail(dot)com> wrote:
> >
> > Hi,
> > I'm not so keen on that - it could require some funky code to ensure
> > that the user uses sequential (or at least, non-duplicate) numbers
> > across all steps and would be a pain to upgrade to. Plus, there is
> > precedence for using alpha ordering - that's how triggers work
> >> I don't think that we must ensure that no duplicate values are used.
> With
> >> changing the "order by jstname,jstid" clause to "order by
> >> jstorder,jstname,jstid" we would have a fall back on alpha ordering.
> >> Steps with "jstorder" = null would be executed last - so there is no
> need to
> >> upgrade. To give the user feedback about ordering in pgadmin, the steps
> >> could be ordered the same way in tree view and steps tab in job
> properties
> >> dialog. We could also add the jstorder-column to the list view.
>
> What do others think? I'm still not convinced this is necessary - and
> it certainly will become inconsistent with triggers.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

In response to

Responses

pgadmin-hackers by date

Next:From: Magnus HaganderDate: 2010-12-31 15:09:38
Subject: Re: Trac tickets
Previous:From: Dave PageDate: 2010-12-31 15:07:36
Subject: Re: Trac tickets

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group