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