I'm getting a weird error when trying to schedule a job in pgAgent
[2024-04-22 11:23:17] [23514] ERROR: new row for relation "pga_schedule" violates check constraint "pga_schedule_jscmonthdays_size"
[2024-04-22 11:23:17] Detail: Failing row contains (29, 26, schedule1, , t, 2024-04-21 18:43:00+00, null, {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f..., {t,f,f,f,f,f,f,f,f,f,f,f,t,f,f,f,f,f,f,f,f,f,f,f}, {t,t,t,t,t,t,t}, {f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f,f}, {f,f,f,f,f,f,f,f,f,f,f,f}).
I have the latest pgAgent schema, and using pgAdmin 8.5; Postgres is v13 and running on Ubuntu.
The check it's failing on is: check (array_upper(jscmonthdays, 1) = 32); SQL Insert has only 31 entries and was generated in pgAdmin.
Thanks!