From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: pga_schedule_jscmonthdays_size
Date: Mon, 22 Apr 2024 17:51:50 +0200
Message-ID: <ed99923e-3170-5625-b150-3c8b5f15db00@jakobs.com> (raw)
In-Reply-To: <CAGNmymdmEqhkT+VtPpjg1MwU2BF0e0GzzXYNzDUzLEXh3HSfUw@mail.gmail.com>
References: <CAGNmymdmEqhkT+VtPpjg1MwU2BF0e0GzzXYNzDUzLEXh3HSfUw@mail.gmail.com>
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
Attachments:
[application/pgp-signature] OpenPGP_signature (202B, ../ed99923e-3170-5625-b150-3c8b5f15db00@jakobs.com/2-OpenPGP_signature)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com, pgsql-admin@lists.postgresql.org
Subject: Re: pga_schedule_jscmonthdays_size
In-Reply-To: <ed99923e-3170-5625-b150-3c8b5f15db00@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox