Re: [pgadmin-support] pgAgent reports failure upon success

2012-07-09 Thread Martin French
Proposed patch for this bug in attached files.(See attached file: connection.cpp)(See attached file: connection.h)(See attached file: job.cpp)Tested against PG 9.1.4, all seems fine, success/failure reported correctly even when multiple jobs ran concurrently.Please test and feed back.Thanks.pgadmin

Re: [pgadmin-support] pgAgent reports failure upon success

2012-07-09 Thread Dave Page
Hi On Mon, Jul 9, 2012 at 10:11 AM, Martin French wrote: > Proposed patch for this bug in attached files. > > (See attached file: connection.cpp)(See attached file: connection.h)(See > attached file: job.cpp) > > Tested against PG 9.1.4, all seems fine, success/failure reported correctly > even w

Re: [pgadmin-support] pgAgent reports failure upon success

2012-07-09 Thread Martin French
Apologies wrong files attached! It is Monday after all... ;o)(See attached file: connection.cpp.patch)(See attached file: connection.h.patch)(See attached file: job.cpp.patch)CheersDave Page wrote on 09/07/2012 10:16:47:> From: Dave Page > To: Martin French , > Cc: pgadmin-support@postgresql.org,

Re: [pgadmin-support] pgAgent reports failure upon success

2012-07-09 Thread Martin French
Tree Diff. diff -r pgAgent-3.2.1-Source pgAgent-3.2.2-Sourcediff -r pgAgent-3.2.1-Source/connection.cpp pgAgent-3.2.2-Source/connection.cpp28a29>       lastStatus = 0;339a341>               {340a343,344>                       conn->SetLastResult(0);>               }344a349>                       co

[pgadmin-support] Create or Update Function

2012-07-09 Thread Steve Erickson
I've got a script to update the schema on a number of servers. These servers are at various versions of the schema, so I used the following syntax for each function, not knowing if it needed to be created or merely updated: CREATE OR REPLACE FUNCTION foo() . But I get the error, "function

Re: [pgadmin-support] Create or Update Function

2012-07-09 Thread Craig Ringer
On 07/10/2012 04:28 AM, Steve Erickson wrote: I've got a script to update the schema on a number of servers. These servers are at various versions of the schema, so I used the following syntax for each function, not knowing if it needed to be created or merely updated: CREATE OR REPLACE FU