Hi Dave,
{"keep on the list! :)))" Dave said}
Yeah, I'll build something for Eric tomorrow morning.
Cheers,
Raph
----Message d'origine----
>Sujet: RE: [pgadmin-support] pgagent status always successful
>Date: Tue, 11 Jul 2006 21:51:19 +0100
>De: "Dave Page" <dpage@vale-housing.co.uk>
>A: <erics@ameri-title.com>
>Copie à: Raphaël Enrici <blacknoz@club-internet.fr>
>
>
>
>> -----Original Message-----
>> From: Eric Shuman [mailto:erics@ameri-title.com]
>> Sent: 05 July 2006 22:07
>> To: Dave Page
>> Subject: RE: [pgadmin-support] pgagent status always successful
>>
>> Hi Dave,
>>
>> The "On Error" flag is set to fail.
>>
>> The script will run, but I have been trying to make it fail
>> by entering bad
>> code or wrong filenames just to test if the job would fail
>> and to see what
>> my statistics would be like when it does.
>>
>> The result values I get now in pgAdmin seem to be 5 digit
>> numbers (32512 for
>> example was the result of a call to the script using a bad
>> filename) I use
>> to always get a value of "1" no matter what.
>>
>> Errors will show up in the debugging, but the steps and job will still
>> always show "success".
>
>Hi Eric,
>
>Sorry for the delay. I just got to look at this some more and found that the return value is actually stored in the
top8 bits of the int returned by pclose(). I've applied suitable patched to convert that back to a signed value and now
getsensible results in my testing. As per convention, any negative value will be seen as a failure.
>
>Raphael; I've committed patches to trunk and 1.4 - any chance you can rustle up another build for Eric to test for us
please?
>
>Thanks, Dave.
>