Hi Tek,
This issue is reported and team is working on it -
https://github.com/pgadmin-org/pgadmin4/issues/7390
On Mon, Apr 22, 2024 at 9:46 PM Tek Wojenski <twojen...@orca1di.com> wrote:
> 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!
>
> *CONFIDENTIALITY NOTE*
> *This electronic message contains privileged information intended only for
> the use of the individual or entity named above. If the reader of this
> electronic message is not the intended recipient or the employee or agent
> responsible for delivering it to the intended recipient, you are hereby
> notified that any forwarding, storing, printing, dissemination or copying
> of this electronic message is strictly prohibited and may be unlawful. If
> received in error, please do not disclose the contents to anyone, but
> notify the sender by return email and delete this email (and any
> attachments) from your system.*
>
> *Thank you.*
>
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"
