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

[mostafasharafi]

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 !

??

[akshay-joshi]

@mostafasharafi

Have you faced any issues? If yes can you please elaborate?
As per my understanding, 32 is (31 days + Last day option is also there)