Thread: pgadmin 1.8.4 pgagent schedule issue

pgadmin 1.8.4 pgagent schedule issue

From
susan.williams@us.michelin.com
Date:
<br /><font face="sans-serif" size="2">I am experiencing an issue with pgadmin 1.8.4 (Windows).  The issue is with the
pgagentjob scheduler.  I am able to create new jobs and steps.  However, I am unable to create a new schedule.  I am
alsounable to edit / change a schedule that currently exist.  The schedule window informs me that I must enter a start
date. I do this and it still does not recognize that it has a date and will not activate the OK button even though
thereis a visible date in the field.  I have used the drop down in the field as well as tried typing in the date with
noluck.  One of my co-workers is having the same problem and is running the same version (1.8.4 - however he is running
linux).  The other co-worker is not having this problem and is running version 1.8.0 (linux ).  I tried to go back to
1.8.0(Windows);but, was still unable to create a new schedule.  Thanks for your assistance regarding this
issue.</font><br/><br /><font face="sans-serif" size="2">Susan Williams<br /> Michelin North America<br /> 1401 Antioch
ChurchRoad<br /> Greenville, SC  29605<br /> IS/US1<br /> Phone: 864-458-1455 (internal: x71455 or 787-1455) <br /><br
/>D3 – Michelin Restricted<br /> Retention: 201-101 < 90 Days <br /></font> 

Re: pgadmin 1.8.4 pgagent schedule issue

From
"Dave Page"
Date:
On Thu, Oct 2, 2008 at 4:21 PM,  <susan.williams@us.michelin.com> wrote:
>
> I am experiencing an issue with pgadmin 1.8.4 (Windows).  The issue is with
> the pgagent job scheduler.  I am able to create new jobs and steps.
>  However, I am unable to create a new schedule.  I am also unable to edit /
> change a schedule that currently exist.  The schedule window informs me that
> I must enter a start date.  I do this and it still does not recognize that
> it has a date and will not activate the OK button even though there is a
> visible date in the field.  I have used the drop down in the field as well
> as tried typing in the date with no luck.  One of my co-workers is having
> the same problem and is running the same version (1.8.4 - however he is
> running linux ).  The other co-worker is not having this problem and is
> running version 1.8.0 (linux ).  I tried to go back to 1.8.0(Windows); but,
> was still unable to create a new schedule.  Thanks for your assistance
> regarding this issue.
>

It works for me on OS X, though somewhat annoyingly it seems to be
using MM/DD/YYYY. If you modify another control after selecting the
date (ie. add a comment), does that allow it to recognise there's a
date there?

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com


Re: pgadmin 1.8.4 pgagent schedule issue

