Skip site navigation (1) Skip section navigation (2)

Re: Potential issue with pgAgent when updating pga_jobsteplog

From: "Dave Page" <dpage(at)pgadmin(dot)org>
To: "Benjamin Krajmalnik" <kraj(at)illumen(dot)com>, "PgAdmin Support" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Potential issue with pgAgent when updating pga_jobsteplog
Date: 2008-05-07 07:05:07
Message-ID: 937d27e10805070005x71c6b358x8cb5eb0d479c2f81@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
On Tue, May 6, 2008 at 11:11 PM, Benjamin Krajmalnik <kraj(at)illumen(dot)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

In response to

pgadmin-support by date

Next:From: Dave PageDate: 2008-05-08 10:09:01
Subject: Re: Editing Views with EditGrid
Previous:From: Andreas NeumannDate: 2008-05-06 20:05:44
Subject: Re: Editing Views with EditGrid

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group