Re: Email notification pgAgent - Mailing list pgadmin-hackers

From Jasmin Dizdarevic
Subject Re: Email notification pgAgent
Date
Msg-id AANLkTim0mj8r-QV0cO0BnUnWrFXDyhrnXZ=iJGfKNZ-w@mail.gmail.com
Whole thread Raw
In response to Re: Email notification pgAgent  (Dave Page <dpage@pgadmin.org>)
Responses Re: Email notification pgAgent  (Dave Page <dpage@pgadmin.org>)
List 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@pgadmin.org>
On Wed, Dec 29, 2010 at 7:30 PM, Jasmin Dizdarevic
> 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

pgadmin-hackers by date:

Previous
From: Dave Page
Date:
Subject: Re: Trac tickets
Next
From: Magnus Hagander
Date:
Subject: Re: Trac tickets