From
susan.williams@us.michelin.com
Date:
<br /><font face="sans-serif" size="2">Dave - I added comments; but, it still doesn't recognize the date even though it
isthere.  The date in the start date field is 10/03/08.  I tried using the format you used below.  When I manually
typedin the date 10/03/2008, it removed the visible date from the field.</font><br /><br /><font face="sans-serif"
size="2">SusanWilliams<br /> Michelin North America<br /> 1401 Antioch Church Road<br /> Greenville, SC  29605<br />
IS/US1<br/> Phone: 864-458-1455 (internal: x71455 or 787-1455) <br /><br /> D3 – Michelin Restricted<br /> Retention:
201-101< 90 Days <br /></font><br /><br /><br /><table width="100%"><tr valign="top"><td width="40%"><font
face="sans-serif"size="1"><b>"Dave Page" <dpage@pgadmin.org></b> </font><p><font face="sans-serif"
size="1">10/02/0812:01</font></td><td width="59%"><table width="100%"><tr valign="top"><td><div align="right"><font
face="sans-serif"size="1">To</font></div></td><td><font face="sans-serif"
size="1">susan.williams@us.michelin.com</font></td></tr><trvalign="top"><td><div align="right"><font face="sans-serif"
size="1">cc</font></div></td><td><fontface="sans-serif" size="1">pgadmin-support@postgresql.org</font></td></tr><tr
valign="top"><td><divalign="right"><font face="sans-serif" size="1">Subject</font></div></td><td><font
face="sans-serif"size="1">Re: [pgadmin-support] pgadmin 1.8.4 pgagent schedule issue</font></td></tr></table><br
/><table><trvalign="top"><td></td><td></td></tr></table><br /></td></tr></table><br /><br /><br /><tt><font size="2">On
Thu,Oct 2, 2008 at 4:21 PM,  <susan.williams@us.michelin.com> wrote:<br /> ><br /> > I am experiencing an
issuewith pgadmin 1.8.4 (Windows).  The issue is with<br /> > the pgagent job scheduler.  I am able to create new
jobsand steps.<br /> >  However, I am unable to create a new schedule.  I am also unable to edit /<br /> > change
aschedule that currently exist.  The schedule window informs me that<br /> > I must enter a start date.  I do this
andit still does not recognize that<br /> > it has a date and will not activate the OK button even though there is
a<br/> > visible date in the field.  I have used the drop down in the field as well<br /> > as tried typing in
thedate with no luck.  One of my co-workers is having<br /> > the same problem and is running the same version
(1.8.4- however he is<br /> > running linux ).  The other co-worker is not having this problem and is<br /> >
runningversion 1.8.0 (linux ).  I tried to go back to 1.8.0(Windows); but,<br /> > was still unable to create a new
schedule. Thanks for your assistance<br /> > regarding this issue.<br /> ><br /><br /> It works for me on OS X,
thoughsomewhat annoyingly it seems to be<br /> using MM/DD/YYYY. If you modify another control after selecting the<br
/>date (ie. add a comment), does that allow it to recognise there's a<br /> date there?<br /><br /> -- <br /> Dave
Page<br/> EnterpriseDB UK:   http://www.enterprisedb.com<br /></font></tt><br /> 

Re: pgadmin 1.8.4 pgagent schedule issue

From
"Dave Page"
Date:
On Thu, Oct 2, 2008 at 6:01 PM,  <susan.williams@us.michelin.com> wrote:
>
> Dave - I added comments; but, it still doesn't recognize the date even
> though it is there.  The date in the start date field is 10/03/08.  I tried
> using the format you used below.  When I manually typed in the date
> 10/03/2008, it removed the visible date from the field.


I've just been testing on Windows XP, and no matter what I do it seems
to work fine. I've tried with regional settings set to both US and UK.

Can anyone else (preferrably with a dev environment) reproduce this?

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com


Re: pgadmin 1.8.4 pgagent schedule issue

From
susan.williams@us.michelin.com
Date:
<br /><font face="sans-serif" size="2">Dave - I can't reproduce this on a test machine.  Below is what I did.  Is there
anothermethod you would like me to use?</font><br /><br /><font face="sans-serif" size="2">I installed pgadmin 1.8.0 on
atest machine (windows xp sp2).  I was able to add a schedule using 1.8.0.  I then upgraded pgadmin to 1.8.4.  I was
ableto add a schedule using 1.8.4 as well on this test machine.  I'm still not able to add a schedule on my primary
machine(windows xp sp2).  My coworker is still unable to add a schedule on his primary machine (linux gentoo).  My
othercoworker can add a schedule on his primary machine (linux).</font><br /><br /><br /><font face="sans-serif"
size="2">SusanWilliams<br /> Michelin North America<br /> 1401 Antioch Church Road<br /> Greenville, SC  29605<br />
IS/US1<br/> Phone: 864-458-1455 (internal: x71455 or 787-1455) <br /><br /> D3 – Michelin Restricted<br /> Retention:
201-101< 90 Days <br /></font><br /><br /><br /><table width="100%"><tr valign="top"><td width="40%"><font
face="sans-serif"size="1"><b>"Dave Page" <dpage@pgadmin.org></b> </font><p><font face="sans-serif"
size="1">10/03/0804:14</font></td><td width="59%"><table width="100%"><tr valign="top"><td><div align="right"><font
face="sans-serif"size="1">To</font></div></td><td><font face="sans-serif"
size="1">susan.williams@us.michelin.com</font></td></tr><trvalign="top"><td><div align="right"><font face="sans-serif"
size="1">cc</font></div></td><td><fontface="sans-serif" size="1">pgadmin-support@postgresql.org,
jared.alewine@us.michelin.com</font></td></tr><trvalign="top"><td><div align="right"><font face="sans-serif"
size="1">Subject</font></div></td><td><fontface="sans-serif" size="1">Re: [pgadmin-support] pgadmin 1.8.4 pgagent
scheduleissue</font></td></tr></table><br /><table><tr valign="top"><td></td><td></td></tr></table><br
/></td></tr></table><br/><br /><br /><tt><font size="2">On Thu, Oct 2, 2008 at 6:01 PM,
 <susan.williams@us.michelin.com>wrote:<br /> ><br /> > Dave - I added comments; but, it still doesn't
