| From: | Holger Jakobs <holger(at)jakobs(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: pga_schedule_jscmonthdays_size |
| Date: | 2024-04-22 15:51:50 |
| Message-ID: | ed99923e-3170-5625-b150-3c8b5f15db00@jakobs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Fiske | 2024-04-22 16:01:01 | Re: Set fillfactor to partition child tables |
| Previous Message | Tek Wojenski | 2024-04-22 15:35:39 | pga_schedule_jscmonthdays_size |