Re: Potential issue with pgAgent when updating pga_jobsteplog

Via pgAdmin, going into the pgagent catalog, I do not have an option of
changing the column type to int4.

> -----Original Message-----
> From: Dave Page [mailto:dpage@pgadmin.org] 
> Sent: Tuesday, May 06, 2008 4:57 AM
> To: Benjamin Krajmalnik
> Cc: pgadmin-support@postgresql.org
> Subject: Re: [pgadmin-support] Potential issue with pgAgent 
> when updating pga_jobsteplog
> 
> On Mon, May 5, 2008 at 4:57 PM, Benjamin Krajmalnik 
>  wrote:
> >
> > I believe one of 2 things probably needs to be done:
> >
> > 1.  Update the documentation to mention what range the 
> result needs to be.
> > This means that queries which affect many rows need to be 
> encapsulated 
> > in a stored procedure or have a supplementary query such as 
> "select 1" 
> > added to the step in order to return an in-range value 2.  Change 
> > jslresult to a data type which will accomodate a larger value.
> 
> I've gone with the second option and increased the jslresult 
> column to be an int4 (matching the C++ code). You should be 
> able to increase the column size on your server as no other 
> code changes are required.
> 
> Thanks, Dave
> 
> --
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
>