pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpga_schedule_jscmonthdays_size
2+ messages / 2 participants
[nested] [flat]
* pga_schedule_jscmonthdays_size
@ 2024-04-22 15:35 Tek Wojenski <twojenski@orca1di.com>
0 siblings, 1 reply; 2+ messages in thread
From: Tek Wojenski @ 2024-04-22 15:35 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.*
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pga_schedule_jscmonthdays_size
@ 2024-04-22 15:51 Holger Jakobs <holger@jakobs.com>
parent: Tek Wojenski <twojenski@orca1di.com>
0 siblings, 0 replies; 2+ messages in thread
From: Holger Jakobs @ 2024-04-22 15:51 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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:
OpenPGP_signature (application/pgp-signature, 202B) download
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-04-22 15:51 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-04-22 15:35 pga_schedule_jscmonthdays_size Tek Wojenski <twojenski@orca1di.com>
2024-04-22 15:51 ` Holger Jakobs <holger@jakobs.com>
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