Re: Potential issue with pgAgent when updating pga_jobsteplog - Mailing list pgadmin-support

From Dave Page
Subject Re: Potential issue with pgAgent when updating pga_jobsteplog
Date
Msg-id 937d27e10805070005x71c6b358x8cb5eb0d479c2f81@mail.gmail.com
Whole thread Raw
In response to Potential issue with pgAgent when updating pga_jobsteplog  ("Benjamin Krajmalnik" <kraj@illumen.com>)
List pgadmin-support
On Tue, May 6, 2008 at 11:11 PM, Benjamin Krajmalnik <kraj@illumen.com> wrote:
> What query should I issue to change this.  Not sure since it is a system
> catalog.

It's not really a catalog - it's only pgAdmin that treats it as one.

Something like this (untested) should do:

ALTER TABLE pgagent.pga_jobsteplog ALTER COLUMN jslresult TYPE int4;

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


pgadmin-support by date:

Previous
From: Andreas Neumann
Date:
Subject: Re: Editing Views with EditGrid
Next
From: "Dave Page"
Date:
Subject: Re: Editing Views with EditGrid