recognizethe date even<br /> > though it is there.  The date in the start date field is 10/03/08.  I tried<br />
>using the format you used below.  When I manually typed in the date<br /> > 10/03/2008, it removed the visible
datefrom the field.<br /><br /><br /> I've just been testing on Windows XP, and no matter what I do it seems<br /> to
workfine. I've tried with regional settings set to both US and UK.<br /><br /> Can anyone else (preferrably with a dev
environment)reproduce this?<br /><br /> -- <br /> Dave Page<br /> EnterpriseDB UK:   http://www.enterprisedb.com<br
/></font></tt><br/> 

Re: pgadmin 1.8.4 pgagent schedule issue

From
"Dave Page"
Date:
On Fri, Oct 3, 2008 at 2:35 PM,  <susan.williams@us.michelin.com> wrote:
>
> Dave - I can't reproduce this on a test machine.  Below is what I did.  Is
> there another method you would like me to use?
>
> I installed pgadmin 1.8.0 on a test machine (windows xp sp2).  I was able to
> add a schedule using 1.8.0.  I then upgraded pgadmin to 1.8.4.  I was able
> to add a schedule using 1.8.4 as well on this test machine.  I'm still not
> able to add a schedule on my primary machine (windows xp sp2).  My coworker
> is still unable to add a schedule on his primary machine (linux gentoo).  My
> other coworker can add a schedule on his primary machine (linux).

Hmm, so it is something specific to a few machines then - though it's
odd that it is affecting both Windows and Linux.

What regional settings do you have setup on the machine that doesn't
work? Any differences to the one that's OK?

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com


Re: pgadmin 1.8.4 pgagent schedule issue

From
susan.williams@us.michelin.com
Date:
<br /><font face="sans-serif" size="2">Dave - You are a rock star!  Once I changed my regional settings on my primary
PCfor the date from MM\dd\yy to M\d\yyyy, I was able to add a new schedule.  My coworker who uses linux is off today.
 Iwill ask him to look at his regional settings when he returns next week.  Thanks for the help.</font><br /><br
/><fontface="sans-serif" size="2">Susan Williams<br /> Michelin North America<br /> 1401 Antioch Church Road<br />
Greenville,SC  29605<br /> IS/US1<br /> Phone: 864-458-1455 (internal: x71455 or 787-1455) <br /><br /> D3 – Michelin
Restricted<br/> Retention: 201-101 < 90 Days <br /></font><br /><br /><br /><table width="100%"><tr valign="top"><td
width="40%"><fontface="sans-serif" size="1"><b>"Dave Page" <dpage@pgadmin.org></b> </font><p><font
face="sans-serif"size="1">10/03/08 09:42</font></td><td width="59%"><table width="100%"><tr valign="top"><td><div
align="right"><fontface="sans-serif" size="1">To</font></div></td><td><font face="sans-serif"
size="1">susan.williams@us.michelin.com</font></td></tr><trvalign="top"><td><div align="right"><font face="sans-serif"
size="1">cc</font></div></td><td><fontface="sans-serif" size="1">jared.alewine@us.michelin.com,
pgadmin-support@postgresql.org</font></td></tr><trvalign="top"><td><div align="right"><font face="sans-serif"
size="1">Subject</font></div></td><td><fontface="sans-serif" size="1">Re: [pgadmin-support] pgadmin 1.8.4 pgagent
scheduleissue</font></td></tr></table><br /><table><tr valign="top"><td></td><td></td></tr></table><br
/></td></tr></table><br/><br /><br /><tt><font size="2">On Fri, Oct 3, 2008 at 2:35 PM,
 <susan.williams@us.michelin.com>wrote:<br /> ><br /> > Dave - I can't reproduce this on a test machine.
 Belowis what I did.  Is<br /> > there another method you would like me to use?<br /> ><br /> > I installed
