Am 22.04.24 um 17:35 schrieb Tek Wojenski:
> 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!
>
Since pgAgent is part of pgAdmin - and NOT a part of the postgresql
server - it might be best to ask on the appropriate list.
--
Holger Jakobs, Bergisch Gladbach