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

--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support