pgadmin1.8.0 on a test machine (windows xp sp2).  I was able to<br /> > add a schedule using 1.8.0.  I then upgraded
pgadminto 1.8.4.  I was able<br /> > to add a schedule using 1.8.4 as well on this test machine.  I'm still not<br
/>> able to add a schedule on my primary machine (windows xp sp2).  My coworker<br /> > is still unable to add a
scheduleon his primary machine (linux gentoo).  My<br /> > other coworker can add a schedule on his primary machine
(linux).<br/><br /> Hmm, so it is something specific to a few machines then - though it's<br /> odd that it is
affectingboth Windows and Linux.<br /><br /> What regional settings do you have setup on the machine that doesn't<br />
work?Any differences to the one that's OK?<br /><br /> -- <br /> Dave Page<br /> EnterpriseDB UK:  
http://www.enterprisedb.com<br/></font></tt><br /> 

Re: pgadmin 1.8.4 pgagent schedule issue

From
Raymond O'Donnell
Date:
On 03/10/2008 16:01, susan.williams@us.michelin.com wrote:

> Dave - You are a rock star!

Dave a rock star? ...hmm....yeah, I could picture that!
;-)

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------


Re: pgadmin 1.8.4 pgagent schedule issue

From
"Dave Page"
Date:
On Fri, Oct 3, 2008 at 5:03 PM, Raymond O'Donnell <rod@iol.ie> wrote:
> On 03/10/2008 16:01, susan.williams@us.michelin.com wrote:
>
>> Dave - You are a rock star!
>
> Dave a rock star? ...hmm....yeah, I could picture that!
> ;-)

Unfortunately those days are long past :-(

http://www.flickr.com/photos/29058417@N03/2910566174/in/photostream/
(not for the faint of heart!)

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com


Re: pgadmin 1.8.4 pgagent schedule issue

From
Raymond O'Donnell
Date:
On 03/10/2008 20:53, Dave Page wrote:

> http://www.flickr.com/photos/29058417@N03/2910566174/in/photostream/
> (not for the faint of heart!)

Wow!

My wife reckons that you look better than Jon Bon Jovi! :-)

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------


Re: pgadmin 1.8.4 pgagent schedule issue

From
"Dave Page"
Date:
On Fri, Oct 3, 2008 at 8:56 PM, Raymond O'Donnell <rod@iol.ie> wrote:
> On 03/10/2008 20:53, Dave Page wrote:
>
>> http://www.flickr.com/photos/29058417@N03/2910566174/in/photostream/
>> (not for the faint of heart!)
>
> Wow!
>
> My wife reckons that you look better than Jon Bon Jovi! :-)

Err, thanks. Perhaps she should visit SpecSavers tomorrow?

:-)

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com


Re: pgadmin 1.8.4 pgagent schedule issue

From
Magnus Hagander
Date:
Raymond O'Donnell wrote:
> On 03/10/2008 16:01, susan.williams@us.michelin.com wrote:
> 
>> Dave - You are a rock star!
> 
> Dave a rock star? ...hmm....yeah, I could picture that!
> ;-)

In some shady memory, haven't I been told that he used to actually *be*
that? :-)

//Magnus