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