Re: pga_schedule_jscmonthdays_size

[Holger Jakobs <holger@xxxxxxxxxx>]

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

Attachment: OpenPGP_signature
Description: OpenPGP digital signature