From: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
---|---|
To: | Tek Wojenski <twojenski(at)orca1di(dot)com> |
Cc: | pgadmin-support(at)lists(dot)postgresql(dot)org |
Subject: | Re: pga_schedule_jscmonthdays_size error |
Date: | 2024-04-23 05:47:45 |
Message-ID: | CAM9w-_mdFkMCewCa-dR0vmOP5xmk_GQUdz4ojuQO1a=8R3fGtg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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 <twojenski(at)orca1di(dot)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"
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Strauss | 2024-04-23 14:25:40 | Re: [External Sender] Re: [External Sender] Re: Missing Database in pgadmin4 |
Previous Message | Tek Wojenski | 2024-04-22 16:15:59 | pga_schedule_jscmonthdays_size error |