Hi Eugene, Would you please share the version of pgAdmin 4?
-- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company <http://www.enterprisedb.com> *http://www.linkedin.com/in/asheshvashi* <http://www.linkedin.com/in/asheshvashi> On Tue, Nov 13, 2018 at 9:26 PM Eugene Wang <eugenewan...@gmail.com> wrote: > An update: > > Errors not only happened on changing time schedules, but also happened on > creating schedules now. > > Since I cannot edit the time schedule, I tried to removed and create a new > schedule for the existed job. I successfully removed the old schedule and > got an error message like below: > > ERROR: syntax error at or near "INTO" > LINE 19: ) RETURNING jscid INTO scid; > ^ > > Here comes the interpreted SQL codes. The error happened at the very last > line: ```) RETURNING jscid INTO scid;``` . > > -- Inserting a schedule (jobid: 6) > INSERT INTO pgagent.pga_schedule( > jscjobid, jscname, jscdesc, jscenabled, > jscstart, jscminutes, jschours, jscweekdays, jscmonthdays, > jscmonths > ) VALUES ( > 6, 'onetime test'::text, ''::text, true, > '2018-11-13 10:47:36 -05:00'::timestamp with time zone, > -- Minutes > > ARRAY[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,false,false,false,false,false,false,false,false,false,false,false,false,false,true,false,false,false,false,false,false,false,false,false]::boolean[], > -- Hours > > ARRAY[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[], > -- Week days > ARRAY[false,false,false,false,false,false,false]::boolean[], > -- Month days > > ARRAY[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[], > -- Months > > ARRAY[false,false,false,false,false,false,false,false,false,false,true,false]::boolean[] > ) RETURNING jscid INTO scid; > > Eugene > > > On Tue, Nov 13, 2018 at 10:45 AM Eugene Wang <eugenewan...@gmail.com> > wrote: > >> 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/ >> >
