| From: | Eugene Wang <eugenewangfw(at)gmail(dot)com> |
|---|---|
| To: | pgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | PgAdmin 3.5(latest) cannot edit PgAgent's schedules. |
| Date: | 2018-11-13 15:45:46 |
| Message-ID: | CAEsxC1YC2ohiTVNRnVm29YS3TLGYwHeFiq+eVVSP0HUs8Dmy0A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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
Linkedin : https://www.linkedin.com/in/yujie-wang-61a129a0/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eugene Wang | 2018-11-13 15:55:55 | Re: PgAdmin 3.5(latest) cannot edit PgAgent's schedules. |
| Previous Message | Aditya Toshniwal | 2018-11-13 04:28:06 | Re: The application server could not be contacted |