Postgres Pro
Downloads
Home   >   mailing lists

PgAdmin 3.5(latest) cannot edit PgAgent's schedules. - Mailing list pgadmin-support

From Eugene Wang
Subject PgAdmin 3.5(latest) cannot edit PgAgent's schedules.
Date
Msg-id CAEsxC1YC2ohiTVNRnVm29YS3TLGYwHeFiq+eVVSP0HUs8Dmy0A@mail.gmail.com
Whole thread Raw
Responses Re: PgAdmin 3.5(latest) cannot edit PgAgent's schedules.
List pgadmin-support
Tree view
Hi Pgadmin team,

When I was trying to edit the time schedule of a PgAgent job, I got an error message like below:

ERROR: malformed array literal: "[false,false,false,false,false,false,false,false,false,false,true,false]"
LINE 7: jscmonths='[false,false,false,false,false,false,false,fa...
^
DETAIL: "[" must introduce explicitly-specified array dimensions.

In the SQL tab, I noticed that PgAdmin interpreted my changes as below in SQL. 

-- Updating the schedule (id: 8, jobid: 6)
UPDATE pgagent.pga_schedule
SET
    jscstart='2018-08-26T22:04:42-04:00'::timestamptz,
    jscmonths='[false,false,false,false,false,false,false,false,false,false,true,false]'::boolean[],
    jscminutes='[false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]'::boolean[],
    jscmonthdays='[false,false,false,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,false]'::boolean[],
    jschours='[false,false,false,false,false,false,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,false]'::boolean[]
WHERE jscid=8::integer AND jscjobid=6::integer;

I think someone could look at it. Thank you very much in advance.

Best,

Eugene  


Yujie Wang (Welcome to call me Eugene, for your pronunciation convenience)  
GIS Developer
Connected2fiber

pgadmin-support by date:

Previous
From: Aditya Toshniwal
Date:
Subject: Re: The application server could not be contacted
Next
From: Eugene Wang
Date:
Subject: Re: PgAdmin 3.5(latest) cannot edit PgAgent's schedules.