- postgres : psql (14.2 (Debian 14.2-1.pgdg110+1), server 14.10 (Debian 14.10-1.pgdg110+1))
- pgadmin4 : Version 8.5
- 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 !
??
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 !
??