Re: Potential issue with pgAgent when updating pga_jobsteplog
by dpage@[EMAIL PROTECTED]
("Dave Page")
May 7, 2008 at 08:05 AM
On Tue, May 6, 2008 at 11:11 PM, Benjamin Krajmalnik <kraj@[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-sup****t mailing list (pgadmin-sup****t@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-sup****t
