On Tue, May 6, 2008 at 11:11 PM, Benjamin Krajmalnik <[EMAIL PROTECTED]> 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