pgadmin-org / pgagent

pgAgent - A job scheduler for PostgreSQL
https://www.pgadmin.org/
Other
97 stars 41 forks source link

new row for relation "pga_schedule" violates check constraint "pga_schedule_jscmonthdays_size" #36

Open mostafasharafi opened 3 months ago

mostafasharafi commented 3 months ago
  1. postgres : psql (14.2 (Debian 14.2-1.pgdg110+1), server 14.10 (Debian 14.10-1.pgdg110+1))
  2. pgadmin4 : Version 8.5
  3. pgagent 4.2.2

i think there is a mistake in pga_schedule_jscmonthdays_size CONSTRAINT : ALTER TABLE pgagent.pga_schedule ADD CONSTRAINT pga_schedule_jscmonthdays_size CHECK ((array_upper(jscmonthdays, 1) = 32))

if check TRUE then insert is OK , but there is no any month with 32 days !

??